PREVIEW / etf_30min / 2022-04-04

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-04.parquet
  size:    667 KB
  rows:    26,244

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-04-04 04:00:00	SPY	ETF	452.53	453.29	452.19	452.53	15919.0
2022-04-04 04:30:00	SPY	ETF	452.86	452.94	452.29	452.71	11532.0
2022-04-04 05:00:00	SPY	ETF	452.71	453.61	452.7	453.51	11725.0
2022-04-04 05:30:00	SPY	ETF	453.47	453.88	453.27	453.84	18500.0
2022-04-04 06:00:00	SPY	ETF	453.66	454.06	453.63	453.71	4159.0
2022-04-04 06:30:00	SPY	ETF	453.7	453.7	453.28	453.33	10347.0
2022-04-04 07:00:00	SPY	ETF	453.35	453.87	453.34	453.62	33879.0
2022-04-04 07:30:00	SPY	ETF	453.72	454.0	453.44	453.91	45054.0
2022-04-04 08:00:00	SPY	ETF	453.41	454.0	452.5	453.68	116812.0
2022-04-04 08:30:00	SPY	ETF	453.71	453.86	452.86	452.96	89789.0
2022-04-04 09:00:00	SPY	ETF	452.97	453.55	452.97	453.15	149944.0
2022-04-04 09:30:00	SPY	ETF	453.13	454.7	452.26	454.52	5144409.0
2022-04-04 10:00:00	SPY	ETF	454.5	454.88	453.46	454.84	4071023.0
2022-04-04 10:30:00	SPY	ETF	454.83	454.95	454.08	454.48	2743403.0
2022-04-04 11:00:00	SPY	ETF	454.45	455.305	454.34	455.21	2642067.0
2022-04-04 11:30:00	SPY	ETF	455.2	455.71	454.88	455.51	2839242.0
2022-04-04 12:00:00	SPY	ETF	455.5101	455.65	455.31	455.5654	1899610.0
2022-04-04 12:30:00	SPY	ETF	455.57	455.69	454.84	454.92	2059992.0
2022-04-04 13:00:00	SPY	ETF	454.91	455.31	454.68	455.25	1386057.0
2022-04-04 13:30:00	SPY	ETF	455.25	455.78	455.09	455.715	1414459.0
2022-04-04 14:00:00	SPY	ETF	455.71	455.9	454.99	455.87	2367968.0
2022-04-04 14:30:00	SPY	ETF	455.87	456.26	455.66	456.06	2376465.0
2022-04-04 15:00:00	SPY	ETF	456.04	456.36	455.835	456.1	2390021.0
2022-04-04 15:30:00	SPY	ETF	456.11	456.83	455.73	456.78	8749602.0
2022-04-04 16:00:00	SPY	ETF	456.77	456.93	456.5	456.73	3545807.0
2022-04-04 16:30:00	SPY	ETF	456.73	456.9	456.58	456.58	196042.0
2022-04-04 17:00:00	SPY	ETF	456.51	456.75	456.51	456.7	40923.0
2022-04-04 17:30:00	SPY	ETF	456.71	456.71	456.59	456.62	11173.0
2022-04-04 18:00:00	SPY	ETF	456.68	456.68	456.47	456.57	24385.0
2022-04-04 18:30:00	SPY	ETF	456.46	456.8	456.4	456.49	95483.0
2022-04-04 19:00:00	SPY	ETF	456.5	456.53	456.45	456.49	14339.0
2022-04-04 19:30:00	SPY	ETF	456.57	456.62	456.33	456.35	43727.0
2022-04-04 04:00:00	QQQ	ETF	361.3	362.1	361.24	362.1	50714.0
2022-04-04 04:30:00	QQQ	ETF	362.24	362.41	361.94	362.27	30364.0
2022-04-04 05:00:00	QQQ	ETF	362.32	363.32	362.3	362.98	32250.0
2022-04-04 05:30:00	QQQ	ETF	362.95	363.44	362.88	363.26	6948.0
2022-04-04 06:00:00	QQQ	ETF	363.39	363.73	363.17	363.5	30933.0
2022-04-04 06:30:00	QQQ	ETF	363.5	363.51	363.12	363.23	70537.0
2022-04-04 07:00:00	QQQ	ETF	363.26	363.51	363.08	363.31	53300.0
2022-04-04 07:30:00	QQQ	ETF	363.37	363.6	363.0	363.43	58642.0
2022-04-04 08:00:00	QQQ	ETF	363.3301	363.61	361.3	362.97	110992.0
2022-04-04 08:30:00	QQQ	ETF	363.0	363.23	362.32	362.43	267012.0
2022-04-04 09:00:00	QQQ	ETF	362.43	362.94	362.43	362.67	128323.0
2022-04-04 09:30:00	QQQ	ETF	362.71	366.48	362.44	366.435	5318409.0
2022-04-04 10:00:00	QQQ	ETF	366.4	366.88	365.41	366.35	3388107.0
2022-04-04 10:30:00	QQQ	ETF	366.36	367.02	365.82	366.725	1851052.0
2022-04-04 11:00:00	QQQ	ETF	366.72	367.755	366.62	367.63	2092097.0
2022-04-04 11:30:00	QQQ	ETF	367.62	368.16	367.211	367.88	1917512.0
2022-04-04 12:00:00	QQQ	ETF	367.875	368.19	367.655	368.1506	1401461.0
2022-04-04 12:30:00	QQQ	ETF	368.17	368.41	367.57	367.6	1647168.0

> showing 50 of 26,244 rows — these rows as CSV

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