PREVIEW / etf_30min / 2025-07-03

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-03.parquet
  size:    678 KB
  rows:    26,885

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-07-03 04:00:00	SPY	ETF	621.22	621.37	620.89	621.3	16116.0
2025-07-03 04:30:00	SPY	ETF	621.31	621.32	620.69	620.69	12151.0
2025-07-03 05:00:00	SPY	ETF	620.68	621.2	620.68	621.16	10346.0
2025-07-03 05:30:00	SPY	ETF	621.2	621.2	620.78	620.78	7390.0
2025-07-03 06:00:00	SPY	ETF	620.84	620.84	620.51	620.63	9951.0
2025-07-03 06:30:00	SPY	ETF	620.65	621.0	620.65	620.97	4346.0
2025-07-03 07:00:00	SPY	ETF	620.96	621.26	620.88	621.21	44773.0
2025-07-03 07:30:00	SPY	ETF	621.19	621.27	620.91	621.25	68156.0
2025-07-03 08:00:00	SPY	ETF	621.12	621.65	620.81	621.33	205361.0
2025-07-03 08:30:00	SPY	ETF	621.75	622.82	621.41	621.66	721427.0
2025-07-03 09:00:00	SPY	ETF	621.68	622.6299	621.68	622.48	333468.0
2025-07-03 09:30:00	SPY	ETF	622.45	624.545	622.43	624.07	6492834.0
2025-07-03 10:00:00	SPY	ETF	624.06	625.11	624.04	625.0	4153084.0
2025-07-03 10:30:00	SPY	ETF	625.0	625.47	624.79	625.3	2914291.0
2025-07-03 11:00:00	SPY	ETF	625.31	625.785	625.17	625.42	2967173.0
2025-07-03 11:30:00	SPY	ETF	625.42	626.08	625.36	625.9	3147382.0
2025-07-03 12:00:00	SPY	ETF	625.902	626.05	625.5501	625.735	3410042.0
2025-07-03 12:30:00	SPY	ETF	625.73	626.28	624.87	625.35	8029634.0
2025-07-03 13:00:00	SPY	ETF	625.35	625.72	624.5	624.99	1807934.0
2025-07-03 13:30:00	SPY	ETF	624.99	625.25	624.9	624.94	478390.0
2025-07-03 14:00:00	SPY	ETF	624.95	625.0	624.85	624.87	230209.0
2025-07-03 14:30:00	SPY	ETF	624.87	624.97	624.79	624.8	72339.0
2025-07-03 15:00:00	SPY	ETF	624.79	624.97	624.79	624.95	52550.0
2025-07-03 15:30:00	SPY	ETF	624.9007	625.34	624.83	625.13	1061525.0
2025-07-03 16:00:00	SPY	ETF	625.12	625.12	624.84	624.85	22454.0
2025-07-03 16:30:00	SPY	ETF	624.85	625.04	624.8207	625.01	39661.0
2025-07-03 04:00:00	QQQ	ETF	552.05	552.27	551.91	552.05	16035.0
2025-07-03 04:30:00	QQQ	ETF	552.13	552.14	551.38	551.38	12776.0
2025-07-03 05:00:00	QQQ	ETF	551.22	551.79	551.22	551.72	15540.0
2025-07-03 05:30:00	QQQ	ETF	551.72	551.75	551.2	551.22	13905.0
2025-07-03 06:00:00	QQQ	ETF	551.26	551.36	550.8	551.0	19195.0
2025-07-03 06:30:00	QQQ	ETF	551.02	551.39	551.02	551.35	12021.0
2025-07-03 07:00:00	QQQ	ETF	551.34	551.68	551.29	551.68	16363.0
2025-07-03 07:30:00	QQQ	ETF	551.64	551.67	551.3	551.54	35663.0
2025-07-03 08:00:00	QQQ	ETF	551.49	552.44	550.98	551.52	77112.0
2025-07-03 08:30:00	QQQ	ETF	551.83	553.25	551.83	552.26	341825.0
2025-07-03 09:00:00	QQQ	ETF	552.28	553.38	552.28	553.23	151281.0
2025-07-03 09:30:00	QQQ	ETF	553.18	554.94	553.18	554.75	4384220.0
2025-07-03 10:00:00	QQQ	ETF	554.74	556.33	554.74	556.2	2727763.0
2025-07-03 10:30:00	QQQ	ETF	556.2	556.37	555.6499	555.9107	1906718.0
2025-07-03 11:00:00	QQQ	ETF	555.92	556.67	555.905	556.42	1838503.0
2025-07-03 11:30:00	QQQ	ETF	556.41	557.2	556.34	556.78	1215989.0
2025-07-03 12:00:00	QQQ	ETF	556.7891	557.05	556.5186	556.57	1221129.0
2025-07-03 12:30:00	QQQ	ETF	556.566	556.79	555.48	556.16	2780300.0
2025-07-03 13:00:00	QQQ	ETF	556.2	556.5932	555.6	555.95	1070230.0
2025-07-03 13:30:00	QQQ	ETF	555.95	555.96	555.71	555.78	68440.0
2025-07-03 14:00:00	QQQ	ETF	555.79	555.92	555.75	555.8	63706.0
2025-07-03 14:30:00	QQQ	ETF	555.79	555.8	555.73	555.75	48725.0
2025-07-03 15:00:00	QQQ	ETF	555.79	555.88	555.751	555.8698	25057.0
2025-07-03 15:30:00	QQQ	ETF	555.86	555.93	555.7	555.83	29911.0

> showing 50 of 26,885 rows — these rows as CSV

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