PREVIEW / etf_30min / 2025-01-31

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-31.parquet
  size:    957 KB
  rows:    38,769

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-31 04:00:00	SPY	ETF	606.27	607.9	606.25	607.8	15571.0
2025-01-31 04:30:00	SPY	ETF	607.98	608.06	607.62	607.62	5687.0
2025-01-31 05:00:00	SPY	ETF	607.65	607.84	607.61	607.84	3757.0
2025-01-31 05:30:00	SPY	ETF	607.73	607.88	607.59	607.59	1928.0
2025-01-31 06:00:00	SPY	ETF	607.69	608.0	607.66	607.95	4943.0
2025-01-31 06:30:00	SPY	ETF	607.91	608.1	607.91	608.07	2439.0
2025-01-31 07:00:00	SPY	ETF	608.1	608.15	607.71	607.91	207504.0
2025-01-31 07:30:00	SPY	ETF	607.99	607.99	607.7	607.81	28970.0
2025-01-31 08:00:00	SPY	ETF	607.8	608.15	606.43	607.91	77348.0
2025-01-31 08:30:00	SPY	ETF	607.95	608.14	607.33	607.9	167394.0
2025-01-31 09:00:00	SPY	ETF	607.85	607.86	606.97	607.5	287281.0
2025-01-31 09:30:00	SPY	ETF	607.5	608.16	607.06	608.11	2694818.0
2025-01-31 10:00:00	SPY	ETF	608.12	609.02	608.04	608.9599	1954059.0
2025-01-31 10:30:00	SPY	ETF	608.96	609.63	608.85	609.45	1740437.0
2025-01-31 11:00:00	SPY	ETF	609.46	609.96	609.06	609.09	1314879.0
2025-01-31 11:30:00	SPY	ETF	609.09	609.39	608.53	608.89	1075874.0
2025-01-31 12:00:00	SPY	ETF	608.89	609.55	608.01	609.55	1676575.0
2025-01-31 12:30:00	SPY	ETF	609.545	609.73	608.93	609.09	861499.0
2025-01-31 13:00:00	SPY	ETF	609.1	609.345	606.69	606.8484	2405681.0
2025-01-31 13:30:00	SPY	ETF	606.82	607.03	604.81	605.385	3713462.0
2025-01-31 14:00:00	SPY	ETF	605.39	605.9	603.3	604.53	3712862.0
2025-01-31 14:30:00	SPY	ETF	604.52	605.13	601.94	603.63	3955092.0
2025-01-31 15:00:00	SPY	ETF	603.6	603.6	601.37	601.6689	4579786.0
2025-01-31 15:30:00	SPY	ETF	601.67	603.27	601.05	601.8	8885904.0
2025-01-31 16:00:00	SPY	ETF	601.78	603.8626	601.1	601.79	5450090.0
2025-01-31 16:30:00	SPY	ETF	601.79	602.01	601.4	601.83	180812.0
2025-01-31 17:00:00	SPY	ETF	601.87	601.9575	601.65	601.7	40050.0
2025-01-31 17:30:00	SPY	ETF	601.71	601.76	601.32	601.5	33679.0
2025-01-31 18:00:00	SPY	ETF	601.49	601.5	601.0	601.05	16537.0
2025-01-31 18:30:00	SPY	ETF	601.06	601.09	600.6609	600.6638	14105.0
2025-01-31 19:00:00	SPY	ETF	600.67	600.68	600.4	600.4	10725.0
2025-01-31 19:30:00	SPY	ETF	600.21	600.3	598.81	598.98	39595.0
2025-01-31 04:00:00	QQQ	ETF	526.0	527.4	526.0	527.4	19346.0
2025-01-31 04:30:00	QQQ	ETF	527.44	527.52	527.0	527.1	18034.0
2025-01-31 05:00:00	QQQ	ETF	527.14	527.27	526.92	527.21	16215.0
2025-01-31 05:30:00	QQQ	ETF	527.22	527.32	526.9	527.12	17139.0
2025-01-31 06:00:00	QQQ	ETF	527.11	527.66	527.1	527.51	13076.0
2025-01-31 06:30:00	QQQ	ETF	527.53	527.78	527.35	527.59	13787.0
2025-01-31 07:00:00	QQQ	ETF	527.64	527.83	527.3	527.39	53961.0
2025-01-31 07:30:00	QQQ	ETF	527.5	527.5	527.16	527.2	28797.0
2025-01-31 08:00:00	QQQ	ETF	527.55	527.8299	522.658	527.16	189563.0
2025-01-31 08:30:00	QQQ	ETF	527.21	527.7	526.56	527.34	149656.0
2025-01-31 09:00:00	QQQ	ETF	527.31	527.31	523.05	527.0	215844.0
2025-01-31 09:30:00	QQQ	ETF	526.92	529.22	526.72	529.14	2827985.0
2025-01-31 10:00:00	QQQ	ETF	529.15	530.46	529.14	529.8804	1676902.0
2025-01-31 10:30:00	QQQ	ETF	529.85	531.31	529.7923	530.84	1314229.0
2025-01-31 11:00:00	QQQ	ETF	530.84	531.5178	530.22	530.34	1149815.0
2025-01-31 11:30:00	QQQ	ETF	530.34	530.7	529.41	530.06	1000279.0
2025-01-31 12:00:00	QQQ	ETF	530.0996	530.8	529.14	530.8	1170329.0
2025-01-31 12:30:00	QQQ	ETF	530.81	530.89	530.09	530.325	693478.0

> showing 50 of 38,769 rows — these rows as CSV

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