-
Notifications
You must be signed in to change notification settings - Fork 8
/
Copy pathVACUUM FirstRate 30min delta tables.py
1344 lines (1330 loc) · 44.1 KB
/
VACUUM FirstRate 30min delta tables.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
# Databricks notebook source
%sql
use deltabase;
# COMMAND ----------
%sql
-- Use this when we need to manually vacuum
set spark.databricks.delta.retentionDurationCheck.enabled = False;
-- Use this when we don't need to manually vacuum
--set spark.databricks.delta.retentionDurationCheck.enabled = True;
# COMMAND ----------
%sql
--vacuum aap_30min_delta retain 0 hours dry run
# COMMAND ----------
%sql
VACUUM aapl_30min_delta;
vacuum aa_30min_delta;
vacuum aal_30min_delta;
vacuum aap_30min_delta;
vacuum a_30min_delta;
vacuum abbv_30min_delta;
vacuum abc_30min_delta;
vacuum abmd_30min_delta;
vacuum abt_30min_delta;
vacuum acn_30min_delta;
vacuum acv_30min_delta;
vacuum adbe_30min_delta;
vacuum adi_30min_delta;
vacuum adm_30min_delta;
vacuum adp_30min_delta;
vacuum ads_30min_delta;
vacuum adsk_30min_delta;
vacuum adt_30min_delta;
vacuum aee_30min_delta;
vacuum aep_30min_delta;
vacuum aes_30min_delta;
vacuum afl_30min_delta;
vacuum aig_30min_delta;
vacuum ainv_30min_delta;
vacuum aiv_30min_delta;
vacuum aiz_30min_delta;
vacuum ajg_30min_delta;
vacuum akam_30min_delta;
vacuum alb_30min_delta;
vacuum algn_30min_delta;
vacuum alk_30min_delta;
vacuum all_30min_delta;
vacuum alle_30min_delta;
vacuum altr_30min_delta;
vacuum amat_30min_delta;
vacuum ambc_30min_delta;
vacuum amcr_30min_delta;
vacuum amd_30min_delta;
vacuum ame_30min_delta;
vacuum amg_30min_delta;
vacuum amgn_30min_delta;
vacuum amp_30min_delta;
vacuum amt_30min_delta;
vacuum amzn_30min_delta;
vacuum an_30min_delta;
vacuum anet_30min_delta;
vacuum anf_30min_delta;
vacuum anss_30min_delta;
vacuum antm_30min_delta;
vacuum aon_30min_delta;
vacuum aos_30min_delta;
vacuum apa_30min_delta;
vacuum apd_30min_delta;
vacuum aph_30min_delta;
vacuum aptv_30min_delta;
vacuum are_30min_delta;
vacuum arnc_30min_delta;
vacuum ash_30min_delta;
vacuum aso_30min_delta;
vacuum atge_30min_delta;
vacuum ati_30min_delta;
vacuum ato_30min_delta;
vacuum atvi_30min_delta;
vacuum avb_30min_delta;
vacuum avgo_30min_delta;
vacuum avy_30min_delta;
vacuum awk_30min_delta;
vacuum axp_30min_delta;
vacuum ayi_30min_delta;
vacuum azo_30min_delta;
vacuum ba_30min_delta;
vacuum bac_30min_delta;
vacuum bax_30min_delta;
vacuum bbby_30min_delta;
vacuum bby_30min_delta;
vacuum bc_30min_delta;
vacuum bdx_30min_delta;
vacuum ben_30min_delta;
vacuum bfb_30min_delta;
vacuum bidu_30min_delta;
vacuum big_30min_delta;
vacuum biib_30min_delta;
vacuum bio_30min_delta;
vacuum bk_30min_delta;
vacuum bkng_30min_delta;
vacuum blk_30min_delta;
vacuum bll_30min_delta;
vacuum bmrn_30min_delta;
vacuum bmy_30min_delta;
vacuum br_30min_delta;
vacuum brkb_30min_delta;
vacuum bro_30min_delta;
vacuum bsx_30min_delta;
vacuum btu_30min_delta;
vacuum bud_30min_delta;
vacuum bwa_30min_delta;
vacuum bxp_30min_delta;
vacuum c_30min_delta;
vacuum cag_30min_delta;
vacuum cah_30min_delta;
vacuum car_30min_delta;
vacuum carr_30min_delta;
vacuum cat_30min_delta;
vacuum cb_30min_delta;
vacuum cbh_30min_delta;
vacuum cboe_30min_delta;
vacuum cbre_30min_delta;
vacuum cc_30min_delta;
vacuum cci_30min_delta;
vacuum cck_30min_delta;
vacuum ccl_30min_delta;
vacuum ccu_30min_delta;
vacuum cday_30min_delta;
vacuum cdns_30min_delta;
vacuum cdw_30min_delta;
vacuum ce_30min_delta;
vacuum cern_30min_delta;
vacuum cf_30min_delta;
vacuum cfg_30min_delta;
vacuum chd_30min_delta;
vacuum chir_30min_delta;
vacuum chk_30min_delta;
vacuum chkp_30min_delta;
vacuum chrw_30min_delta;
vacuum chtr_30min_delta;
vacuum ci_30min_delta;
vacuum cien_30min_delta;
vacuum cinf_30min_delta;
vacuum cit_30min_delta;
vacuum cl_30min_delta;
vacuum clf_30min_delta;
vacuum clx_30min_delta;
vacuum cma_30min_delta;
vacuum cmcsa_30min_delta;
vacuum cme_30min_delta;
vacuum cmg_30min_delta;
vacuum cmi_30min_delta;
vacuum cms_30min_delta;
vacuum cnc_30min_delta;
vacuum cnp_30min_delta;
vacuum cnx_30min_delta;
vacuum cof_30min_delta;
vacuum coo_30min_delta;
vacuum coop_30min_delta;
vacuum cop_30min_delta;
vacuum cost_30min_delta;
vacuum coty_30min_delta;
vacuum cpb_30min_delta;
vacuum cpri_30min_delta;
vacuum cprt_30min_delta;
vacuum cpt_30min_delta;
vacuum crm_30min_delta;
vacuum csco_30min_delta;
vacuum csx_30min_delta;
vacuum ctas_30min_delta;
vacuum ctlt_30min_delta;
vacuum ctsh_30min_delta;
vacuum ctva_30min_delta;
vacuum ctxs_30min_delta;
vacuum cvs_30min_delta;
vacuum cvx_30min_delta;
vacuum czr_30min_delta;
vacuum d_30min_delta;
vacuum dal_30min_delta;
vacuum dan_30min_delta;
vacuum dd_30min_delta;
vacuum dds_30min_delta;
vacuum de_30min_delta;
vacuum dell_30min_delta;
vacuum dfs_30min_delta;
vacuum dg_30min_delta;
vacuum dgx_30min_delta;
vacuum dhi_30min_delta;
vacuum dhr_30min_delta;
vacuum dis_30min_delta;
vacuum disca_30min_delta;
vacuum disck_30min_delta;
vacuum dish_30min_delta;
vacuum dlr_30min_delta;
vacuum dltr_30min_delta;
vacuum dlx_30min_delta;
vacuum dnb_30min_delta;
vacuum dov_30min_delta;
vacuum dow_30min_delta;
vacuum dpz_30min_delta;
vacuum dre_30min_delta;
vacuum dri_30min_delta;
vacuum dte_30min_delta;
vacuum duk_30min_delta;
vacuum dva_30min_delta;
vacuum dvn_30min_delta;
vacuum dxc_30min_delta;
vacuum dxcm_30min_delta;
vacuum ea_30min_delta;
vacuum ebay_30min_delta;
vacuum ecl_30min_delta;
vacuum ed_30min_delta;
vacuum efx_30min_delta;
vacuum eix_30min_delta;
vacuum el_30min_delta;
vacuum emn_30min_delta;
vacuum emr_30min_delta;
vacuum endp_30min_delta;
vacuum enph_30min_delta;
vacuum eog_30min_delta;
vacuum epam_30min_delta;
vacuum eq_30min_delta;
vacuum eqix_30min_delta;
vacuum eqr_30min_delta;
vacuum eqt_30min_delta;
vacuum es_30min_delta;
vacuum ess_30min_delta;
vacuum etn_30min_delta;
vacuum etr_30min_delta;
vacuum etsy_30min_delta;
vacuum evrg_30min_delta;
vacuum ew_30min_delta;
vacuum exc_30min_delta;
vacuum expd_30min_delta;
vacuum expe_30min_delta;
vacuum exr_30min_delta;
vacuum f_30min_delta;
vacuum fang_30min_delta;
vacuum fast_30min_delta;
vacuum fb_30min_delta;
vacuum fbhs_30min_delta;
vacuum fcx_30min_delta;
vacuum fds_30min_delta;
vacuum fdx_30min_delta;
vacuum fe_30min_delta;
vacuum ffiv_30min_delta;
vacuum fhn_30min_delta;
vacuum fis_30min_delta;
vacuum fisv_30min_delta;
vacuum fitb_30min_delta;
vacuum fl_30min_delta;
vacuum flex_30min_delta;
vacuum flr_30min_delta;
vacuum fls_30min_delta;
vacuum flt_30min_delta;
vacuum fmc_30min_delta;
vacuum fosl_30min_delta;
vacuum fox_30min_delta;
vacuum foxa_30min_delta;
vacuum fpl_30min_delta;
vacuum frc_30min_delta;
vacuum frt_30min_delta;
vacuum fslr_30min_delta;
vacuum fti_30min_delta;
vacuum ftnt_30min_delta;
vacuum ftv_30min_delta;
vacuum gci_30min_delta;
vacuum gd_30min_delta;
vacuum ge_30min_delta;
vacuum ghc_30min_delta;
vacuum gild_30min_delta;
vacuum gis_30min_delta;
vacuum gl_30min_delta;
vacuum glw_30min_delta;
vacuum gm_30min_delta;
vacuum gme_30min_delta;
vacuum gnrc_30min_delta;
vacuum gnw_30min_delta;
vacuum goog_30min_delta;
vacuum googl_30min_delta;
vacuum gp_30min_delta;
vacuum gpc_30min_delta;
vacuum gpn_30min_delta;
vacuum gps_30min_delta;
vacuum grmn_30min_delta;
vacuum gs_30min_delta;
vacuum gt_30min_delta;
vacuum gww_30min_delta;
vacuum hal_30min_delta;
vacuum has_30min_delta;
vacuum hban_30min_delta;
vacuum hbi_30min_delta;
vacuum hca_30min_delta;
vacuum hd_30min_delta;
vacuum hes_30min_delta;
vacuum hfc_30min_delta;
vacuum hig_30min_delta;
vacuum hii_30min_delta;
vacuum hlt_30min_delta;
vacuum hog_30min_delta;
vacuum holx_30min_delta;
vacuum hon_30min_delta;
vacuum hp_30min_delta;
vacuum hpe_30min_delta;
vacuum hpq_30min_delta;
vacuum hrb_30min_delta;
vacuum hrl_30min_delta;
vacuum hsic_30min_delta;
vacuum hst_30min_delta;
vacuum hsy_30min_delta;
vacuum hum_30min_delta;
vacuum iac_30min_delta;
vacuum ibm_30min_delta;
vacuum ice_30min_delta;
vacuum idxx_30min_delta;
vacuum iex_30min_delta;
vacuum iff_30min_delta;
vacuum igt_30min_delta;
vacuum ihrt_30min_delta;
vacuum ilmn_30min_delta;
vacuum incy_30min_delta;
vacuum info_30min_delta;
vacuum infy_30min_delta;
vacuum intc_30min_delta;
vacuum intu_30min_delta;
vacuum ip_30min_delta;
vacuum ipg_30min_delta;
vacuum ipgp_30min_delta;
vacuum iqv_30min_delta;
vacuum ir_30min_delta;
vacuum irm_30min_delta;
vacuum isrg_30min_delta;
vacuum it_30min_delta;
vacuum itt_30min_delta;
vacuum itw_30min_delta;
vacuum ivz_30min_delta;
vacuum j_30min_delta;
vacuum jbht_30min_delta;
vacuum jbl_30min_delta;
vacuum jci_30min_delta;
vacuum jd_30min_delta;
vacuum jef_30min_delta;
vacuum jkhy_30min_delta;
vacuum jnj_30min_delta;
vacuum jnpr_30min_delta;
vacuum jp_30min_delta;
vacuum jpm_30min_delta;
vacuum jwn_30min_delta;
vacuum k_30min_delta;
vacuum kbh_30min_delta;
vacuum key_30min_delta;
vacuum keys_30min_delta;
vacuum khc_30min_delta;
vacuum kim_30min_delta;
vacuum klac_30min_delta;
vacuum kmb_30min_delta;
vacuum kmi_30min_delta;
vacuum kmx_30min_delta;
vacuum ko_30min_delta;
vacuum kodk_30min_delta;
vacuum kr_30min_delta;
vacuum kss_30min_delta;
vacuum ksu_30min_delta;
vacuum l_30min_delta;
vacuum lbtyk_30min_delta;
vacuum ldos_30min_delta;
vacuum leg_30min_delta;
vacuum len_30min_delta;
vacuum lh_30min_delta;
vacuum lhx_30min_delta;
vacuum life_30min_delta;
vacuum lin_30min_delta;
vacuum lkq_30min_delta;
vacuum lly_30min_delta;
vacuum lmt_30min_delta;
vacuum lnc_30min_delta;
vacuum lnt_30min_delta;
vacuum logi_30min_delta;
vacuum low_30min_delta;
vacuum lrcx_30min_delta;
vacuum lsi_30min_delta;
vacuum lu_30min_delta;
vacuum lumn_30min_delta;
vacuum luv_30min_delta;
vacuum lvs_30min_delta;
vacuum lw_30min_delta;
vacuum lyb_30min_delta;
vacuum lyv_30min_delta;
vacuum m_30min_delta;
vacuum ma_30min_delta;
vacuum maa_30min_delta;
vacuum mac_30min_delta;
vacuum mar_30min_delta;
vacuum mas_30min_delta;
vacuum mat_30min_delta;
vacuum mbi_30min_delta;
vacuum mcd_30min_delta;
vacuum mchp_30min_delta;
vacuum mck_30min_delta;
vacuum mco_30min_delta;
vacuum mdlz_30min_delta;
vacuum mdp_30min_delta;
vacuum mdt_30min_delta;
vacuum met_30min_delta;
vacuum mgm_30min_delta;
vacuum mhk_30min_delta;
vacuum mkc_30min_delta;
vacuum mktx_30min_delta;
vacuum mlm_30min_delta;
vacuum mmc_30min_delta;
vacuum mmi_30min_delta;
vacuum mmm_30min_delta;
vacuum mnst_30min_delta;
vacuum mo_30min_delta;
vacuum moh_30min_delta;
vacuum mos_30min_delta;
vacuum mpc_30min_delta;
vacuum mpwr_30min_delta;
vacuum mrk_30min_delta;
vacuum mro_30min_delta;
vacuum mrvl_30min_delta;
vacuum ms_30min_delta;
vacuum msci_30min_delta;
vacuum msft_30min_delta;
vacuum msi_30min_delta;
vacuum mtb_30min_delta;
vacuum mtch_30min_delta;
vacuum mtd_30min_delta;
vacuum mtw_30min_delta;
vacuum mu_30min_delta;
vacuum mur_30min_delta;
vacuum navi_30min_delta;
vacuum nbr_30min_delta;
vacuum nclh_30min_delta;
vacuum ndaq_30min_delta;
vacuum ndsn_30min_delta;
vacuum ne_30min_delta;
vacuum nee_30min_delta;
vacuum nem_30min_delta;
vacuum nflx_30min_delta;
vacuum ni_30min_delta;
vacuum nke_30min_delta;
vacuum nktr_30min_delta;
vacuum nlok_30min_delta;
vacuum nlsn_30min_delta;
vacuum noc_30min_delta;
vacuum nov_30min_delta;
vacuum now_30min_delta;
vacuum nrg_30min_delta;
vacuum nsc_30min_delta;
vacuum ntap_30min_delta;
vacuum ntes_30min_delta;
vacuum ntrs_30min_delta;
vacuum nue_30min_delta;
vacuum nvda_30min_delta;
vacuum nvr_30min_delta;
vacuum nwl_30min_delta;
vacuum nws_30min_delta;
vacuum nwsa_30min_delta;
vacuum nxpi_30min_delta;
vacuum nyt_30min_delta;
vacuum o_30min_delta;
vacuum odfl_30min_delta;
vacuum odp_30min_delta;
vacuum ogn_30min_delta;
vacuum oi_30min_delta;
vacuum oke_30min_delta;
vacuum omc_30min_delta;
vacuum one_30min_delta;
vacuum orcl_30min_delta;
vacuum orly_30min_delta;
vacuum otis_30min_delta;
vacuum oxy_30min_delta;
vacuum par_30min_delta;
vacuum payc_30min_delta;
vacuum payx_30min_delta;
vacuum pbct_30min_delta;
vacuum pbi_30min_delta;
vacuum pcar_30min_delta;
vacuum pcg_30min_delta;
vacuum pdco_30min_delta;
vacuum peak_30min_delta;
vacuum peg_30min_delta;
vacuum penn_30min_delta;
vacuum pep_30min_delta;
vacuum pfe_30min_delta;
vacuum pfg_30min_delta;
vacuum pg_30min_delta;
vacuum pgr_30min_delta;
vacuum ph_30min_delta;
vacuum phm_30min_delta;
vacuum pkg_30min_delta;
vacuum pki_30min_delta;
vacuum pld_30min_delta;
vacuum pll_30min_delta;
vacuum pm_30min_delta;
vacuum pnc_30min_delta;
vacuum pnr_30min_delta;
vacuum pnw_30min_delta;
vacuum pool_30min_delta;
vacuum ppg_30min_delta;
vacuum ppl_30min_delta;
vacuum prgo_30min_delta;
vacuum pri_30min_delta;
vacuum pru_30min_delta;
vacuum psa_30min_delta;
vacuum psx_30min_delta;
vacuum ptc_30min_delta;
vacuum pvh_30min_delta;
vacuum pwr_30min_delta;
vacuum pxd_30min_delta;
vacuum pypl_30min_delta;
vacuum qcom_30min_delta;
vacuum qgen_30min_delta;
vacuum qrvo_30min_delta;
vacuum r_30min_delta;
vacuum rcl_30min_delta;
vacuum re_30min_delta;
vacuum reg_30min_delta;
vacuum regn_30min_delta;
vacuum rf_30min_delta;
vacuum rhi_30min_delta;
vacuum rig_30min_delta;
vacuum rjf_30min_delta;
vacuum rl_30min_delta;
vacuum rlgy_30min_delta;
vacuum rmd_30min_delta;
vacuum rok_30min_delta;
vacuum rol_30min_delta;
vacuum rop_30min_delta;
vacuum rost_30min_delta;
vacuum rrc_30min_delta;
vacuum rrd_30min_delta;
vacuum rsg_30min_delta;
vacuum rtx_30min_delta;
vacuum ryaay_30min_delta;
vacuum s_30min_delta;
vacuum saic_30min_delta;
vacuum sanm_30min_delta;
vacuum sbac_30min_delta;
vacuum sbny_30min_delta;
vacuum sbux_30min_delta;
vacuum schw_30min_delta;
vacuum se_30min_delta;
vacuum sedg_30min_delta;
vacuum see_30min_delta;
vacuum shw_30min_delta;
vacuum sig_30min_delta;
vacuum siri_30min_delta;
vacuum sitc_30min_delta;
vacuum sivb_30min_delta;
vacuum sjm_30min_delta;
vacuum slb_30min_delta;
vacuum slg_30min_delta;
vacuum slm_30min_delta;
vacuum sna_30min_delta;
vacuum snps_30min_delta;
vacuum so_30min_delta;
vacuum spg_30min_delta;
vacuum spgi_30min_delta;
vacuum srcl_30min_delta;
vacuum sre_30min_delta;
vacuum ssp_30min_delta;
vacuum ste_30min_delta;
vacuum stt_30min_delta;
vacuum stx_30min_delta;
vacuum stz_30min_delta;
vacuum sun_30min_delta;
vacuum swk_30min_delta;
vacuum swks_30min_delta;
vacuum swn_30min_delta;
vacuum syf_30min_delta;
vacuum syk_30min_delta;
vacuum syy_30min_delta;
vacuum t_30min_delta;
vacuum tap_30min_delta;
vacuum tdc_30min_delta;
vacuum tdg_30min_delta;
vacuum tdy_30min_delta;
vacuum tel_30min_delta;
vacuum ter_30min_delta;
vacuum teva_30min_delta;
vacuum tex_30min_delta;
vacuum tfc_30min_delta;
vacuum tfx_30min_delta;
vacuum tgna_30min_delta;
vacuum tgt_30min_delta;
vacuum thc_30min_delta;
vacuum tjx_30min_delta;
vacuum tmo_30min_delta;
vacuum tmus_30min_delta;
vacuum tpr_30min_delta;
vacuum trip_30min_delta;
vacuum trmb_30min_delta;
vacuum trow_30min_delta;
vacuum trv_30min_delta;
vacuum tsco_30min_delta;
vacuum tsla_30min_delta;
vacuum tsn_30min_delta;
vacuum ttwo_30min_delta;
vacuum tup_30min_delta;
vacuum twtr_30min_delta;
vacuum txn_30min_delta;
vacuum txt_30min_delta;
vacuum tyl_30min_delta;
vacuum ua_30min_delta;
vacuum uaa_30min_delta;
vacuum ual_30min_delta;
vacuum ucl_30min_delta;
vacuum udr_30min_delta;
vacuum uhs_30min_delta;
vacuum ulta_30min_delta;
vacuum unh_30min_delta;
vacuum unm_30min_delta;
vacuum unp_30min_delta;
vacuum upc_30min_delta;
vacuum ups_30min_delta;
vacuum urbn_30min_delta;
vacuum uri_30min_delta;
vacuum usb_30min_delta;
vacuum v_30min_delta;
vacuum val_30min_delta;
vacuum vfc_30min_delta;
vacuum viav_30min_delta;
vacuum vlo_30min_delta;
vacuum vmc_30min_delta;
vacuum vno_30min_delta;
vacuum vnt_30min_delta;
vacuum vod_30min_delta;
vacuum vrsk_30min_delta;
vacuum vrsn_30min_delta;
vacuum vrts_30min_delta;
vacuum vrtx_30min_delta;
vacuum vtr_30min_delta;
vacuum vtrs_30min_delta;
vacuum vz_30min_delta;
vacuum wab_30min_delta;
vacuum wat_30min_delta;
vacuum wba_30min_delta;
vacuum wdc_30min_delta;
vacuum wec_30min_delta;
vacuum well_30min_delta;
vacuum wfc_30min_delta;
vacuum whr_30min_delta;
vacuum wltw_30min_delta;
vacuum wm_30min_delta;
vacuum wmb_30min_delta;
vacuum wmt_30min_delta;
vacuum wor_30min_delta;
vacuum wrb_30min_delta;
vacuum wrk_30min_delta;
vacuum wst_30min_delta;
vacuum wu_30min_delta;
vacuum wy_30min_delta;
vacuum wynn_30min_delta;
vacuum x_30min_delta;
vacuum xel_30min_delta;
vacuum xlnx_30min_delta;
vacuum xom_30min_delta;
vacuum xray_30min_delta;
vacuum xrx_30min_delta;
vacuum xyl_30min_delta;
vacuum yum_30min_delta;
vacuum zbh_30min_delta;
vacuum zbra_30min_delta;
vacuum zion_30min_delta;
vacuum zts_30min_delta;
# COMMAND ----------
%sql
vacuum aapl_30min_delta dry run;
vacuum aa_30min_delta dry run;
vacuum aal_30min_delta dry run;
vacuum aap_30min_delta dry run;
vacuum a_30min_delta dry run;
vacuum abbv_30min_delta dry run;
vacuum abc_30min_delta dry run;
vacuum abmd_30min_delta dry run;
vacuum abt_30min_delta dry run;
vacuum acn_30min_delta dry run;
vacuum acv_30min_delta dry run;
vacuum adbe_30min_delta dry run;
vacuum adi_30min_delta dry run;
vacuum adm_30min_delta dry run;
vacuum adp_30min_delta dry run;
vacuum ads_30min_delta dry run;
vacuum adsk_30min_delta dry run;
vacuum adt_30min_delta dry run;
vacuum aee_30min_delta dry run;
vacuum aep_30min_delta dry run;
vacuum aes_30min_delta dry run;
vacuum afl_30min_delta dry run;
vacuum aig_30min_delta dry run;
vacuum ainv_30min_delta dry run;
vacuum aiv_30min_delta dry run;
vacuum aiz_30min_delta dry run;
vacuum ajg_30min_delta dry run;
vacuum akam_30min_delta dry run;
vacuum alb_30min_delta dry run;
vacuum algn_30min_delta dry run;
vacuum alk_30min_delta dry run;
vacuum all_30min_delta dry run;
vacuum alle_30min_delta dry run;
vacuum altr_30min_delta dry run;
vacuum amat_30min_delta dry run;
vacuum ambc_30min_delta dry run;
vacuum amcr_30min_delta dry run;
vacuum amd_30min_delta dry run;
vacuum ame_30min_delta dry run;
vacuum amg_30min_delta dry run;
vacuum amgn_30min_delta dry run;
vacuum amp_30min_delta dry run;
vacuum amt_30min_delta dry run;
vacuum amzn_30min_delta dry run;
vacuum an_30min_delta dry run;
vacuum anet_30min_delta dry run;
vacuum anf_30min_delta dry run;
vacuum anss_30min_delta dry run;
vacuum antm_30min_delta dry run;
vacuum aon_30min_delta dry run;
vacuum aos_30min_delta dry run;
vacuum apa_30min_delta dry run;
vacuum apd_30min_delta dry run;
vacuum aph_30min_delta dry run;
vacuum aptv_30min_delta dry run;
vacuum are_30min_delta dry run;
vacuum arnc_30min_delta dry run;
vacuum ash_30min_delta dry run;
vacuum aso_30min_delta dry run;
vacuum atge_30min_delta dry run;
vacuum ati_30min_delta dry run;
vacuum ato_30min_delta dry run;
vacuum atvi_30min_delta dry run;
vacuum avb_30min_delta dry run;
vacuum avgo_30min_delta dry run;
vacuum avy_30min_delta dry run;
vacuum awk_30min_delta dry run;
vacuum axp_30min_delta dry run;
vacuum ayi_30min_delta dry run;
vacuum azo_30min_delta dry run;
vacuum ba_30min_delta dry run;
vacuum bac_30min_delta dry run;
vacuum bax_30min_delta dry run;
vacuum bbby_30min_delta dry run;
vacuum bby_30min_delta dry run;
vacuum bc_30min_delta dry run;
vacuum bdx_30min_delta dry run;
vacuum ben_30min_delta dry run;
vacuum bfb_30min_delta dry run;
vacuum bidu_30min_delta dry run;
vacuum big_30min_delta dry run;
vacuum biib_30min_delta dry run;
vacuum bio_30min_delta dry run;
vacuum bk_30min_delta dry run;
vacuum bkng_30min_delta dry run;
vacuum blk_30min_delta dry run;
vacuum bll_30min_delta dry run;
vacuum bmrn_30min_delta dry run;
vacuum bmy_30min_delta dry run;
vacuum br_30min_delta dry run;
vacuum brkb_30min_delta dry run;
vacuum bro_30min_delta dry run;
vacuum bsx_30min_delta dry run;
vacuum btu_30min_delta dry run;
vacuum bud_30min_delta dry run;
vacuum bwa_30min_delta dry run;
vacuum bxp_30min_delta dry run;
vacuum c_30min_delta dry run;
vacuum cag_30min_delta dry run;
vacuum cah_30min_delta dry run;
vacuum car_30min_delta dry run;
vacuum carr_30min_delta dry run;
vacuum cat_30min_delta dry run;
vacuum cb_30min_delta dry run;
vacuum cbh_30min_delta dry run;
vacuum cboe_30min_delta dry run;
vacuum cbre_30min_delta dry run;
vacuum cc_30min_delta dry run;
vacuum cci_30min_delta dry run;
vacuum cck_30min_delta dry run;
vacuum ccl_30min_delta dry run;
vacuum ccu_30min_delta dry run;
vacuum cday_30min_delta dry run;
vacuum cdns_30min_delta dry run;
vacuum cdw_30min_delta dry run;
vacuum ce_30min_delta dry run;
vacuum cern_30min_delta dry run;
vacuum cf_30min_delta dry run;
vacuum cfg_30min_delta dry run;
vacuum chd_30min_delta dry run;
vacuum chir_30min_delta dry run;
vacuum chk_30min_delta dry run;
vacuum chkp_30min_delta dry run;
vacuum chrw_30min_delta dry run;
vacuum chtr_30min_delta dry run;
vacuum ci_30min_delta dry run;
vacuum cien_30min_delta dry run;
vacuum cinf_30min_delta dry run;
vacuum cit_30min_delta dry run;
vacuum cl_30min_delta dry run;
vacuum clf_30min_delta dry run;
vacuum clx_30min_delta dry run;
vacuum cma_30min_delta dry run;
vacuum cmcsa_30min_delta dry run;
vacuum cme_30min_delta dry run;
vacuum cmg_30min_delta dry run;
vacuum cmi_30min_delta dry run;
vacuum cms_30min_delta dry run;
vacuum cnc_30min_delta dry run;
vacuum cnp_30min_delta dry run;
vacuum cnx_30min_delta dry run;
vacuum cof_30min_delta dry run;
vacuum coo_30min_delta dry run;
vacuum coop_30min_delta dry run;
vacuum cop_30min_delta dry run;
vacuum cost_30min_delta dry run;
vacuum coty_30min_delta dry run;
vacuum cpb_30min_delta dry run;
vacuum cpri_30min_delta dry run;
vacuum cprt_30min_delta dry run;
vacuum cpt_30min_delta dry run;
vacuum crm_30min_delta dry run;
vacuum csco_30min_delta dry run;
vacuum csx_30min_delta dry run;
vacuum ctas_30min_delta dry run;
vacuum ctlt_30min_delta dry run;
vacuum ctsh_30min_delta dry run;
vacuum ctva_30min_delta dry run;
vacuum ctxs_30min_delta dry run;
vacuum cvs_30min_delta dry run;
vacuum cvx_30min_delta dry run;
vacuum czr_30min_delta dry run;
vacuum d_30min_delta dry run;
vacuum dal_30min_delta dry run;
vacuum dan_30min_delta dry run;
vacuum dd_30min_delta dry run;
vacuum dds_30min_delta dry run;
vacuum de_30min_delta dry run;
vacuum dell_30min_delta dry run;
vacuum dfs_30min_delta dry run;
vacuum dg_30min_delta dry run;
vacuum dgx_30min_delta dry run;
vacuum dhi_30min_delta dry run;
vacuum dhr_30min_delta dry run;
vacuum dis_30min_delta dry run;
vacuum disca_30min_delta dry run;
vacuum disck_30min_delta dry run;
vacuum dish_30min_delta dry run;
vacuum dlr_30min_delta dry run;
vacuum dltr_30min_delta dry run;
vacuum dlx_30min_delta dry run;
vacuum dnb_30min_delta dry run;
vacuum dov_30min_delta dry run;
vacuum dow_30min_delta dry run;
vacuum dpz_30min_delta dry run;
vacuum dre_30min_delta dry run;
vacuum dri_30min_delta dry run;
vacuum dte_30min_delta dry run;
vacuum duk_30min_delta dry run;
vacuum dva_30min_delta dry run;
vacuum dvn_30min_delta dry run;
vacuum dxc_30min_delta dry run;
vacuum dxcm_30min_delta dry run;
vacuum ea_30min_delta dry run;
vacuum ebay_30min_delta dry run;
vacuum ecl_30min_delta dry run;
vacuum ed_30min_delta dry run;
vacuum efx_30min_delta dry run;
vacuum eix_30min_delta dry run;
vacuum el_30min_delta dry run;
vacuum emn_30min_delta dry run;
vacuum emr_30min_delta dry run;
vacuum endp_30min_delta dry run;
vacuum enph_30min_delta dry run;
vacuum eog_30min_delta dry run;
vacuum epam_30min_delta dry run;
vacuum eq_30min_delta dry run;
vacuum eqix_30min_delta dry run;
vacuum eqr_30min_delta dry run;
vacuum eqt_30min_delta dry run;
vacuum es_30min_delta dry run;
vacuum ess_30min_delta dry run;
vacuum etn_30min_delta dry run;
vacuum etr_30min_delta dry run;
vacuum etsy_30min_delta dry run;
vacuum evrg_30min_delta dry run;
vacuum ew_30min_delta dry run;
vacuum exc_30min_delta dry run;
vacuum expd_30min_delta dry run;
vacuum expe_30min_delta dry run;
vacuum exr_30min_delta dry run;
vacuum f_30min_delta dry run;
vacuum fang_30min_delta dry run;
vacuum fast_30min_delta dry run;
vacuum fb_30min_delta dry run;
vacuum fbhs_30min_delta dry run;
vacuum fcx_30min_delta dry run;
vacuum fds_30min_delta dry run;
vacuum fdx_30min_delta dry run;
vacuum fe_30min_delta dry run;
vacuum ffiv_30min_delta dry run;
vacuum fhn_30min_delta dry run;
vacuum fis_30min_delta dry run;
vacuum fisv_30min_delta dry run;
vacuum fitb_30min_delta dry run;
vacuum fl_30min_delta dry run;
vacuum flex_30min_delta dry run;
vacuum flr_30min_delta dry run;
vacuum fls_30min_delta dry run;
vacuum flt_30min_delta dry run;
vacuum fmc_30min_delta dry run;
vacuum fosl_30min_delta dry run;
vacuum fox_30min_delta dry run;
vacuum foxa_30min_delta dry run;
vacuum fpl_30min_delta dry run;
vacuum frc_30min_delta dry run;
vacuum frt_30min_delta dry run;
vacuum fslr_30min_delta dry run;
vacuum fti_30min_delta dry run;
vacuum ftnt_30min_delta dry run;
vacuum ftv_30min_delta dry run;
vacuum gci_30min_delta dry run;
vacuum gd_30min_delta dry run;
vacuum ge_30min_delta dry run;
vacuum ghc_30min_delta dry run;
vacuum gild_30min_delta dry run;
vacuum gis_30min_delta dry run;
vacuum gl_30min_delta dry run;
vacuum glw_30min_delta dry run;
vacuum gm_30min_delta dry run;
vacuum gme_30min_delta dry run;
vacuum gnrc_30min_delta dry run;
vacuum gnw_30min_delta dry run;
vacuum goog_30min_delta dry run;
vacuum googl_30min_delta dry run;
vacuum gp_30min_delta dry run;
vacuum gpc_30min_delta dry run;
vacuum gpn_30min_delta dry run;
vacuum gps_30min_delta dry run;
vacuum grmn_30min_delta dry run;
vacuum gs_30min_delta dry run;
vacuum gt_30min_delta dry run;
vacuum gww_30min_delta dry run;
vacuum hal_30min_delta dry run;
vacuum has_30min_delta dry run;
vacuum hban_30min_delta dry run;
vacuum hbi_30min_delta dry run;
vacuum hca_30min_delta dry run;
vacuum hd_30min_delta dry run;
vacuum hes_30min_delta dry run;
vacuum hfc_30min_delta dry run;
vacuum hig_30min_delta dry run;
vacuum hii_30min_delta dry run;
vacuum hlt_30min_delta dry run;
vacuum hog_30min_delta dry run;
vacuum holx_30min_delta dry run;
vacuum hon_30min_delta dry run;
vacuum hp_30min_delta dry run;
vacuum hpe_30min_delta dry run;
vacuum hpq_30min_delta dry run;
vacuum hrb_30min_delta dry run;
vacuum hrl_30min_delta dry run;
vacuum hsic_30min_delta dry run;
vacuum hst_30min_delta dry run;
vacuum hsy_30min_delta dry run;
vacuum hum_30min_delta dry run;
vacuum iac_30min_delta dry run;
vacuum ibm_30min_delta dry run;
vacuum ice_30min_deltav dry run;
vacuum idxx_30min_delta dry run;
vacuum iex_30min_delta dry run;
vacuum iff_30min_delta dry run;
vacuum igt_30min_delta dry run;
vacuum ihrt_30min_delta dry run;
vacuum ilmn_30min_delta dry run;
vacuum incy_30min_delta dry run;
vacuum info_30min_delta dry run;
vacuum infy_30min_delta dry run;
vacuum intc_30min_delta dry run;
vacuum intu_30min_delta dry run;
vacuum ip_30min_delta dry run;
vacuum ipg_30min_delta dry run;
vacuum ipgp_30min_delta dry run;
vacuum iqv_30min_delta dry run;
vacuum ir_30min_delta dry run;
vacuum irm_30min_delta dry run;
vacuum isrg_30min_delta dry run;
vacuum it_30min_delta dry run;
vacuum itt_30min_delta dry run;
vacuum itw_30min_delta dry run;
vacuum ivz_30min_delta dry run;
vacuum j_30min_delta dry run;
vacuum jbht_30min_delta dry run;