PREVIEW / etf_30min / 2022-01-20

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-20.parquet
  size:    692 KB
  rows:    27,389

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
2022-01-20 04:00:00	SPY	ETF	453.15	453.38	452.34	452.91	32431.0
2022-01-20 04:30:00	SPY	ETF	452.94	453.65	452.86	453.38	52212.0
2022-01-20 05:00:00	SPY	ETF	453.46	453.86	453.19	453.73	27874.0
2022-01-20 05:30:00	SPY	ETF	453.58	453.82	453.49	453.65	5360.0
2022-01-20 06:00:00	SPY	ETF	453.89	454.46	453.89	454.34	96704.0
2022-01-20 06:30:00	SPY	ETF	454.29	454.29	453.64	454.11	47589.0
2022-01-20 07:00:00	SPY	ETF	454.07	454.19	453.61	453.75	111576.0
2022-01-20 07:30:00	SPY	ETF	453.88	453.88	453.03	453.52	200221.0
2022-01-20 08:00:00	SPY	ETF	453.52	454.48	452.088	453.6	405518.0
2022-01-20 08:30:00	SPY	ETF	453.63	454.43	453.55	453.89	405896.0
2022-01-20 09:00:00	SPY	ETF	453.97	454.08	453.51	453.71	392574.0
2022-01-20 09:30:00	SPY	ETF	453.75	457.01	453.51	456.71	8558708.0
2022-01-20 10:00:00	SPY	ETF	456.72	456.97	455.53	456.46	5800100.0
2022-01-20 10:30:00	SPY	ETF	456.48	458.38	456.48	458.06	5753020.0
2022-01-20 11:00:00	SPY	ETF	458.07	458.74	457.26	458.0	4479187.0
2022-01-20 11:30:00	SPY	ETF	457.99	458.21	456.94	457.5	3158174.0
2022-01-20 12:00:00	SPY	ETF	457.51	457.8599	456.78	457.485	2630620.0
2022-01-20 12:30:00	SPY	ETF	457.48	457.81	456.48	456.73	2141029.0
2022-01-20 13:00:00	SPY	ETF	456.72	456.72	455.31	455.68	3642772.0
2022-01-20 13:30:00	SPY	ETF	455.7	456.08	455.16	455.29	3126607.0
2022-01-20 14:00:00	SPY	ETF	455.3	456.57	454.33	454.36	6408217.0
2022-01-20 14:30:00	SPY	ETF	454.34	454.37	453.02	453.275	6613776.0
2022-01-20 15:00:00	SPY	ETF	453.26	453.875	450.26	450.7079	9611703.0
2022-01-20 15:30:00	SPY	ETF	450.7	450.83	444.5	446.79	28490632.0
2022-01-20 16:00:00	SPY	ETF	446.79	447.11	444.86	444.89	7275961.0
2022-01-20 16:30:00	SPY	ETF	444.89	445.37	443.16	445.06	1094391.0
2022-01-20 17:00:00	SPY	ETF	445.01	446.75	444.75	445.06	880590.0
2022-01-20 17:30:00	SPY	ETF	445.06	446.75	444.9	444.95	176097.0
2022-01-20 18:00:00	SPY	ETF	444.87	445.87	444.23	444.32	162949.0
2022-01-20 18:30:00	SPY	ETF	446.75	446.75	444.27	445.47	145906.0
2022-01-20 19:00:00	SPY	ETF	445.65	445.8	444.76	445.12	53302.0
2022-01-20 19:30:00	SPY	ETF	445.03	445.2	444.58	444.64	57767.0
2022-01-20 04:00:00	QQQ	ETF	368.0	368.54	367.4	368.29	75968.0
2022-01-20 04:30:00	QQQ	ETF	368.27	369.11	368.22	368.8	54607.0
2022-01-20 05:00:00	QQQ	ETF	368.92	369.2	368.44	369.02	16865.0
2022-01-20 05:30:00	QQQ	ETF	368.96	369.15	368.7	368.93	31653.0
2022-01-20 06:00:00	QQQ	ETF	369.28	370.0	369.26	369.86	54426.0
2022-01-20 06:30:00	QQQ	ETF	369.84	369.84	369.25	369.61	105031.0
2022-01-20 07:00:00	QQQ	ETF	369.67	369.79	369.04	369.24	208294.0
2022-01-20 07:30:00	QQQ	ETF	369.29	369.36	368.49	369.2	175058.0
2022-01-20 08:00:00	QQQ	ETF	369.68	369.89	366.754	369.49	366823.0
2022-01-20 08:30:00	QQQ	ETF	369.42	370.59	369.31	370.13	483384.0
2022-01-20 09:00:00	QQQ	ETF	370.2	370.34	369.61	369.74	272717.0
2022-01-20 09:30:00	QQQ	ETF	369.78	372.55	369.53	372.31	6860573.0
2022-01-20 10:00:00	QQQ	ETF	372.38	372.74	370.92	372.2	4816177.0
2022-01-20 10:30:00	QQQ	ETF	372.21	373.6	372.21	373.17	3782523.0
2022-01-20 11:00:00	QQQ	ETF	373.15	373.87	372.11	372.88	2874453.0
2022-01-20 11:30:00	QQQ	ETF	372.86	373.21	371.48	372.48	3324860.0
2022-01-20 12:00:00	QQQ	ETF	372.52	372.79	371.64	372.64	2164400.0
2022-01-20 12:30:00	QQQ	ETF	372.62	372.929	371.3	371.59	1763081.0

> showing 50 of 27,389 rows — these rows as CSV

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