PREVIEW / etf_30min / 2025-05-05

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-05.parquet
  size:    990 KB
  rows:    40,324

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-05-05 04:00:00	SPY	ETF	563.85	564.49	563.17	563.17	27138.0
2025-05-05 04:30:00	SPY	ETF	563.13	563.13	561.7	562.19	45704.0
2025-05-05 05:00:00	SPY	ETF	562.12	562.74	561.76	562.64	28581.0
2025-05-05 05:30:00	SPY	ETF	562.71	562.94	562.43	562.58	10138.0
2025-05-05 06:00:00	SPY	ETF	562.62	562.83	562.4	562.47	17351.0
2025-05-05 06:30:00	SPY	ETF	562.47	562.82	562.2	562.74	41863.0
2025-05-05 07:00:00	SPY	ETF	562.79	562.91	562.47	562.56	80046.0
2025-05-05 07:30:00	SPY	ETF	562.51	562.75	561.83	562.23	118606.0
2025-05-05 08:00:00	SPY	ETF	562.78	563.9	561.89	562.539	264168.0
2025-05-05 08:30:00	SPY	ETF	562.5	562.72	562.05	562.6	121622.0
2025-05-05 09:00:00	SPY	ETF	562.575	563.11	562.39	562.62	132639.0
2025-05-05 09:30:00	SPY	ETF	562.55	563.3	561.7	562.99	3769042.0
2025-05-05 10:00:00	SPY	ETF	563.07	564.2891	562.43	563.69	2648038.0
2025-05-05 10:30:00	SPY	ETF	563.69	565.19	562.92	565.0	2184888.0
2025-05-05 11:00:00	SPY	ETF	565.01	565.31	564.45	564.8048	2139597.0
2025-05-05 11:30:00	SPY	ETF	564.809	565.13	563.84	565.0	1402899.0
2025-05-05 12:00:00	SPY	ETF	565.0	565.8999	564.8188	565.71	1354659.0
2025-05-05 12:30:00	SPY	ETF	565.7	565.9599	565.1822	565.61	959800.0
2025-05-05 13:00:00	SPY	ETF	565.6	565.66	564.84	565.16	1026226.0
2025-05-05 13:30:00	SPY	ETF	565.15	566.08	565.08	565.6801	829116.0
2025-05-05 14:00:00	SPY	ETF	565.68	566.38	565.5702	566.15	1185757.0
2025-05-05 14:30:00	SPY	ETF	566.13	566.65	565.72	565.785	1442102.0
2025-05-05 15:00:00	SPY	ETF	565.78	565.88	564.56	564.77	2717873.0
2025-05-05 15:30:00	SPY	ETF	564.76	565.37	563.09	563.53	4525472.0
2025-05-05 16:00:00	SPY	ETF	563.55	563.65	562.74	562.87	1859854.0
2025-05-05 16:30:00	SPY	ETF	564.512	564.512	562.72	563.24	267815.0
2025-05-05 17:00:00	SPY	ETF	563.25	563.35	563.0	563.0	61383.0
2025-05-05 17:30:00	SPY	ETF	562.97	563.3173	562.95	563.02	129959.0
2025-05-05 18:00:00	SPY	ETF	562.95	563.398	562.7	563.01	35734.0
2025-05-05 18:30:00	SPY	ETF	563.2	563.25	562.8	562.8202	18848.0
2025-05-05 19:00:00	SPY	ETF	562.89	563.19	562.86	563.01	8294.0
2025-05-05 19:30:00	SPY	ETF	563.0	563.01	562.75	562.81	11722.0
2025-05-05 04:00:00	QQQ	ETF	485.82	486.2	485.63	485.71	52649.0
2025-05-05 04:30:00	QQQ	ETF	485.5	485.5	483.93	484.35	72602.0
2025-05-05 05:00:00	QQQ	ETF	484.42	484.85	484.0	484.61	36913.0
2025-05-05 05:30:00	QQQ	ETF	484.75	485.02	484.44	484.7	8910.0
2025-05-05 06:00:00	QQQ	ETF	484.64	484.78	484.34	484.36	20437.0
2025-05-05 06:30:00	QQQ	ETF	484.4	484.65	483.99	484.58	58578.0
2025-05-05 07:00:00	QQQ	ETF	484.69	484.84	484.36	484.48	76090.0
2025-05-05 07:30:00	QQQ	ETF	484.34	484.63	483.68	483.96	74907.0
2025-05-05 08:00:00	QQQ	ETF	484.6	486.76	483.7	484.36	238352.0
2025-05-05 08:30:00	QQQ	ETF	484.23	484.59	483.84	484.5	96246.0
2025-05-05 09:00:00	QQQ	ETF	484.46	484.93	484.15	484.66	119572.0
2025-05-05 09:30:00	QQQ	ETF	484.6	486.15	484.1	485.75	2750293.0
2025-05-05 10:00:00	QQQ	ETF	485.78	487.09	485.16	485.86	1530197.0
2025-05-05 10:30:00	QQQ	ETF	485.865	487.17	484.64	486.9237	1620023.0
2025-05-05 11:00:00	QQQ	ETF	486.87	487.4	486.4	486.76	1424670.0
2025-05-05 11:30:00	QQQ	ETF	486.79	487.01	485.99	486.89	689803.0
2025-05-05 12:00:00	QQQ	ETF	486.9	487.82	486.7	487.6301	810443.0
2025-05-05 12:30:00	QQQ	ETF	487.65	487.95	487.17	487.68	477668.0

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

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