PREVIEW / etf_30min / 2024-11-29

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-29.parquet
  size:    563 KB
  rows:    21,579

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-11-29 04:00:00	SPY	ETF	599.88	600.88	599.88	600.79	8912.0
2024-11-29 04:30:00	SPY	ETF	600.85	600.87	600.71	600.75	4263.0
2024-11-29 05:00:00	SPY	ETF	600.74	600.94	600.72	600.72	5571.0
2024-11-29 05:30:00	SPY	ETF	600.81	600.81	600.56	600.72	8100.0
2024-11-29 06:00:00	SPY	ETF	600.52	600.7	600.46	600.7	1036.0
2024-11-29 06:30:00	SPY	ETF	600.71	600.85	600.71	600.84	4335.0
2024-11-29 07:00:00	SPY	ETF	600.71	600.8	600.51	600.7	78434.0
2024-11-29 07:30:00	SPY	ETF	600.68	600.7	600.15	600.38	17690.0
2024-11-29 08:00:00	SPY	ETF	600.72	600.8	599.91	600.09	65705.0
2024-11-29 08:30:00	SPY	ETF	600.05	600.05	599.34	599.7	76719.0
2024-11-29 09:00:00	SPY	ETF	599.85	600.34	599.52	599.6	184168.0
2024-11-29 09:30:00	SPY	ETF	599.64	600.7199	599.3805	600.71	2223659.0
2024-11-29 10:00:00	SPY	ETF	600.71	601.74	600.695	601.4175	1770708.0
2024-11-29 10:30:00	SPY	ETF	601.42	601.89	601.41	601.81	1287507.0
2024-11-29 11:00:00	SPY	ETF	601.81	602.3897	601.8	602.33	1349506.0
2024-11-29 11:30:00	SPY	ETF	602.325	602.89	602.06	602.69	1151841.0
2024-11-29 12:00:00	SPY	ETF	602.7	603.26	602.59	602.83	1984795.0
2024-11-29 12:30:00	SPY	ETF	602.83	603.35	602.3	602.45	6637367.0
2024-11-29 13:00:00	SPY	ETF	602.46	602.8091	602.0928	602.65	3149272.0
2024-11-29 13:30:00	SPY	ETF	602.65	602.78	602.55	602.66	233946.0
2024-11-29 14:00:00	SPY	ETF	602.64	602.7	602.4601	602.5	32028.0
2024-11-29 14:30:00	SPY	ETF	602.46	602.67	602.35	602.6	81294.0
2024-11-29 15:00:00	SPY	ETF	602.6	602.78	602.58	602.77	6899.0
2024-11-29 15:30:00	SPY	ETF	602.78	602.9	602.61	602.9	39583.0
2024-11-29 16:00:00	SPY	ETF	602.78	603.05	602.61	603.05	30257.0
2024-11-29 16:30:00	SPY	ETF	603.05	603.14	602.85	603.12	41777.0
2024-11-29 04:00:00	QQQ	ETF	507.0	507.8	507.0	507.7	31156.0
2024-11-29 04:30:00	QQQ	ETF	507.71	507.8	507.52	507.56	9757.0
2024-11-29 05:00:00	QQQ	ETF	507.46	507.72	507.41	507.48	4780.0
2024-11-29 05:30:00	QQQ	ETF	507.4	507.56	507.14	507.54	7224.0
2024-11-29 06:00:00	QQQ	ETF	507.42	507.47	507.1	507.19	4791.0
2024-11-29 06:30:00	QQQ	ETF	507.28	507.35	507.14	507.32	9940.0
2024-11-29 07:00:00	QQQ	ETF	507.18	507.23	506.9	506.98	19840.0
2024-11-29 07:30:00	QQQ	ETF	506.96	507.0	506.25	506.57	32186.0
2024-11-29 08:00:00	QQQ	ETF	507.08	508.33	505.678	506.15	98378.0
2024-11-29 08:30:00	QQQ	ETF	506.14	506.2	505.48	505.83	109690.0
2024-11-29 09:00:00	QQQ	ETF	505.92	506.92	505.7304	505.84	123317.0
2024-11-29 09:30:00	QQQ	ETF	505.93	508.0	505.31	507.94	2025346.0
2024-11-29 10:00:00	QQQ	ETF	507.95	509.31	507.69	508.63	1842562.0
2024-11-29 10:30:00	QQQ	ETF	508.63	509.51	508.4209	508.8899	1008248.0
2024-11-29 11:00:00	QQQ	ETF	508.89	509.86	508.88	509.66	1046288.0
2024-11-29 11:30:00	QQQ	ETF	509.64	510.08	509.1701	509.83	1059756.0
2024-11-29 12:00:00	QQQ	ETF	509.83	510.005	509.4201	509.5	1007339.0
2024-11-29 12:30:00	QQQ	ETF	509.52	510.34	509.48	509.71	1874850.0
2024-11-29 13:00:00	QQQ	ETF	509.71	509.85	505.3	509.64	520890.0
2024-11-29 13:30:00	QQQ	ETF	509.675	509.8	509.6124	509.62	152748.0
2024-11-29 14:00:00	QQQ	ETF	509.61	509.71	509.56	509.6	12683.0
2024-11-29 14:30:00	QQQ	ETF	509.6	509.98	509.55	509.98	31632.0
2024-11-29 15:00:00	QQQ	ETF	509.98	509.98	509.81	509.95	3946.0
2024-11-29 15:30:00	QQQ	ETF	509.9017	509.94	509.67	509.85	7178.0

> showing 50 of 21,579 rows — these rows as CSV

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