PREVIEW / etf_30min / 2024-12-02

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-02.parquet
  size:    924 KB
  rows:    37,085

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-02 04:00:00	SPY	ETF	601.9	601.9	601.39	601.5	29510.0
2024-12-02 04:30:00	SPY	ETF	601.43	601.55	601.35	601.4	5288.0
2024-12-02 05:00:00	SPY	ETF	601.3	601.64	601.24	601.64	4013.0
2024-12-02 05:30:00	SPY	ETF	601.36	601.65	601.36	601.5	5306.0
2024-12-02 06:00:00	SPY	ETF	601.59	601.85	601.43	601.82	7958.0
2024-12-02 06:30:00	SPY	ETF	601.77	602.0	601.57	601.93	103923.0
2024-12-02 07:00:00	SPY	ETF	601.91	602.4	601.86	602.35	116433.0
2024-12-02 07:30:00	SPY	ETF	602.48	602.6	602.27	602.37	56190.0
2024-12-02 08:00:00	SPY	ETF	602.05	602.77	601.1	602.65	98785.0
2024-12-02 08:30:00	SPY	ETF	602.63	602.63	602.33	602.62	134055.0
2024-12-02 09:00:00	SPY	ETF	602.62	603.08	602.49	602.97	306234.0
2024-12-02 09:30:00	SPY	ETF	602.97	603.6798	602.47	602.8698	3308371.0
2024-12-02 10:00:00	SPY	ETF	602.88	603.25	602.7	603.225	1255933.0
2024-12-02 10:30:00	SPY	ETF	603.22	603.57	602.47	602.7	1345620.0
2024-12-02 11:00:00	SPY	ETF	602.71	603.36	602.51	603.28	714339.0
2024-12-02 11:30:00	SPY	ETF	603.265	603.86	603.1903	603.655	1067070.0
2024-12-02 12:00:00	SPY	ETF	603.6598	603.96	603.46	603.47	990736.0
2024-12-02 12:30:00	SPY	ETF	603.49	603.82	603.4	603.57	574497.0
2024-12-02 13:00:00	SPY	ETF	603.53	603.8799	603.4	603.67	690203.0
2024-12-02 13:30:00	SPY	ETF	603.6758	603.83	603.39	603.79	741918.0
2024-12-02 14:00:00	SPY	ETF	603.79	603.79	603.05	603.4	1164805.0
2024-12-02 14:30:00	SPY	ETF	603.4101	603.985	603.39	603.935	1119564.0
2024-12-02 15:00:00	SPY	ETF	603.93	604.32	603.6999	604.26	1144936.0
2024-12-02 15:30:00	SPY	ETF	604.28	604.28	603.45	603.65	4368039.0
2024-12-02 16:00:00	SPY	ETF	603.65	604.2	603.58	603.84	1980015.0
2024-12-02 16:30:00	SPY	ETF	603.79	603.98	603.649	603.66	422570.0
2024-12-02 17:00:00	SPY	ETF	603.7	603.824	603.5	603.8	222820.0
2024-12-02 17:30:00	SPY	ETF	603.78	603.8	603.69	603.78	12987.0
2024-12-02 18:00:00	SPY	ETF	603.75	604.01	603.51	603.97	29051.0
2024-12-02 18:30:00	SPY	ETF	603.96	603.96	603.7	603.85	7306.0
2024-12-02 19:00:00	SPY	ETF	603.87	603.94	603.74	603.74	5372.0
2024-12-02 19:30:00	SPY	ETF	603.75	603.75	603.61	603.62	21419.0
2024-12-02 04:00:00	QQQ	ETF	509.51	509.51	508.93	509.06	42435.0
2024-12-02 04:30:00	QQQ	ETF	509.1	509.13	508.78	508.78	11800.0
2024-12-02 05:00:00	QQQ	ETF	508.75	509.11	508.66	508.94	12813.0
2024-12-02 05:30:00	QQQ	ETF	508.82	509.09	508.73	508.8	8076.0
2024-12-02 06:00:00	QQQ	ETF	508.96	509.1	508.79	509.1	4491.0
2024-12-02 06:30:00	QQQ	ETF	509.07	509.25	508.84	509.25	9097.0
2024-12-02 07:00:00	QQQ	ETF	509.24	510.14	509.2	510.09	56864.0
2024-12-02 07:30:00	QQQ	ETF	510.09	510.25	509.83	510.16	36767.0
2024-12-02 08:00:00	QQQ	ETF	510.16	510.85	508.63	510.55	107336.0
2024-12-02 08:30:00	QQQ	ETF	510.57	510.7	510.13	510.68	103565.0
2024-12-02 09:00:00	QQQ	ETF	510.65	511.1	510.58	511.08	133876.0
2024-12-02 09:30:00	QQQ	ETF	511.01	514.1	510.62	513.67	3593207.0
2024-12-02 10:00:00	QQQ	ETF	513.68	514.74	513.59	514.4	1427219.0
2024-12-02 10:30:00	QQQ	ETF	514.3997	514.89	513.43	513.7635	1143015.0
2024-12-02 11:00:00	QQQ	ETF	513.79	514.7575	513.7	514.43	775868.0
2024-12-02 11:30:00	QQQ	ETF	514.42	515.72	514.3	515.53	1093605.0
2024-12-02 12:00:00	QQQ	ETF	515.515	516.26	515.49	515.64	1384160.0
2024-12-02 12:30:00	QQQ	ETF	515.64	515.97	515.44	515.51	576130.0

> showing 50 of 37,085 rows — these rows as CSV

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