PREVIEW / etf_30min / 2024-05-06

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-06.parquet
  size:    799 KB
  rows:    32,118

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
2024-05-06 04:00:00	SPY	ETF	511.93	512.37	511.85	512.37	11557.0
2024-05-06 04:30:00	SPY	ETF	512.37	512.47	512.28	512.29	3951.0
2024-05-06 05:00:00	SPY	ETF	512.38	512.66	512.38	512.66	3771.0
2024-05-06 05:30:00	SPY	ETF	512.61	512.73	512.6	512.72	7410.0
2024-05-06 06:00:00	SPY	ETF	512.72	512.95	512.72	512.91	12391.0
2024-05-06 06:30:00	SPY	ETF	512.99	513.35	512.88	513.27	28693.0
2024-05-06 07:00:00	SPY	ETF	513.23	513.23	512.65	513.11	117872.0
2024-05-06 07:30:00	SPY	ETF	513.12	513.16	513.0	513.11	15469.0
2024-05-06 08:00:00	SPY	ETF	513.02	513.57	511.68	513.57	126913.0
2024-05-06 08:30:00	SPY	ETF	513.59	513.67	513.4	513.43	133400.0
2024-05-06 09:00:00	SPY	ETF	513.4298	513.83	513.26	513.72	250574.0
2024-05-06 09:30:00	SPY	ETF	513.75	514.36	513.3	514.205	4772165.0
2024-05-06 10:00:00	SPY	ETF	514.21	514.56	514.04	514.3	2519749.0
2024-05-06 10:30:00	SPY	ETF	514.31	514.64	514.17	514.29	1985375.0
2024-05-06 11:00:00	SPY	ETF	514.29	514.405	513.8401	514.1	1548753.0
2024-05-06 11:30:00	SPY	ETF	514.11	514.54	513.99	514.36	1321334.0
2024-05-06 12:00:00	SPY	ETF	514.36	514.36	513.7	514.17	1567516.0
2024-05-06 12:30:00	SPY	ETF	514.17	514.73	514.11	514.68	2133071.0
2024-05-06 13:00:00	SPY	ETF	514.68	514.96	514.245	514.61	1601392.0
2024-05-06 13:30:00	SPY	ETF	514.62	515.04	514.545	514.89	1225222.0
2024-05-06 14:00:00	SPY	ETF	514.885	515.77	514.82	515.585	1980240.0
2024-05-06 14:30:00	SPY	ETF	515.58	515.615	515.23	515.41	1907767.0
2024-05-06 15:00:00	SPY	ETF	515.4	515.45	514.88	515.115	2262264.0
2024-05-06 15:30:00	SPY	ETF	515.11	516.61	514.93	516.6	7346983.0
2024-05-06 16:00:00	SPY	ETF	516.6	516.63	516.17	516.38	2571414.0
2024-05-06 16:30:00	SPY	ETF	516.38	516.49	516.35	516.37	92507.0
2024-05-06 17:00:00	SPY	ETF	516.47	516.5	516.37	516.4	22217.0
2024-05-06 17:30:00	SPY	ETF	516.34	516.48	516.34	516.44	8789.0
2024-05-06 18:00:00	SPY	ETF	516.4	516.4758	516.19	516.37	11498.0
2024-05-06 18:30:00	SPY	ETF	516.38	516.57	516.22	516.53	25405.0
2024-05-06 19:00:00	SPY	ETF	516.54	516.6	516.3	516.33	23155.0
2024-05-06 19:30:00	SPY	ETF	516.42	516.46	516.31	516.45	56096.0
2024-05-06 04:00:00	QQQ	ETF	435.53	436.28	435.53	436.28	20386.0
2024-05-06 04:30:00	QQQ	ETF	436.2	436.39	436.15	436.23	14526.0
2024-05-06 05:00:00	QQQ	ETF	436.16	436.49	436.15	436.41	5321.0
2024-05-06 05:30:00	QQQ	ETF	436.38	436.59	436.38	436.56	9406.0
2024-05-06 06:00:00	QQQ	ETF	436.64	436.85	436.62	436.85	13960.0
2024-05-06 06:30:00	QQQ	ETF	436.88	436.93	436.55	436.9	36502.0
2024-05-06 07:00:00	QQQ	ETF	436.74	436.74	436.46	436.6	37849.0
2024-05-06 07:30:00	QQQ	ETF	436.65	436.75	436.49	436.54	15915.0
2024-05-06 08:00:00	QQQ	ETF	436.7001	437.14	435.2	437.1	80618.0
2024-05-06 08:30:00	QQQ	ETF	437.1	437.24	436.84	436.93	68451.0
2024-05-06 09:00:00	QQQ	ETF	436.9	437.35	436.83	437.25	69626.0
2024-05-06 09:30:00	QQQ	ETF	437.3	438.16	436.52	438.145	3394044.0
2024-05-06 10:00:00	QQQ	ETF	438.16	438.32	437.43	437.78	2012687.0
2024-05-06 10:30:00	QQQ	ETF	437.79	438.19	437.64	437.88	1557252.0
2024-05-06 11:00:00	QQQ	ETF	437.88	438.03	437.41	437.87	976874.0
2024-05-06 11:30:00	QQQ	ETF	437.88	438.5	437.8151	438.215	1155733.0
2024-05-06 12:00:00	QQQ	ETF	438.22	438.22	437.17	437.69	1269167.0
2024-05-06 12:30:00	QQQ	ETF	437.69	438.39	437.61	438.35	1124834.0

> showing 50 of 32,118 rows — these rows as CSV

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