PREVIEW / etf_30min / 2024-12-23

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-23.parquet
  size:    938 KB
  rows:    38,334

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
2024-12-23 04:00:00	SPY	ETF	593.58	593.58	592.46	592.6	20498.0
2024-12-23 04:30:00	SPY	ETF	592.84	593.08	592.7	592.74	27238.0
2024-12-23 05:00:00	SPY	ETF	592.7	592.9	592.03	592.22	10446.0
2024-12-23 05:30:00	SPY	ETF	592.02	592.12	591.47	591.73	9744.0
2024-12-23 06:00:00	SPY	ETF	591.35	591.35	590.4	590.4	16131.0
2024-12-23 06:30:00	SPY	ETF	590.39	590.76	590.16	590.41	32416.0
2024-12-23 07:00:00	SPY	ETF	590.46	591.69	590.46	591.47	67779.0
2024-12-23 07:30:00	SPY	ETF	591.56	591.92	591.3	591.78	108365.0
2024-12-23 08:00:00	SPY	ETF	590.68	594.0	590.56	591.52	121131.0
2024-12-23 08:30:00	SPY	ETF	591.51	591.51	589.34	589.88	273862.0
2024-12-23 09:00:00	SPY	ETF	589.85	590.94	589.7	590.89	215544.0
2024-12-23 09:30:00	SPY	ETF	590.89	591.77	589.18	590.45	3419530.0
2024-12-23 10:00:00	SPY	ETF	590.42	590.6099	587.661	589.3	2125358.0
2024-12-23 10:30:00	SPY	ETF	589.3	590.15	588.71	589.08	1288591.0
2024-12-23 11:00:00	SPY	ETF	589.06	590.84	588.96	590.6569	1288899.0
2024-12-23 11:30:00	SPY	ETF	590.67	592.5699	590.18	592.51	2043338.0
2024-12-23 12:00:00	SPY	ETF	592.51	593.12	591.3401	592.13	987675.0
2024-12-23 12:30:00	SPY	ETF	592.13	592.94	591.7	592.5995	853587.0
2024-12-23 13:00:00	SPY	ETF	592.595	593.4	592.41	593.2997	1348417.0
2024-12-23 13:30:00	SPY	ETF	593.27	593.93	593.25	593.67	998288.0
2024-12-23 14:00:00	SPY	ETF	593.67	594.31	593.61	593.86	1092082.0
2024-12-23 14:30:00	SPY	ETF	593.89	594.03	592.92	592.98	1604187.0
2024-12-23 15:00:00	SPY	ETF	592.93	593.4099	592.25	593.305	2212187.0
2024-12-23 15:30:00	SPY	ETF	593.315	595.3	593.2694	594.78	7890852.0
2024-12-23 16:00:00	SPY	ETF	594.8	595.17	594.12	594.7	7817301.0
2024-12-23 16:30:00	SPY	ETF	594.63	594.75	594.45	594.61	233886.0
2024-12-23 17:00:00	SPY	ETF	594.6008	594.8	594.51	594.79	9495.0
2024-12-23 17:30:00	SPY	ETF	594.76	594.79	594.76	594.76	1757.0
2024-12-23 18:00:00	SPY	ETF	594.88	595.24	594.77	595.19	24950.0
2024-12-23 18:30:00	SPY	ETF	595.1	595.1	594.61	594.72	21751.0
2024-12-23 19:00:00	SPY	ETF	594.66	594.66	594.15	594.4	12607.0
2024-12-23 19:30:00	SPY	ETF	594.39	594.67	594.39	594.65	6740.0
2024-12-23 04:00:00	QQQ	ETF	520.9	521.15	520.23	520.41	116806.0
2024-12-23 04:30:00	QQQ	ETF	520.61	520.99	520.43	520.43	22181.0
2024-12-23 05:00:00	QQQ	ETF	520.53	520.8	519.79	520.13	15628.0
2024-12-23 05:30:00	QQQ	ETF	519.8	519.92	519.28	519.75	43778.0
2024-12-23 06:00:00	QQQ	ETF	519.63	519.63	518.42	518.52	40600.0
2024-12-23 06:30:00	QQQ	ETF	518.41	519.02	518.3	518.72	48383.0
2024-12-23 07:00:00	QQQ	ETF	518.82	520.37	518.76	520.28	76308.0
2024-12-23 07:30:00	QQQ	ETF	520.26	520.7	520.0	520.67	90710.0
2024-12-23 08:00:00	QQQ	ETF	518.91	522.37	518.298	520.47	128144.0
2024-12-23 08:30:00	QQQ	ETF	520.37	520.43	517.73	518.26	189261.0
2024-12-23 09:00:00	QQQ	ETF	518.27	519.56	518.11	519.56	224978.0
2024-12-23 09:30:00	QQQ	ETF	519.55	520.83	517.95	519.85	2804272.0
2024-12-23 10:00:00	QQQ	ETF	519.78	520.1	516.13	517.73	1576093.0
2024-12-23 10:30:00	QQQ	ETF	517.72	518.98	517.28	518.19	1037158.0
2024-12-23 11:00:00	QQQ	ETF	518.07	520.02	518.06	519.86	777220.0
2024-12-23 11:30:00	QQQ	ETF	519.93	521.42	519.17	521.37	1088885.0
2024-12-23 12:00:00	QQQ	ETF	521.35	522.12	520.13	520.7922	905097.0
2024-12-23 12:30:00	QQQ	ETF	520.84	521.9	520.56	521.34	706234.0

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

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