PREVIEW / etf_30min / 2025-04-24

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-24.parquet
  size:    973 KB
  rows:    39,601

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
2025-04-24 04:00:00	SPY	ETF	533.01	533.6	532.2	532.2	23942.0
2025-04-24 04:30:00	SPY	ETF	532.09	532.25	531.22	532.01	14874.0
2025-04-24 05:00:00	SPY	ETF	532.14	532.72	532.04	532.54	12072.0
2025-04-24 05:30:00	SPY	ETF	532.49	533.37	532.49	533.12	98048.0
2025-04-24 06:00:00	SPY	ETF	533.43	534.0	533.05	533.73	40931.0
2025-04-24 06:30:00	SPY	ETF	533.65	536.41	533.56	535.96	100079.0
2025-04-24 07:00:00	SPY	ETF	535.94	536.03	534.16	534.31	190401.0
2025-04-24 07:30:00	SPY	ETF	534.3	535.8	533.57	534.36	159240.0
2025-04-24 08:00:00	SPY	ETF	535.86	535.9102	532.51	534.8	284882.0
2025-04-24 08:30:00	SPY	ETF	534.88	536.4	534.5	536.11	261674.0
2025-04-24 09:00:00	SPY	ETF	536.12	536.78	535.63	536.74	592066.0
2025-04-24 09:30:00	SPY	ETF	536.74	539.6462	535.4504	539.48	3795630.0
2025-04-24 10:00:00	SPY	ETF	539.48	542.33	539.01	542.2342	3887989.0
2025-04-24 10:30:00	SPY	ETF	542.23	543.31	540.99	542.46	3894245.0
2025-04-24 11:00:00	SPY	ETF	542.45	543.87	541.97	542.48	2640425.0
2025-04-24 11:30:00	SPY	ETF	542.51	543.9	541.89	542.76	2064977.0
2025-04-24 12:00:00	SPY	ETF	542.81	544.97	542.2503	544.44	2198100.0
2025-04-24 12:30:00	SPY	ETF	544.44	545.8479	544.295	545.44	2424094.0
2025-04-24 13:00:00	SPY	ETF	545.43	545.46	544.03	544.98	1749950.0
2025-04-24 13:30:00	SPY	ETF	544.98	545.59	544.37	545.27	1400794.0
2025-04-24 14:00:00	SPY	ETF	545.29	546.33	545.03	545.51	2663427.0
2025-04-24 14:30:00	SPY	ETF	545.51	546.9	545.43	546.08	2166657.0
2025-04-24 15:00:00	SPY	ETF	546.05	546.1	544.28	544.87	3354768.0
2025-04-24 15:30:00	SPY	ETF	544.89	547.43	544.75	546.54	7807526.0
2025-04-24 16:00:00	SPY	ETF	546.55	549.33	546.52	547.35	4101661.0
2025-04-24 16:30:00	SPY	ETF	547.31	547.9688	547.08	547.38	210712.0
2025-04-24 17:00:00	SPY	ETF	547.3604	548.3	547.2	548.2	294950.0
2025-04-24 17:30:00	SPY	ETF	548.2	548.74	548.11	548.5	40463.0
2025-04-24 18:00:00	SPY	ETF	548.5	548.8	547.27	548.56	207999.0
2025-04-24 18:30:00	SPY	ETF	548.55	548.97	548.16	548.43	132208.0
2025-04-24 19:00:00	SPY	ETF	548.46	548.9	548.25	548.63	38844.0
2025-04-24 19:30:00	SPY	ETF	548.78	548.85	548.15	548.37	43541.0
2025-04-24 04:00:00	QQQ	ETF	451.74	452.28	450.62	450.71	60603.0
2025-04-24 04:30:00	QQQ	ETF	450.54	450.84	449.72	450.48	47937.0
2025-04-24 05:00:00	QQQ	ETF	450.61	451.19	450.55	451.13	35024.0
2025-04-24 05:30:00	QQQ	ETF	451.1	452.06	451.0	452.06	34166.0
2025-04-24 06:00:00	QQQ	ETF	452.14	452.9	452.12	452.55	56174.0
2025-04-24 06:30:00	QQQ	ETF	452.77	455.47	452.62	455.08	96569.0
2025-04-24 07:00:00	QQQ	ETF	455.0	455.18	453.21	453.5	140451.0
2025-04-24 07:30:00	QQQ	ETF	453.4	454.94	453.0	453.84	113359.0
2025-04-24 08:00:00	QQQ	ETF	454.64	455.43	450.7596	454.81	292367.0
2025-04-24 08:30:00	QQQ	ETF	454.5001	456.23	454.5001	455.96	178645.0
2025-04-24 09:00:00	QQQ	ETF	456.0	456.5201	455.31	456.47	157665.0
2025-04-24 09:30:00	QQQ	ETF	456.48	460.94	455.83	460.75	3341135.0
2025-04-24 10:00:00	QQQ	ETF	460.77	462.9	460.56	462.85	3272036.0
2025-04-24 10:30:00	QQQ	ETF	462.84	463.82	461.58	462.9	2815409.0
2025-04-24 11:00:00	QQQ	ETF	462.88	464.5091	462.4	462.98	1848255.0
2025-04-24 11:30:00	QQQ	ETF	463.08	464.62	462.4436	463.33	1439601.0
2025-04-24 12:00:00	QQQ	ETF	463.385	465.38	462.86	464.915	1804258.0
2025-04-24 12:30:00	QQQ	ETF	464.935	466.18	464.74	465.78	1788994.0

> showing 50 of 39,601 rows — these rows as CSV

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