PREVIEW / etf_30min / 2024-12-18

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-18.parquet
  size:    972 KB
  rows:    39,854

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-18 04:00:00	SPY	ETF	604.89	605.13	604.87	605.0	8490.0
2024-12-18 04:30:00	SPY	ETF	605.1	605.42	605.1	605.31	2896.0
2024-12-18 05:00:00	SPY	ETF	605.52	605.95	605.52	605.95	12288.0
2024-12-18 05:30:00	SPY	ETF	605.92	605.92	605.67	605.88	2768.0
2024-12-18 06:00:00	SPY	ETF	605.9	606.02	605.85	605.85	12927.0
2024-12-18 06:30:00	SPY	ETF	605.92	605.98	605.74	605.74	3599.0
2024-12-18 07:00:00	SPY	ETF	605.74	606.12	605.56	605.85	72633.0
2024-12-18 07:30:00	SPY	ETF	605.93	606.15	605.75	606.13	54528.0
2024-12-18 08:00:00	SPY	ETF	606.11	606.15	604.81	606.08	88628.0
2024-12-18 08:30:00	SPY	ETF	606.02	606.06	604.71	604.73	155172.0
2024-12-18 09:00:00	SPY	ETF	604.72	604.74	603.89	603.99	273591.0
2024-12-18 09:30:00	SPY	ETF	603.98	604.66	603.47	604.6099	2346847.0
2024-12-18 10:00:00	SPY	ETF	604.61	605.4199	604.49	605.4	1289103.0
2024-12-18 10:30:00	SPY	ETF	605.38	606.405	605.33	605.96	1466825.0
2024-12-18 11:00:00	SPY	ETF	605.9604	606.255	604.63	605.63	1909552.0
2024-12-18 11:30:00	SPY	ETF	605.62	606.11	605.41	605.76	1003175.0
2024-12-18 12:00:00	SPY	ETF	605.765	606.31	605.5	605.68	1738619.0
2024-12-18 12:30:00	SPY	ETF	605.68	605.94	605.22	605.57	855070.0
2024-12-18 13:00:00	SPY	ETF	605.5136	605.6001	605.2	605.2125	762410.0
2024-12-18 13:30:00	SPY	ETF	605.21	605.67	605.1311	605.47	1377623.0
2024-12-18 14:00:00	SPY	ETF	605.54	605.54	600.03	600.08	6110752.0
2024-12-18 14:30:00	SPY	ETF	600.1	601.25	596.09	596.44	5362109.0
2024-12-18 15:00:00	SPY	ETF	596.455	596.91	592.92	593.14	7177685.0
2024-12-18 15:30:00	SPY	ETF	593.13	593.9	585.89	586.3	22745792.0
2024-12-18 16:00:00	SPY	ETF	586.32	586.72	583.161	586.31	12582074.0
2024-12-18 16:30:00	SPY	ETF	586.28	586.8	585.32	586.28	646599.0
2024-12-18 17:00:00	SPY	ETF	586.37	587.05	586.21	586.8	359054.0
2024-12-18 17:30:00	SPY	ETF	586.8	587.29	586.76	587.1	94490.0
2024-12-18 18:00:00	SPY	ETF	587.19	588.06	586.44	588.06	324820.0
2024-12-18 18:30:00	SPY	ETF	588.05	588.05	586.52	586.7784	105673.0
2024-12-18 19:00:00	SPY	ETF	586.9	587.82	586.74	587.73	47400.0
2024-12-18 19:30:00	SPY	ETF	587.73	587.92	587.46	587.82	161615.0
2024-12-18 04:00:00	QQQ	ETF	536.8	536.8	535.92	536.24	30436.0
2024-12-18 04:30:00	QQQ	ETF	536.23	536.88	536.22	536.77	10195.0
2024-12-18 05:00:00	QQQ	ETF	536.73	537.33	536.67	537.28	15604.0
2024-12-18 05:30:00	QQQ	ETF	537.1	537.18	536.89	537.18	5912.0
2024-12-18 06:00:00	QQQ	ETF	537.2	537.5	537.09	537.29	19583.0
2024-12-18 06:30:00	QQQ	ETF	537.28	537.41	536.99	537.12	14742.0
2024-12-18 07:00:00	QQQ	ETF	537.18	537.66	537.04	537.3	228144.0
2024-12-18 07:30:00	QQQ	ETF	537.35	537.57	537.17	537.46	23554.0
2024-12-18 08:00:00	QQQ	ETF	537.05	537.65	535.94	537.1	69099.0
2024-12-18 08:30:00	QQQ	ETF	537.08	537.08	535.25	535.27	100555.0
2024-12-18 09:00:00	QQQ	ETF	535.3088	535.68	534.89	535.12	146595.0
2024-12-18 09:30:00	QQQ	ETF	535.15	535.67	533.46	535.32	1845102.0
2024-12-18 10:00:00	QQQ	ETF	535.37	536.0	534.98	535.92	805344.0
2024-12-18 10:30:00	QQQ	ETF	535.94	536.8799	535.58	536.13	725774.0
2024-12-18 11:00:00	QQQ	ETF	536.12	536.61	534.5	535.9199	946677.0
2024-12-18 11:30:00	QQQ	ETF	535.92	536.31	535.68	535.8199	707616.0
2024-12-18 12:00:00	QQQ	ETF	535.7	536.2	535.5	535.6501	397065.0
2024-12-18 12:30:00	QQQ	ETF	535.67	535.99	535.13	535.69	388730.0

> showing 50 of 39,854 rows — these rows as CSV

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