PREVIEW / etf_30min / 2025-01-21

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-21.parquet
  size:    995 KB
  rows:    40,772

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-01-21 04:00:00	SPY	ETF	598.27	599.85	598.27	599.75	17243.0
2025-01-21 04:30:00	SPY	ETF	599.7	600.28	599.7	600.28	4837.0
2025-01-21 05:00:00	SPY	ETF	600.44	601.0	600.44	600.69	8418.0
2025-01-21 05:30:00	SPY	ETF	600.6	600.66	599.9	599.9	10057.0
2025-01-21 06:00:00	SPY	ETF	599.93	600.25	599.51	599.51	11925.0
2025-01-21 06:30:00	SPY	ETF	599.47	599.87	599.18	599.49	9168.0
2025-01-21 07:00:00	SPY	ETF	599.48	600.11	598.81	600.11	131309.0
2025-01-21 07:30:00	SPY	ETF	600.12	600.22	599.69	599.969	34153.0
2025-01-21 08:00:00	SPY	ETF	599.74	600.7104	597.98	599.82	98598.0
2025-01-21 08:30:00	SPY	ETF	599.81	600.68	599.81	600.52	114551.0
2025-01-21 09:00:00	SPY	ETF	600.61	600.84	599.2	600.75	379953.0
2025-01-21 09:30:00	SPY	ETF	600.67	601.47	599.53	600.52	3683808.0
2025-01-21 10:00:00	SPY	ETF	600.5476	600.55	598.67	600.355	1858424.0
2025-01-21 10:30:00	SPY	ETF	600.33	600.62	599.43	600.3701	1426724.0
2025-01-21 11:00:00	SPY	ETF	600.36	600.94	599.83	600.78	987715.0
2025-01-21 11:30:00	SPY	ETF	600.77	601.47	600.26	601.38	1280501.0
2025-01-21 12:00:00	SPY	ETF	601.35	601.78	600.93	601.58	879236.0
2025-01-21 12:30:00	SPY	ETF	601.58	602.49	601.5415	602.445	1360909.0
2025-01-21 13:00:00	SPY	ETF	602.44	602.88	602.0725	602.59	1075051.0
2025-01-21 13:30:00	SPY	ETF	602.6	602.78	602.2102	602.62	828338.0
2025-01-21 14:00:00	SPY	ETF	602.615	602.82	601.9	602.37	1347271.0
2025-01-21 14:30:00	SPY	ETF	602.38	602.39	601.67	602.16	1600770.0
2025-01-21 15:00:00	SPY	ETF	602.18	602.78	601.995	602.71	1768469.0
2025-01-21 15:30:00	SPY	ETF	602.72	602.98	602.15	602.92	4667860.0
2025-01-21 16:00:00	SPY	ETF	602.9	603.56	602.78	603.19	3582704.0
2025-01-21 16:30:00	SPY	ETF	603.19	603.4	603.05	603.4	103305.0
2025-01-21 17:00:00	SPY	ETF	603.43	603.47	603.2099	603.47	38885.0
2025-01-21 17:30:00	SPY	ETF	603.5	604.06	603.46	604.0	96955.0
2025-01-21 18:00:00	SPY	ETF	603.8	604.03	602.98	603.4	77225.0
2025-01-21 18:30:00	SPY	ETF	603.26	603.89	603.26	603.83	5648.0
2025-01-21 19:00:00	SPY	ETF	603.9	603.99	603.76	603.91	11509.0
2025-01-21 19:30:00	SPY	ETF	603.97	604.4	603.97	604.36	32608.0
2025-01-21 04:00:00	QQQ	ETF	522.5	523.87	522.5	523.64	40539.0
2025-01-21 04:30:00	QQQ	ETF	523.7	524.43	523.69	524.43	11984.0
2025-01-21 05:00:00	QQQ	ETF	524.52	524.95	524.31	524.55	16763.0
2025-01-21 05:30:00	QQQ	ETF	524.52	524.7	523.92	523.92	10808.0
2025-01-21 06:00:00	QQQ	ETF	523.97	524.44	523.67	523.72	13492.0
2025-01-21 06:30:00	QQQ	ETF	523.83	524.08	523.43	523.52	34386.0
2025-01-21 07:00:00	QQQ	ETF	523.6	524.27	522.94	524.24	66771.0
2025-01-21 07:30:00	QQQ	ETF	524.18	524.41	523.75	524.12	47827.0
2025-01-21 08:00:00	QQQ	ETF	523.43	524.9196	521.349	524.05	118812.0
2025-01-21 08:30:00	QQQ	ETF	524.0	524.93	524.0	524.82	124042.0
2025-01-21 09:00:00	QQQ	ETF	524.86	525.09	524.15	524.45	161570.0
2025-01-21 09:30:00	QQQ	ETF	524.47	524.69	521.19	522.62	2578554.0
2025-01-21 10:00:00	QQQ	ETF	522.58	522.85	520.06	522.83	1603709.0
2025-01-21 10:30:00	QQQ	ETF	522.8	523.05	521.5451	522.6758	1005278.0
2025-01-21 11:00:00	QQQ	ETF	522.63	523.19	521.72	522.58	732641.0
2025-01-21 11:30:00	QQQ	ETF	522.57	523.79	522.02	523.6442	658890.0
2025-01-21 12:00:00	QQQ	ETF	523.56	524.32	523.06	524.15	651358.0
2025-01-21 12:30:00	QQQ	ETF	524.1699	525.285	524.12	525.2473	793401.0

> showing 50 of 40,772 rows — these rows as CSV

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