PREVIEW / etf_30min / 2025-12-09

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-12-09.parquet
  size:    1.1 MB
  rows:    43,825

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-12-09 04:00:00	SPY	ETF	684.5	684.5	683.91	684.03	7748.0
2025-12-09 04:30:00	SPY	ETF	684.05	684.23	683.73	683.83	7432.0
2025-12-09 05:00:00	SPY	ETF	683.85	684.35	683.79	684.33	8195.0
2025-12-09 05:30:00	SPY	ETF	684.33	684.39	682.67	684.28	159579.0
2025-12-09 06:00:00	SPY	ETF	684.05	684.13	683.49	684.11	57600.0
2025-12-09 06:30:00	SPY	ETF	684.08	684.3	684.02	684.22	94236.0
2025-12-09 07:00:00	SPY	ETF	684.24	684.27	684.0	684.1	20892.0
2025-12-09 07:30:00	SPY	ETF	684.1	684.2	683.61	683.99	113309.0
2025-12-09 08:00:00	SPY	ETF	683.96	684.85	683.13	683.81	141015.0
2025-12-09 08:30:00	SPY	ETF	683.76	683.82	682.97	683.18	177384.0
2025-12-09 09:00:00	SPY	ETF	683.16	683.31	682.62	683.14	214808.0
2025-12-09 09:30:00	SPY	ETF	683.16	684.53	682.82	684.44	5452431.0
2025-12-09 10:00:00	SPY	ETF	684.47	684.94	683.76	684.215	3428562.0
2025-12-09 10:30:00	SPY	ETF	684.2	684.57	683.585	684.505	2778429.0
2025-12-09 11:00:00	SPY	ETF	684.49	685.34	684.44	684.81	2520078.0
2025-12-09 11:30:00	SPY	ETF	684.81	685.385	684.52	684.97	2527548.0
2025-12-09 12:00:00	SPY	ETF	684.96	685.34	684.27	684.65	1987409.0
2025-12-09 12:30:00	SPY	ETF	684.65	684.8599	683.62	684.275	2682029.0
2025-12-09 13:00:00	SPY	ETF	684.27	684.49	683.88	684.24	2014994.0
2025-12-09 13:30:00	SPY	ETF	684.24	684.345	683.35	684.05	2202273.0
2025-12-09 14:00:00	SPY	ETF	684.06	684.1399	683.64	683.73	1877420.0
2025-12-09 14:30:00	SPY	ETF	683.73	683.82	683.2	683.63	2240257.0
2025-12-09 15:00:00	SPY	ETF	683.63	683.8526	683.3	683.325	2763262.0
2025-12-09 15:30:00	SPY	ETF	683.32	683.61	682.59	683.05	9335026.0
2025-12-09 16:00:00	SPY	ETF	683.05	683.08	682.51	682.66	4391372.0
2025-12-09 16:30:00	SPY	ETF	682.65	682.85	682.6	682.85	69540.0
2025-12-09 17:00:00	SPY	ETF	682.77	682.96	682.69	682.69	24860.0
2025-12-09 17:30:00	SPY	ETF	682.76	682.933	682.7061	682.933	9519.0
2025-12-09 18:00:00	SPY	ETF	682.8205	683.03	682.82	682.9101	40869.0
2025-12-09 18:30:00	SPY	ETF	682.94	682.94	682.76	682.8	13670.0
2025-12-09 19:00:00	SPY	ETF	682.77	683.21	682.6547	682.8596	55249.0
2025-12-09 19:30:00	SPY	ETF	682.8596	682.898	682.5	682.5	26870.0
2025-12-09 04:00:00	QQQ	ETF	624.75	624.9	624.04	624.23	20591.0
2025-12-09 04:30:00	QQQ	ETF	624.2	624.4	623.83	623.96	13638.0
2025-12-09 05:00:00	QQQ	ETF	623.95	624.8	623.93	624.69	31135.0
2025-12-09 05:30:00	QQQ	ETF	624.69	624.8	622.7	624.27	106457.0
2025-12-09 06:00:00	QQQ	ETF	624.24	624.28	623.35	624.21	47495.0
2025-12-09 06:30:00	QQQ	ETF	624.22	624.54	624.03	624.31	31027.0
2025-12-09 07:00:00	QQQ	ETF	624.34	624.41	624.0	624.13	42859.0
2025-12-09 07:30:00	QQQ	ETF	624.2	624.33	623.71	624.11	57557.0
2025-12-09 08:00:00	QQQ	ETF	624.13	625.28	623.36	623.81	186581.0
2025-12-09 08:30:00	QQQ	ETF	623.79	623.79	622.78	623.0191	168003.0
2025-12-09 09:00:00	QQQ	ETF	623.02	623.21	622.4	623.02	131642.0
2025-12-09 09:30:00	QQQ	ETF	623.04	623.87	621.0	623.31	5075698.0
2025-12-09 10:00:00	QQQ	ETF	623.35	624.28	623.0	623.97	2327599.0
2025-12-09 10:30:00	QQQ	ETF	624.0	624.67	623.48	624.645	2352705.0
2025-12-09 11:00:00	QQQ	ETF	624.63	625.2655	624.52	624.78	2201532.0
2025-12-09 11:30:00	QQQ	ETF	624.79	625.385	624.27	625.225	2464684.0
2025-12-09 12:00:00	QQQ	ETF	625.23	625.81	624.78	625.21	1826055.0
2025-12-09 12:30:00	QQQ	ETF	625.22	625.47	624.78	625.44	1783053.0

> showing 50 of 43,825 rows — these rows as CSV

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