PREVIEW / etf_30min / 2024-12-27

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-27.parquet
  size:    902 KB
  rows:    36,256

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-12-27 04:00:00	SPY	ETF	599.25	599.51	599.25	599.49	8305.0
2024-12-27 04:30:00	SPY	ETF	599.49	599.57	599.23	599.36	1327.0
2024-12-27 05:00:00	SPY	ETF	599.34	599.45	599.34	599.4	2600.0
2024-12-27 05:30:00	SPY	ETF	599.4	599.5	599.23	599.34	4924.0
2024-12-27 06:00:00	SPY	ETF	599.51	599.51	599.36	599.36	390.0
2024-12-27 06:30:00	SPY	ETF	599.46	599.63	599.41	599.62	4305.0
2024-12-27 07:00:00	SPY	ETF	599.75	599.97	599.59	599.66	23713.0
2024-12-27 07:30:00	SPY	ETF	599.74	599.74	599.5	599.64	13647.0
2024-12-27 08:00:00	SPY	ETF	599.6401	600.59	599.08	599.24	90265.0
2024-12-27 08:30:00	SPY	ETF	599.23	599.25	598.68	598.81	102476.0
2024-12-27 09:00:00	SPY	ETF	598.81	598.9	597.38	597.48	254786.0
2024-12-27 09:30:00	SPY	ETF	597.47	597.7761	596.43	596.82	3255720.0
2024-12-27 10:00:00	SPY	ETF	596.82	597.01	592.79	593.21	4456004.0
2024-12-27 10:30:00	SPY	ETF	593.17	594.57	592.25	593.98	2667353.0
2024-12-27 11:00:00	SPY	ETF	593.96	594.55	592.46	594.519	1717993.0
2024-12-27 11:30:00	SPY	ETF	594.4901	594.6798	591.5801	592.0301	2155207.0
2024-12-27 12:00:00	SPY	ETF	592.03	592.34	590.8	591.53	1968076.0
2024-12-27 12:30:00	SPY	ETF	591.5301	592.46	590.7647	592.1	1785564.0
2024-12-27 13:00:00	SPY	ETF	592.08	592.95	591.8701	592.54	1171024.0
2024-12-27 13:30:00	SPY	ETF	592.5266	594.12	592.33	594.01	1215837.0
2024-12-27 14:00:00	SPY	ETF	593.97	594.64	593.622	593.97	1692131.0
2024-12-27 14:30:00	SPY	ETF	593.97	595.53	593.75	595.26	1627621.0
2024-12-27 15:00:00	SPY	ETF	595.26	595.26	593.1801	593.65	1713516.0
2024-12-27 15:30:00	SPY	ETF	593.66	595.4	592.54	594.99	9999687.0
2024-12-27 16:00:00	SPY	ETF	595.01	595.29	594.6161	595.1	4273873.0
2024-12-27 16:30:00	SPY	ETF	595.1	595.12	594.95	595.01	144223.0
2024-12-27 17:00:00	SPY	ETF	595.01	595.05	594.97	595.0	19469.0
2024-12-27 17:30:00	SPY	ETF	594.98	595.01	594.95	595.01	14908.0
2024-12-27 18:00:00	SPY	ETF	595.0	595.01	594.92	594.92	26933.0
2024-12-27 18:30:00	SPY	ETF	594.92	594.94	594.92	594.92	2292.0
2024-12-27 19:00:00	SPY	ETF	594.92	594.95	594.92	594.92	6469.0
2024-12-27 19:30:00	SPY	ETF	594.94	595.0885	594.94	595.03	12126.0
2024-12-27 04:00:00	QQQ	ETF	527.85	527.85	527.27	527.74	33310.0
2024-12-27 04:30:00	QQQ	ETF	527.69	527.84	527.45	527.63	2261.0
2024-12-27 05:00:00	QQQ	ETF	527.62	527.8	527.61	527.8	8146.0
2024-12-27 05:30:00	QQQ	ETF	527.78	527.9	527.54	527.9	7843.0
2024-12-27 06:00:00	QQQ	ETF	527.94	528.0	527.65	527.65	4526.0
2024-12-27 06:30:00	QQQ	ETF	527.8	528.08	527.75	528.08	6999.0
2024-12-27 07:00:00	QQQ	ETF	528.07	528.6	528.07	528.3	19331.0
2024-12-27 07:30:00	QQQ	ETF	528.33	528.41	528.11	528.28	32047.0
2024-12-27 08:00:00	QQQ	ETF	528.53	528.7	527.29	527.7499	74529.0
2024-12-27 08:30:00	QQQ	ETF	527.761	527.78	526.98	527.19	73689.0
2024-12-27 09:00:00	QQQ	ETF	527.18	527.27	526.0	526.04	286036.0
2024-12-27 09:30:00	QQQ	ETF	526.01	526.45	522.17	522.6	3191937.0
2024-12-27 10:00:00	QQQ	ETF	522.63	522.85	518.15	519.36	2682361.0
2024-12-27 10:30:00	QQQ	ETF	519.2932	520.74	518.04	520.27	1510480.0
2024-12-27 11:00:00	QQQ	ETF	520.26	521.445	518.8	521.35	1623388.0
2024-12-27 11:30:00	QQQ	ETF	521.345	521.49	518.45	519.1	1886296.0
2024-12-27 12:00:00	QQQ	ETF	519.11	519.46	517.86	518.7	1430832.0
2024-12-27 12:30:00	QQQ	ETF	518.7	519.72	517.93	519.56	1220682.0

> showing 50 of 36,256 rows — these rows as CSV

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