PREVIEW / etf_30min / 2020-07-30

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-30.parquet
  size:    555 KB
  rows:    20,714

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2020-07-30 04:00:00	SPY	ETF	323.0	323.0	322.32	322.39	42461.0
2020-07-30 04:30:00	SPY	ETF	322.39	322.49	321.71	321.71	28378.0
2020-07-30 05:00:00	SPY	ETF	321.66	322.48	321.61	322.4	23991.0
2020-07-30 05:30:00	SPY	ETF	322.55	323.0	322.55	322.63	18763.0
2020-07-30 06:00:00	SPY	ETF	322.6	322.63	322.28	322.33	19484.0
2020-07-30 06:30:00	SPY	ETF	322.36	322.36	321.21	321.61	80144.0
2020-07-30 07:00:00	SPY	ETF	321.67	322.39	321.56	322.1	332650.0
2020-07-30 07:30:00	SPY	ETF	322.14	322.95	322.1	322.86	231428.0
2020-07-30 08:00:00	SPY	ETF	322.0301	324.85	321.3996	322.87	548451.0
2020-07-30 08:30:00	SPY	ETF	322.75	323.02	321.36	321.36	1189156.0
2020-07-30 09:00:00	SPY	ETF	321.36	321.97	320.9	321.94	650136.0
2020-07-30 09:30:00	SPY	ETF	321.9	322.42	320.0	320.13	7540589.0
2020-07-30 10:00:00	SPY	ETF	320.13	320.99	319.64	320.78	6135569.0
2020-07-30 10:30:00	SPY	ETF	320.78	321.62	320.52	321.4	4951432.0
2020-07-30 11:00:00	SPY	ETF	321.42	322.57	321.1	322.05	4504428.0
2020-07-30 11:30:00	SPY	ETF	322.04	322.99	321.91	322.73	2627048.0
2020-07-30 12:00:00	SPY	ETF	322.73	323.95	322.38	323.4	3328392.0
2020-07-30 12:30:00	SPY	ETF	323.41	323.67	323.291	323.57	1920599.0
2020-07-30 13:00:00	SPY	ETF	323.54	324.4	323.4603	323.73	2385604.0
2020-07-30 13:30:00	SPY	ETF	323.72	323.7884	323.12	323.715	2745804.0
2020-07-30 14:00:00	SPY	ETF	323.71	323.93	323.16	323.45	3344960.0
2020-07-30 14:30:00	SPY	ETF	323.45	324.29	323.425	323.9199	2504696.0
2020-07-30 15:00:00	SPY	ETF	323.915	324.26	323.35	324.24	3962100.0
2020-07-30 15:30:00	SPY	ETF	324.24	324.41	323.57	323.98	6848377.0
2020-07-30 16:00:00	SPY	ETF	323.99	325.61	323.64	325.36	3497337.0
2020-07-30 16:30:00	SPY	ETF	325.36	326.96	325.2	326.84	828573.0
2020-07-30 17:00:00	SPY	ETF	326.81	326.85	326.6	326.65	102054.0
2020-07-30 17:30:00	SPY	ETF	326.65	326.94	326.53	326.94	99017.0
2020-07-30 18:00:00	SPY	ETF	326.94	327.43	326.45	326.5	207881.0
2020-07-30 18:30:00	SPY	ETF	326.48	326.61	326.2	326.52	60242.0
2020-07-30 19:00:00	SPY	ETF	326.55	326.91	326.48	326.8799	61259.0
2020-07-30 19:30:00	SPY	ETF	326.84	327.06	326.7	326.84	42976.0
2020-07-30 04:00:00	QQQ	ETF	257.8	257.99	257.64	257.64	29486.0
2020-07-30 04:30:00	QQQ	ETF	257.7	257.79	256.81	256.92	23301.0
2020-07-30 05:00:00	QQQ	ETF	256.81	257.43	256.71	257.34	23168.0
2020-07-30 05:30:00	QQQ	ETF	257.48	258.29	257.48	258.02	28675.0
2020-07-30 06:00:00	QQQ	ETF	258.05	258.15	257.72	257.82	39797.0
2020-07-30 06:30:00	QQQ	ETF	257.76	257.93	256.29	256.7	144377.0
2020-07-30 07:00:00	QQQ	ETF	256.85	257.84	256.85	257.63	296693.0
2020-07-30 07:30:00	QQQ	ETF	257.6	258.53	257.56	258.17	287495.0
2020-07-30 08:00:00	QQQ	ETF	257.7501	260.54	256.39	258.17	132399.0
2020-07-30 08:30:00	QQQ	ETF	258.26	258.44	257.09	257.19	451244.0
2020-07-30 09:00:00	QQQ	ETF	257.18	258.8	256.7	257.81	434800.0
2020-07-30 09:30:00	QQQ	ETF	257.81	259.1099	256.96	257.22	4827610.0
2020-07-30 10:00:00	QQQ	ETF	257.25	258.03	256.55	257.58	3372709.0
2020-07-30 10:30:00	QQQ	ETF	257.59	258.58	257.41	258.44	2319528.0
2020-07-30 11:00:00	QQQ	ETF	258.43	259.31	258.11	258.95	1732716.0
2020-07-30 11:30:00	QQQ	ETF	258.93	260.35	258.8227	259.9785	1995185.0
2020-07-30 12:00:00	QQQ	ETF	259.98	261.22	259.7711	260.65	2830205.0
2020-07-30 12:30:00	QQQ	ETF	260.68	260.93	260.3901	260.74	1800789.0

> showing 50 of 20,714 rows — these rows as CSV

> unlock the full archive -- $79 one-time