PREVIEW / etf_30min / 2022-04-29

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-29.parquet
  size:    676 KB
  rows:    26,972

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-29 04:00:00	SPY	ETF	425.51	426.48	425.51	425.8	23077.0
2022-04-29 04:30:00	SPY	ETF	426.23	426.39	425.47	425.56	3465.0
2022-04-29 05:00:00	SPY	ETF	425.3	425.47	424.59	424.65	18732.0
2022-04-29 05:30:00	SPY	ETF	424.56	424.81	424.34	424.34	63020.0
2022-04-29 06:00:00	SPY	ETF	424.6	425.1	423.97	424.11	55815.0
2022-04-29 06:30:00	SPY	ETF	424.14	424.2	423.5	423.5	65215.0
2022-04-29 07:00:00	SPY	ETF	423.78	424.21	423.39	423.81	87693.0
2022-04-29 07:30:00	SPY	ETF	423.88	424.08	422.98	423.36	129002.0
2022-04-29 08:00:00	SPY	ETF	423.76	427.0	423.02	424.6401	383591.0
2022-04-29 08:30:00	SPY	ETF	424.57	424.76	423.16	423.56	277431.0
2022-04-29 09:00:00	SPY	ETF	423.53	423.81	422.35	423.52	517921.0
2022-04-29 09:30:00	SPY	ETF	423.59	425.87	422.575	425.71	7684064.0
2022-04-29 10:00:00	SPY	ETF	425.71	425.86	420.9758	421.18	5751329.0
2022-04-29 10:30:00	SPY	ETF	421.19	421.41	419.93	420.76	5912999.0
2022-04-29 11:00:00	SPY	ETF	420.73	421.2	419.6	420.94	4430595.0
2022-04-29 11:30:00	SPY	ETF	420.91	422.13	420.404	420.45	4654838.0
2022-04-29 12:00:00	SPY	ETF	420.45	420.56	418.645	418.83	4388554.0
2022-04-29 12:30:00	SPY	ETF	418.8	418.95	417.21	417.679	4559807.0
2022-04-29 13:00:00	SPY	ETF	417.66	419.44	417.49	418.645	4044802.0
2022-04-29 13:30:00	SPY	ETF	418.63	419.78	417.57	417.66	3887874.0
2022-04-29 14:00:00	SPY	ETF	417.665	418.06	416.52	416.745	4830640.0
2022-04-29 14:30:00	SPY	ETF	416.71	417.04	414.83	415.66	5987817.0
2022-04-29 15:00:00	SPY	ETF	415.67	415.74	413.9	414.07	8767845.0
2022-04-29 15:30:00	SPY	ETF	414.0675	415.15	411.21	412.05	31679128.0
2022-04-29 16:00:00	SPY	ETF	412.08	413.57	411.94	412.0	10409548.0
2022-04-29 16:30:00	SPY	ETF	412.85	413.12	412.0	413.08	506244.0
2022-04-29 17:00:00	SPY	ETF	412.96	413.25	412.96	413.21	159552.0
2022-04-29 17:30:00	SPY	ETF	413.22	413.55	413.12	413.45	62341.0
2022-04-29 18:00:00	SPY	ETF	413.45	413.49	413.02	413.11	25704.0
2022-04-29 18:30:00	SPY	ETF	413.11	413.48	413.11	413.45	15413.0
2022-04-29 19:00:00	SPY	ETF	413.45	413.55	412.0	413.42	217254.0
2022-04-29 19:30:00	SPY	ETF	413.42	413.55	413.35	413.35	33509.0
2022-04-29 04:00:00	QQQ	ETF	324.51	326.13	324.51	325.55	51236.0
2022-04-29 04:30:00	QQQ	ETF	325.67	325.67	324.63	325.16	44393.0
2022-04-29 05:00:00	QQQ	ETF	325.12	325.35	324.23	324.35	50115.0
2022-04-29 05:30:00	QQQ	ETF	324.28	324.62	324.09	324.29	88148.0
2022-04-29 06:00:00	QQQ	ETF	324.52	324.9	323.97	324.07	75477.0
2022-04-29 06:30:00	QQQ	ETF	323.95	324.15	323.62	323.64	57237.0
2022-04-29 07:00:00	QQQ	ETF	323.87	324.17	323.31	323.91	73520.0
2022-04-29 07:30:00	QQQ	ETF	323.94	324.18	322.8	323.18	196096.0
2022-04-29 08:00:00	QQQ	ETF	323.9901	326.5	322.8296	324.72	440285.0
2022-04-29 08:30:00	QQQ	ETF	324.63	324.71	323.05	323.57	437052.0
2022-04-29 09:00:00	QQQ	ETF	323.6	323.93	322.52	323.62	574719.0
2022-04-29 09:30:00	QQQ	ETF	323.7	327.225	322.21	326.99	9699859.0
2022-04-29 10:00:00	QQQ	ETF	326.98	327.15	321.97	322.29	6478298.0
2022-04-29 10:30:00	QQQ	ETF	322.31	322.82	320.7601	321.79	4541765.0
2022-04-29 11:00:00	QQQ	ETF	321.8	322.39	320.4757	321.62	4084480.0
2022-04-29 11:30:00	QQQ	ETF	321.6	322.9	320.87	320.9	3378031.0
2022-04-29 12:00:00	QQQ	ETF	320.9	321.085	319.34	319.565	3412757.0
2022-04-29 12:30:00	QQQ	ETF	319.56	319.68	318.13	318.52	2842833.0

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

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