PREVIEW / etf_30min / 2025-08-13

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-13.parquet
  size:    1.0 MB
  rows:    42,186

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-08-13 04:00:00	SPY	ETF	643.55	644.17	643.53	644.12	16945.0
2025-08-13 04:30:00	SPY	ETF	644.1	644.38	643.82	643.84	8135.0
2025-08-13 05:00:00	SPY	ETF	643.91	644.01	643.79	643.87	5188.0
2025-08-13 05:30:00	SPY	ETF	643.81	644.4	643.81	644.34	18805.0
2025-08-13 06:00:00	SPY	ETF	644.36	644.39	644.08	644.08	9262.0
2025-08-13 06:30:00	SPY	ETF	644.11	644.22	643.9	644.09	10361.0
2025-08-13 07:00:00	SPY	ETF	644.13	644.29	644.01	644.09	27440.0
2025-08-13 07:30:00	SPY	ETF	644.09	644.32	643.92	644.25	50397.0
2025-08-13 08:00:00	SPY	ETF	644.15	644.3404	642.57	644.23	124910.0
2025-08-13 08:30:00	SPY	ETF	644.21	644.79	644.19	644.55	158276.0
2025-08-13 09:00:00	SPY	ETF	644.58	644.95	644.55	644.92	152526.0
2025-08-13 09:30:00	SPY	ETF	644.91	646.19	644.49	645.62	5821342.0
2025-08-13 10:00:00	SPY	ETF	645.63	645.7188	643.99	644.24	4317605.0
2025-08-13 10:30:00	SPY	ETF	644.245	644.405	643.58	643.83	3370218.0
2025-08-13 11:00:00	SPY	ETF	643.82	644.11	643.07	643.67	3421946.0
2025-08-13 11:30:00	SPY	ETF	643.67	644.255	643.34	643.43	2228957.0
2025-08-13 12:00:00	SPY	ETF	643.44	643.915	643.23	643.27	1433510.0
2025-08-13 12:30:00	SPY	ETF	643.26	643.56	642.68	643.01	1745062.0
2025-08-13 13:00:00	SPY	ETF	643.01	643.7	642.7	643.6408	1964607.0
2025-08-13 13:30:00	SPY	ETF	643.64	643.76	642.775	643.55	1689614.0
2025-08-13 14:00:00	SPY	ETF	643.56	644.2	643.39	643.89	1863020.0
2025-08-13 14:30:00	SPY	ETF	643.91	644.31	643.24	644.015	2240819.0
2025-08-13 15:00:00	SPY	ETF	644.02	644.73	643.8312	644.29	2615666.0
2025-08-13 15:30:00	SPY	ETF	644.295	645.1	643.91	644.88	6621943.0
2025-08-13 16:00:00	SPY	ETF	644.87	645.25	644.45	644.47	1959863.0
2025-08-13 16:30:00	SPY	ETF	644.5	644.58	644.34	644.39	113234.0
2025-08-13 17:00:00	SPY	ETF	644.45	644.69	644.4	644.61	36649.0
2025-08-13 17:30:00	SPY	ETF	644.5998	644.65	644.47	644.63	9766.0
2025-08-13 18:00:00	SPY	ETF	644.57	644.57	643.99	644.47	36792.0
2025-08-13 18:30:00	SPY	ETF	644.4797	644.83	644.44	644.81	6644.0
2025-08-13 19:00:00	SPY	ETF	644.81	644.85	644.63	644.72	4150.0
2025-08-13 19:30:00	SPY	ETF	644.7	644.99	644.7	644.72	18677.0
2025-08-13 04:00:00	QQQ	ETF	581.5	581.85	581.13	581.75	43503.0
2025-08-13 04:30:00	QQQ	ETF	581.75	582.05	581.5	581.53	20311.0
2025-08-13 05:00:00	QQQ	ETF	581.55	581.61	581.37	581.37	9450.0
2025-08-13 05:30:00	QQQ	ETF	581.42	581.92	581.38	581.89	9924.0
2025-08-13 06:00:00	QQQ	ETF	581.9	581.99	581.74	581.74	10564.0
2025-08-13 06:30:00	QQQ	ETF	581.76	581.81	581.46	581.55	11180.0
2025-08-13 07:00:00	QQQ	ETF	581.53	581.72	581.44	581.54	12156.0
2025-08-13 07:30:00	QQQ	ETF	581.49	581.78	581.36	581.55	18125.0
2025-08-13 08:00:00	QQQ	ETF	581.59	582.0	579.615	581.89	91317.0
2025-08-13 08:30:00	QQQ	ETF	581.82	582.49	581.8	582.15	152623.0
2025-08-13 09:00:00	QQQ	ETF	582.1209	582.79	582.1209	582.77	93411.0
2025-08-13 09:30:00	QQQ	ETF	582.76	583.3199	581.815	582.0895	3855847.0
2025-08-13 10:00:00	QQQ	ETF	582.1	582.11	580.41	580.64	3129856.0
2025-08-13 10:30:00	QQQ	ETF	580.63	581.03	580.06	580.6988	2400287.0
2025-08-13 11:00:00	QQQ	ETF	580.69	580.73	579.065	579.87	3177537.0
2025-08-13 11:30:00	QQQ	ETF	579.9	580.67	579.7	579.87	1330403.0
2025-08-13 12:00:00	QQQ	ETF	579.9	580.2344	579.46	579.78	1084855.0
2025-08-13 12:30:00	QQQ	ETF	579.76	579.91	578.94	579.2506	1264932.0

> showing 50 of 42,186 rows — these rows as CSV

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