PREVIEW / etf_30min / 2024-09-30

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-09-30.parquet
  size:    876 KB
  rows:    35,622

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-09-30 04:00:00	SPY	ETF	571.5	571.6	570.88	571.39	12766.0
2024-09-30 04:30:00	SPY	ETF	570.94	571.33	570.85	571.14	13939.0
2024-09-30 05:00:00	SPY	ETF	570.96	571.36	570.68	571.33	9614.0
2024-09-30 05:30:00	SPY	ETF	571.25	571.42	571.12	571.33	4778.0
2024-09-30 06:00:00	SPY	ETF	571.25	571.42	571.13	571.23	5523.0
2024-09-30 06:30:00	SPY	ETF	571.18	571.18	570.75	571.0	4412.0
2024-09-30 07:00:00	SPY	ETF	570.9	570.9	570.03	570.21	63827.0
2024-09-30 07:30:00	SPY	ETF	570.18	570.35	569.8	570.02	88347.0
2024-09-30 08:00:00	SPY	ETF	570.7604	572.0	569.89	570.2	62046.0
2024-09-30 08:30:00	SPY	ETF	570.24	570.37	569.98	570.22	60175.0
2024-09-30 09:00:00	SPY	ETF	570.25	570.62	570.07	570.42	126452.0
2024-09-30 09:30:00	SPY	ETF	570.42	571.49	570.4	570.6492	2472530.0
2024-09-30 10:00:00	SPY	ETF	570.62	571.08	570.25	570.92	1291222.0
2024-09-30 10:30:00	SPY	ETF	570.9126	571.63	570.865	571.27	1224701.0
2024-09-30 11:00:00	SPY	ETF	571.29	571.76	571.1	571.63	1110250.0
2024-09-30 11:30:00	SPY	ETF	571.63	571.82	570.7311	571.565	1060214.0
2024-09-30 12:00:00	SPY	ETF	571.57	572.26	571.5401	571.88	1270732.0
2024-09-30 12:30:00	SPY	ETF	571.87	571.96	571.5376	571.58	709287.0
2024-09-30 13:00:00	SPY	ETF	571.57	571.57	570.91	571.0694	1047027.0
2024-09-30 13:30:00	SPY	ETF	571.04	571.71	570.99	571.59	863043.0
2024-09-30 14:00:00	SPY	ETF	571.58	571.63	568.08	569.2908	4095821.0
2024-09-30 14:30:00	SPY	ETF	569.29	571.18	568.73	570.541	2891721.0
2024-09-30 15:00:00	SPY	ETF	570.55	571.05	569.93	570.89	1959864.0
2024-09-30 15:30:00	SPY	ETF	570.9	574.38	570.8	574.02	12732326.0
2024-09-30 16:00:00	SPY	ETF	574.02	574.1	573.13	573.7094	7455327.0
2024-09-30 16:30:00	SPY	ETF	573.7	573.7	572.9575	572.96	309023.0
2024-09-30 17:00:00	SPY	ETF	572.96	573.07	572.86	573.037	173838.0
2024-09-30 17:30:00	SPY	ETF	573.03	573.3	572.87	573.18	120565.0
2024-09-30 18:00:00	SPY	ETF	573.17	573.26	572.56	573.0	96813.0
2024-09-30 18:30:00	SPY	ETF	573.02	573.25	573.0	573.1	24704.0
2024-09-30 19:00:00	SPY	ETF	573.05	573.14	572.84	572.85	11156.0
2024-09-30 19:30:00	SPY	ETF	572.89	573.27	572.84	573.24	19168.0
2024-09-30 04:00:00	QQQ	ETF	486.86	486.89	485.76	486.36	38421.0
2024-09-30 04:30:00	QQQ	ETF	486.35	486.35	485.7	486.08	15169.0
2024-09-30 05:00:00	QQQ	ETF	486.03	486.43	485.56	486.35	22793.0
2024-09-30 05:30:00	QQQ	ETF	486.27	486.48	486.03	486.28	12116.0
2024-09-30 06:00:00	QQQ	ETF	486.34	486.7	486.34	486.49	14294.0
2024-09-30 06:30:00	QQQ	ETF	486.42	486.42	485.95	486.28	10791.0
2024-09-30 07:00:00	QQQ	ETF	486.15	486.23	485.06	485.29	61333.0
2024-09-30 07:30:00	QQQ	ETF	485.22	485.44	484.38	484.62	53335.0
2024-09-30 08:00:00	QQQ	ETF	485.15	487.32	484.4	485.38	93570.0
2024-09-30 08:30:00	QQQ	ETF	485.36	485.7	485.05	485.6098	350830.0
2024-09-30 09:00:00	QQQ	ETF	485.6	486.04	485.44	485.77	124938.0
2024-09-30 09:30:00	QQQ	ETF	485.78	487.79	485.53	486.4099	2318892.0
2024-09-30 10:00:00	QQQ	ETF	486.43	486.8	484.59	485.92	1390039.0
2024-09-30 10:30:00	QQQ	ETF	485.95	486.53	485.4	485.808	989474.0
2024-09-30 11:00:00	QQQ	ETF	485.77	486.917	485.6	486.9	786768.0
2024-09-30 11:30:00	QQQ	ETF	486.94	487.12	485.5203	486.46	814440.0
2024-09-30 12:00:00	QQQ	ETF	486.47	487.58	486.4	487.15	835420.0
2024-09-30 12:30:00	QQQ	ETF	487.14	487.25	486.51	486.5899	568818.0

> showing 50 of 35,622 rows — these rows as CSV

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