PREVIEW / etf_30min / 2024-09-04

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-09-04.parquet
  size:    817 KB
  rows:    33,307

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-09-04 04:00:00	SPY	ETF	550.13	550.4	549.85	550.3	17832.0
2024-09-04 04:30:00	SPY	ETF	550.5	550.72	549.95	550.18	8853.0
2024-09-04 05:00:00	SPY	ETF	550.17	550.56	550.0	550.3	8838.0
2024-09-04 05:30:00	SPY	ETF	550.2	550.9	550.19	550.47	8477.0
2024-09-04 06:00:00	SPY	ETF	550.69	550.69	549.8	549.95	4870.0
2024-09-04 06:30:00	SPY	ETF	549.94	550.16	549.75	549.75	3713.0
2024-09-04 07:00:00	SPY	ETF	549.79	550.01	549.46	549.92	57807.0
2024-09-04 07:30:00	SPY	ETF	549.95	550.34	549.63	549.85	42491.0
2024-09-04 08:00:00	SPY	ETF	549.6	550.78	548.66	549.97	144862.0
2024-09-04 08:30:00	SPY	ETF	549.97	550.77	549.65	550.6	77666.0
2024-09-04 09:00:00	SPY	ETF	550.51	550.59	550.08	550.141	123450.0
2024-09-04 09:30:00	SPY	ETF	550.2	552.555	550.03	552.49	3615783.0
2024-09-04 10:00:00	SPY	ETF	552.54	552.78	550.025	552.49	4581456.0
2024-09-04 10:30:00	SPY	ETF	552.49	554.0	552.22	553.98	2547632.0
2024-09-04 11:00:00	SPY	ETF	553.97	554.43	552.0905	552.14	2192540.0
2024-09-04 11:30:00	SPY	ETF	552.13	552.39	551.34	551.8499	1273727.0
2024-09-04 12:00:00	SPY	ETF	551.82	552.4172	551.07	552.12	1218004.0
2024-09-04 12:30:00	SPY	ETF	552.11	553.09	551.47	552.34	1091372.0
2024-09-04 13:00:00	SPY	ETF	552.315	552.34	551.04	551.215	1045538.0
2024-09-04 13:30:00	SPY	ETF	551.2	551.65	550.6811	550.95	1313576.0
2024-09-04 14:00:00	SPY	ETF	550.96	551.52	550.58	551.36	1608418.0
2024-09-04 14:30:00	SPY	ETF	551.35	551.74	550.02	550.07	1505808.0
2024-09-04 15:00:00	SPY	ETF	550.07	550.83	549.46	550.72	1951828.0
2024-09-04 15:30:00	SPY	ETF	550.73	551.96	550.08	550.84	6752761.0
2024-09-04 16:00:00	SPY	ETF	550.82	551.1458	549.88	550.55	4131833.0
2024-09-04 16:30:00	SPY	ETF	550.59	550.83	550.55	550.72	156934.0
2024-09-04 17:00:00	SPY	ETF	550.77	550.81	550.63	550.73	10860.0
2024-09-04 17:30:00	SPY	ETF	550.7	550.75	550.65	550.75	11841.0
2024-09-04 18:00:00	SPY	ETF	550.75	551.06	550.75	550.9	32141.0
2024-09-04 18:30:00	SPY	ETF	550.95	551.1602	550.95	551.01	7018.0
2024-09-04 19:00:00	SPY	ETF	550.95	550.95	550.27	550.45	11755.0
2024-09-04 19:30:00	SPY	ETF	550.52	550.52	549.52	550.28	85002.0
2024-09-04 04:00:00	QQQ	ETF	459.19	459.43	458.66	459.3	47321.0
2024-09-04 04:30:00	QQQ	ETF	459.21	459.9	459.07	459.38	57475.0
2024-09-04 05:00:00	QQQ	ETF	459.4	459.77	459.17	459.4	15828.0
2024-09-04 05:30:00	QQQ	ETF	459.35	460.23	459.35	459.8	21506.0
2024-09-04 06:00:00	QQQ	ETF	459.83	459.84	458.78	458.91	22635.0
2024-09-04 06:30:00	QQQ	ETF	458.83	459.09	458.23	458.28	26329.0
2024-09-04 07:00:00	QQQ	ETF	458.33	458.58	457.9	458.5	80996.0
2024-09-04 07:30:00	QQQ	ETF	458.48	458.83	458.14	458.64	42406.0
2024-09-04 08:00:00	QQQ	ETF	458.0	462.156	457.75	458.65	125525.0
2024-09-04 08:30:00	QQQ	ETF	458.64	459.6	458.11	459.5	185686.0
2024-09-04 09:00:00	QQQ	ETF	459.41	459.52	458.4	458.6	289678.0
2024-09-04 09:30:00	QQQ	ETF	458.67	461.44	458.24	461.01	3399865.0
2024-09-04 10:00:00	QQQ	ETF	460.94	461.67	457.73	461.45	3488827.0
2024-09-04 10:30:00	QQQ	ETF	461.44	463.99	461.06	463.9	2098983.0
2024-09-04 11:00:00	QQQ	ETF	463.84	464.45	461.95	461.98	2061745.0
2024-09-04 11:30:00	QQQ	ETF	462.03	462.44	461.14	461.8563	1769083.0
2024-09-04 12:00:00	QQQ	ETF	461.85	462.9	461.13	462.77	993194.0
2024-09-04 12:30:00	QQQ	ETF	462.72	463.75	462.08	463.24	1057865.0

> showing 50 of 33,307 rows — these rows as CSV

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