PREVIEW / etf_30min / 2020-08-31

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-31.parquet
  size:    569 KB
  rows:    21,071

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-08-31 04:00:00	SPY	ETF	351.71	351.73	351.44	351.59	10441.0
2020-08-31 04:30:00	SPY	ETF	351.71	351.84	351.71	351.74	1291.0
2020-08-31 05:00:00	SPY	ETF	351.74	351.74	351.48	351.48	2082.0
2020-08-31 05:30:00	SPY	ETF	351.54	351.67	351.49	351.63	10234.0
2020-08-31 06:00:00	SPY	ETF	351.5	351.5	351.23	351.35	13066.0
2020-08-31 06:30:00	SPY	ETF	351.35	351.38	351.14	351.29	14079.0
2020-08-31 07:00:00	SPY	ETF	351.29	351.49	351.09	351.49	59461.0
2020-08-31 07:30:00	SPY	ETF	351.49	351.51	351.15	351.25	53470.0
2020-08-31 08:00:00	SPY	ETF	351.25	352.45	350.6902	350.79	354368.0
2020-08-31 08:30:00	SPY	ETF	350.78	350.98	350.62	350.75	140076.0
2020-08-31 09:00:00	SPY	ETF	350.74	350.74	350.1	350.35	401132.0
2020-08-31 09:30:00	SPY	ETF	350.35	350.67	349.87	350.03	5380885.0
2020-08-31 10:00:00	SPY	ETF	350.02	350.49	349.85	350.16	3568424.0
2020-08-31 10:30:00	SPY	ETF	350.14	350.68	350.1	350.63	4495885.0
2020-08-31 11:00:00	SPY	ETF	350.635	350.85	349.09	349.47	4181470.0
2020-08-31 11:30:00	SPY	ETF	349.49	350.39	349.17	350.14	3251040.0
2020-08-31 12:00:00	SPY	ETF	350.15	350.71	350.0	350.4082	3678541.0
2020-08-31 12:30:00	SPY	ETF	350.4	350.5511	350.09	350.51	1325036.0
2020-08-31 13:00:00	SPY	ETF	350.52	350.72	350.35	350.58	1797757.0
2020-08-31 13:30:00	SPY	ETF	350.585	350.88	350.5	350.62	2615488.0
2020-08-31 14:00:00	SPY	ETF	350.63	350.73	350.33	350.375	2542035.0
2020-08-31 14:30:00	SPY	ETF	350.3784	350.88	350.1801	350.78	3881575.0
2020-08-31 15:00:00	SPY	ETF	350.79	350.83	349.88	350.4671	3379271.0
2020-08-31 15:30:00	SPY	ETF	350.47	351.3	349.31	349.35	11655929.0
2020-08-31 16:00:00	SPY	ETF	349.35	349.96	349.06	349.76	10556826.0
2020-08-31 16:30:00	SPY	ETF	349.79	349.79	349.3	349.41	313886.0
2020-08-31 17:00:00	SPY	ETF	349.5	349.56	349.25	349.4	343864.0
2020-08-31 17:30:00	SPY	ETF	349.4	349.45	349.26	349.45	20933.0
2020-08-31 18:00:00	SPY	ETF	349.32	349.55	348.5	348.73	109912.0
2020-08-31 18:30:00	SPY	ETF	348.77	348.99	348.72	348.91	27308.0
2020-08-31 19:00:00	SPY	ETF	348.95	349.23	348.95	349.16	18259.0
2020-08-31 19:30:00	SPY	ETF	349.2499	349.83	349.2499	349.69	63032.0
2020-08-31 04:00:00	QQQ	ETF	293.97	294.09	293.35	293.58	44882.0
2020-08-31 04:30:00	QQQ	ETF	293.62	293.76	293.61	293.68	18288.0
2020-08-31 05:00:00	QQQ	ETF	293.66	293.67	293.45	293.45	4298.0
2020-08-31 05:30:00	QQQ	ETF	293.63	293.73	293.5	293.67	7763.0
2020-08-31 06:00:00	QQQ	ETF	293.58	293.78	293.4	293.78	15361.0
2020-08-31 06:30:00	QQQ	ETF	293.79	293.91	293.74	293.86	13551.0
2020-08-31 07:00:00	QQQ	ETF	293.84	293.9	293.29	293.57	142891.0
2020-08-31 07:30:00	QQQ	ETF	293.63	293.68	293.15	293.33	153595.0
2020-08-31 08:00:00	QQQ	ETF	293.33	294.64	292.82	293.05	266143.0
2020-08-31 08:30:00	QQQ	ETF	293.07	293.3	292.77	292.89	430692.0
2020-08-31 09:00:00	QQQ	ETF	293.0	293.37	292.5	293.2	1381637.0
2020-08-31 09:30:00	QQQ	ETF	293.16	293.92	292.62	293.57	3755691.0
2020-08-31 10:00:00	QQQ	ETF	293.57	294.32	293.25	293.97	2327663.0
2020-08-31 10:30:00	QQQ	ETF	293.97	294.93	293.93	294.8	2215565.0
2020-08-31 11:00:00	QQQ	ETF	294.82	295.18	293.135	293.9	2757861.0
2020-08-31 11:30:00	QQQ	ETF	293.91	294.77	293.21	294.33	1959088.0
2020-08-31 12:00:00	QQQ	ETF	294.33	295.13	294.17	295.01	1287752.0
2020-08-31 12:30:00	QQQ	ETF	295.0077	295.338	294.64	295.3201	1043596.0

> showing 50 of 21,071 rows — these rows as CSV

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