PREVIEW / etf_30min / 2022-04-05

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-05.parquet
  size:    678 KB
  rows:    26,496

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-05 04:00:00	SPY	ETF	457.3	457.44	457.0	457.0	8550.0
2022-04-05 04:30:00	SPY	ETF	456.96	457.06	456.55	456.63	5345.0
2022-04-05 05:00:00	SPY	ETF	456.61	456.75	456.38	456.38	3030.0
2022-04-05 05:30:00	SPY	ETF	456.47	456.47	455.79	455.85	14262.0
2022-04-05 06:00:00	SPY	ETF	455.84	456.1	455.41	455.53	15242.0
2022-04-05 06:30:00	SPY	ETF	455.64	455.79	455.32	455.79	13763.0
2022-04-05 07:00:00	SPY	ETF	455.74	455.829	455.44	455.73	31790.0
2022-04-05 07:30:00	SPY	ETF	455.83	456.13	455.75	456.0	69080.0
2022-04-05 08:00:00	SPY	ETF	455.8	457.0	455.47	455.7	56362.0
2022-04-05 08:30:00	SPY	ETF	455.67	455.91	455.34	455.36	69894.0
2022-04-05 09:00:00	SPY	ETF	455.44	455.94	455.21	455.22	251735.0
2022-04-05 09:30:00	SPY	ETF	455.22	457.18	455.03	456.91	4994664.0
2022-04-05 10:00:00	SPY	ETF	456.91	457.83	453.89	454.44	8263258.0
2022-04-05 10:30:00	SPY	ETF	454.44	455.5114	453.79	455.09	3991150.0
2022-04-05 11:00:00	SPY	ETF	455.09	455.26	454.18	454.55	2878191.0
2022-04-05 11:30:00	SPY	ETF	454.56	454.99	453.48	453.51	3155988.0
2022-04-05 12:00:00	SPY	ETF	453.5	453.92	452.72	452.77	2820407.0
2022-04-05 12:30:00	SPY	ETF	452.77	453.73	452.67	453.558	2852835.0
2022-04-05 13:00:00	SPY	ETF	453.55	454.67	453.36	454.185	2652240.0
2022-04-05 13:30:00	SPY	ETF	454.18	454.21	452.5	453.02	2806284.0
2022-04-05 14:00:00	SPY	ETF	453.02	453.47	452.6	452.95	2715115.0
2022-04-05 14:30:00	SPY	ETF	452.93	453.21	452.375	452.51	2466305.0
2022-04-05 15:00:00	SPY	ETF	452.5	452.77	451.05	451.4002	5150632.0
2022-04-05 15:30:00	SPY	ETF	451.4	451.4	449.82	451.1	11910987.0
2022-04-05 16:00:00	SPY	ETF	451.12	453.3896	450.975	451.29	3344385.0
2022-04-05 16:30:00	SPY	ETF	451.28	451.68	451.03	451.68	394617.0
2022-04-05 17:00:00	SPY	ETF	451.68	451.84	451.65	451.84	34077.0
2022-04-05 17:30:00	SPY	ETF	451.78	451.86	451.7	451.75	47448.0
2022-04-05 18:00:00	SPY	ETF	451.7	451.71	451.16	451.22	67669.0
2022-04-05 18:30:00	SPY	ETF	451.24	451.51	451.24	451.48	24995.0
2022-04-05 19:00:00	SPY	ETF	451.4704	451.49	451.23	451.31	12335.0
2022-04-05 19:30:00	SPY	ETF	451.28	451.59	451.26	451.27	26132.0
2022-04-05 04:00:00	QQQ	ETF	369.75	369.88	369.5	369.5	23111.0
2022-04-05 04:30:00	QQQ	ETF	369.57	369.61	369.21	369.21	12858.0
2022-04-05 05:00:00	QQQ	ETF	369.23	369.28	368.91	368.91	11592.0
2022-04-05 05:30:00	QQQ	ETF	368.98	369.07	368.47	368.57	33176.0
2022-04-05 06:00:00	QQQ	ETF	368.51	368.77	368.08	368.2	24696.0
2022-04-05 06:30:00	QQQ	ETF	368.27	368.5	367.97	368.46	41300.0
2022-04-05 07:00:00	QQQ	ETF	368.5	368.51	368.1	368.479	48551.0
2022-04-05 07:30:00	QQQ	ETF	368.5	368.77	368.42	368.66	59396.0
2022-04-05 08:00:00	QQQ	ETF	368.3601	369.576	367.94	368.1	161473.0
2022-04-05 08:30:00	QQQ	ETF	368.09	368.27	367.74	367.82	135363.0
2022-04-05 09:00:00	QQQ	ETF	367.82	368.36	367.71	367.75	206293.0
2022-04-05 09:30:00	QQQ	ETF	367.81	368.54	366.54	367.03	5075934.0
2022-04-05 10:00:00	QQQ	ETF	367.01	367.72	363.715	364.45	7452716.0
2022-04-05 10:30:00	QQQ	ETF	364.4	364.9364	363.19	364.46	3653044.0
2022-04-05 11:00:00	QQQ	ETF	364.46	364.77	363.44	363.76	2864465.0
2022-04-05 11:30:00	QQQ	ETF	363.78	364.07	362.59	362.67	2691613.0
2022-04-05 12:00:00	QQQ	ETF	362.66	363.19	361.63	361.81	2524007.0
2022-04-05 12:30:00	QQQ	ETF	361.81	362.84	361.67	362.7	2176363.0

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

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