PREVIEW / etf_30min / 2025-01-27

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-27.parquet
  size:    995 KB
  rows:    41,165

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-27 04:00:00	SPY	ETF	598.78	598.83	595.68	596.13	87682.0
2025-01-27 04:30:00	SPY	ETF	596.05	596.93	595.75	595.9	100962.0
2025-01-27 05:00:00	SPY	ETF	595.95	595.98	593.93	593.93	144003.0
2025-01-27 05:30:00	SPY	ETF	594.1	594.1	589.75	592.25	256240.0
2025-01-27 06:00:00	SPY	ETF	592.25	594.2	592.1	592.97	564567.0
2025-01-27 06:30:00	SPY	ETF	592.89	594.12	592.78	593.23	419184.0
2025-01-27 07:00:00	SPY	ETF	593.24	595.2	593.16	594.6	520696.0
2025-01-27 07:30:00	SPY	ETF	594.48	595.67	594.31	595.05	591355.0
2025-01-27 08:00:00	SPY	ETF	593.69	602.3	590.5251	596.21	595697.0
2025-01-27 08:30:00	SPY	ETF	596.24	596.42	595.28	595.67	362793.0
2025-01-27 09:00:00	SPY	ETF	595.77	595.77	594.63	594.83	527076.0
2025-01-27 09:30:00	SPY	ETF	594.83	598.665	594.64	598.62	7545795.0
2025-01-27 10:00:00	SPY	ETF	598.59	599.21	596.67	599.0	3747438.0
2025-01-27 10:30:00	SPY	ETF	598.99	599.69	598.04	598.08	2466032.0
2025-01-27 11:00:00	SPY	ETF	598.09	598.25	596.29	596.51	2217803.0
2025-01-27 11:30:00	SPY	ETF	596.5	597.79	596.24	596.81	1916109.0
2025-01-27 12:00:00	SPY	ETF	596.85	598.04	596.2	597.65	2270465.0
2025-01-27 12:30:00	SPY	ETF	597.6418	598.21	596.15	596.2	1254460.0
2025-01-27 13:00:00	SPY	ETF	596.19	596.78	596.03	596.125	1108235.0
2025-01-27 13:30:00	SPY	ETF	596.11	597.43	596.07	596.58	1192423.0
2025-01-27 14:00:00	SPY	ETF	596.61	599.12	596.6	599.01	1707125.0
2025-01-27 14:30:00	SPY	ETF	598.985	598.99	596.27	596.94	2490519.0
2025-01-27 15:00:00	SPY	ETF	596.94	598.13	596.33	597.44	2742595.0
2025-01-27 15:30:00	SPY	ETF	597.46	599.57	597.15	599.41	6724537.0
2025-01-27 16:00:00	SPY	ETF	599.44	600.36	599.2	600.04	2595434.0
2025-01-27 16:30:00	SPY	ETF	600.01	600.09	599.66	599.76	317662.0
2025-01-27 17:00:00	SPY	ETF	599.74	599.98	599.74	599.95	33003.0
2025-01-27 17:30:00	SPY	ETF	599.95	600.68	599.87	600.68	56270.0
2025-01-27 18:00:00	SPY	ETF	600.47	600.66	598.54	598.82	217785.0
2025-01-27 18:30:00	SPY	ETF	599.19	600.0	598.77	599.911	73382.0
2025-01-27 19:00:00	SPY	ETF	599.94	600.11	599.24	599.3318	17058.0
2025-01-27 19:30:00	SPY	ETF	599.25	599.4	598.78	599.17	40489.0
2025-01-27 04:00:00	QQQ	ETF	516.78	517.78	512.6	512.825	327046.0
2025-01-27 04:30:00	QQQ	ETF	512.77	513.85	511.69	511.82	146804.0
2025-01-27 05:00:00	QQQ	ETF	511.85	512.0	508.9	508.9	199544.0
2025-01-27 05:30:00	QQQ	ETF	509.05	509.42	502.32	505.31	356637.0
2025-01-27 06:00:00	QQQ	ETF	505.29	508.24	505.03	506.47	629009.0
2025-01-27 06:30:00	QQQ	ETF	506.57	508.93	506.18	508.03	383538.0
2025-01-27 07:00:00	QQQ	ETF	508.15	510.1	508.06	509.74	743994.0
2025-01-27 07:30:00	QQQ	ETF	509.64	510.68	509.4	510.15	465561.0
2025-01-27 08:00:00	QQQ	ETF	508.94	529.233	502.7296	512.05	1182713.0
2025-01-27 08:30:00	QQQ	ETF	511.9702	512.22	511.038	511.72	411204.0
2025-01-27 09:00:00	QQQ	ETF	511.8101	511.8101	510.4	511.01	435981.0
2025-01-27 09:30:00	QQQ	ETF	510.92	516.14	510.53	515.93	7443556.0
2025-01-27 10:00:00	QQQ	ETF	515.87	516.82	513.4	516.77	3056259.0
2025-01-27 10:30:00	QQQ	ETF	516.71	517.99	515.37	515.446	2849405.0
2025-01-27 11:00:00	QQQ	ETF	515.48	515.8	512.62	512.965	2077642.0
2025-01-27 11:30:00	QQQ	ETF	512.94	514.64	512.37	512.9199	1997212.0
2025-01-27 12:00:00	QQQ	ETF	512.96	514.32	511.82	513.3437	1513577.0
2025-01-27 12:30:00	QQQ	ETF	513.31	514.02	511.24	511.2801	1449788.0

> showing 50 of 41,165 rows — these rows as CSV

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