PREVIEW / etf_30min / 2020-07-24

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-24.parquet
  size:    543 KB
  rows:    20,195

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-24 04:00:00	SPY	ETF	320.67	321.22	320.53	320.95	50524.0
2020-07-24 04:30:00	SPY	ETF	321.04	321.6	321.01	321.6	77555.0
2020-07-24 05:00:00	SPY	ETF	321.68	321.68	321.34	321.55	35824.0
2020-07-24 05:30:00	SPY	ETF	321.79	322.09	321.6	322.0	17868.0
2020-07-24 06:00:00	SPY	ETF	321.98	322.52	321.95	322.31	174612.0
2020-07-24 06:30:00	SPY	ETF	322.29	322.36	321.67	321.93	95670.0
2020-07-24 07:00:00	SPY	ETF	322.03	322.49	321.64	321.68	131947.0
2020-07-24 07:30:00	SPY	ETF	321.66	321.71	320.93	321.5	260424.0
2020-07-24 08:00:00	SPY	ETF	322.2501	322.49	320.6	321.88	187819.0
2020-07-24 08:30:00	SPY	ETF	321.88	321.95	321.55	321.6	107112.0
2020-07-24 09:00:00	SPY	ETF	321.59	321.75	320.9	320.95	368015.0
2020-07-24 09:30:00	SPY	ETF	320.95	321.16	319.49	320.6	10050979.0
2020-07-24 10:00:00	SPY	ETF	320.605	321.67	320.52	321.29	6109904.0
2020-07-24 10:30:00	SPY	ETF	321.3	321.84	320.18	321.78	4524096.0
2020-07-24 11:00:00	SPY	ETF	321.78	321.99	321.145	321.68	3289469.0
2020-07-24 11:30:00	SPY	ETF	321.67	321.76	320.83	321.33	2681232.0
2020-07-24 12:00:00	SPY	ETF	321.33	321.41	320.38	320.8377	3033264.0
2020-07-24 12:30:00	SPY	ETF	320.83	320.98	320.01	320.245	2466169.0
2020-07-24 13:00:00	SPY	ETF	320.25	320.6	319.246	320.1819	3532712.0
2020-07-24 13:30:00	SPY	ETF	320.19	320.69	319.77	320.535	2741454.0
2020-07-24 14:00:00	SPY	ETF	320.54	321.4	320.41	321.39	2744205.0
2020-07-24 14:30:00	SPY	ETF	321.395	321.4	320.45	320.785	2819029.0
2020-07-24 15:00:00	SPY	ETF	320.78	321.45	319.98	320.12	4010761.0
2020-07-24 15:30:00	SPY	ETF	320.11	320.99	319.67	320.86	10170821.0
2020-07-24 16:00:00	SPY	ETF	320.86	321.13	320.325	320.48	7420631.0
2020-07-24 16:30:00	SPY	ETF	320.45	320.88	320.42	320.42	4975669.0
2020-07-24 17:00:00	SPY	ETF	320.41	320.88	320.4	320.52	117210.0
2020-07-24 17:30:00	SPY	ETF	320.5	320.5	320.35	320.35	14124.0
2020-07-24 18:00:00	SPY	ETF	320.35	320.47	320.33	320.4	5374.0
2020-07-24 18:30:00	SPY	ETF	320.4	320.4	320.31	320.31	3927.0
2020-07-24 19:00:00	SPY	ETF	320.31	320.36	319.99	319.99	12825.0
2020-07-24 19:30:00	SPY	ETF	320.14	320.2	320.0	320.2	18910.0
2020-07-24 04:00:00	QQQ	ETF	254.32	254.55	254.02	254.3	78665.0
2020-07-24 04:30:00	QQQ	ETF	254.33	254.7	254.33	254.57	25082.0
2020-07-24 05:00:00	QQQ	ETF	254.66	254.82	254.38	254.82	28093.0
2020-07-24 05:30:00	QQQ	ETF	254.83	255.36	254.8	255.36	44251.0
2020-07-24 06:00:00	QQQ	ETF	255.31	255.79	255.21	255.69	93194.0
2020-07-24 06:30:00	QQQ	ETF	255.71	255.71	254.86	255.41	141792.0
2020-07-24 07:00:00	QQQ	ETF	255.46	256.16	255.13	255.15	313296.0
2020-07-24 07:30:00	QQQ	ETF	255.1	255.16	254.04	254.851	327434.0
2020-07-24 08:00:00	QQQ	ETF	256.0801	256.27	253.7	255.11	560331.0
2020-07-24 08:30:00	QQQ	ETF	255.11	255.38	254.59	254.84	193447.0
2020-07-24 09:00:00	QQQ	ETF	254.84	255.05	254.03	254.09	457929.0
2020-07-24 09:30:00	QQQ	ETF	254.13	254.53	251.32	253.33	10067100.0
2020-07-24 10:00:00	QQQ	ETF	253.32	255.2696	253.12	254.89	4727409.0
2020-07-24 10:30:00	QQQ	ETF	254.91	256.275	253.57	256.21	4009928.0
2020-07-24 11:00:00	QQQ	ETF	256.22	256.93	255.57	256.74	2993159.0
2020-07-24 11:30:00	QQQ	ETF	256.76	256.84	255.5	256.4099	2362445.0
2020-07-24 12:00:00	QQQ	ETF	256.42	256.44	254.57	255.45	2860196.0
2020-07-24 12:30:00	QQQ	ETF	255.45	255.56	254.25	254.48	1772788.0

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

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