PREVIEW / etf_30min / 2023-12-28

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-28.parquet
  size:    803 KB
  rows:    31,684

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
2023-12-28 04:00:00	SPY	ETF	477.05	477.07	476.93	477.0	18008.0
2023-12-28 04:30:00	SPY	ETF	477.1	477.1	476.98	477.0	17794.0
2023-12-28 05:00:00	SPY	ETF	477.17	477.21	477.17	477.2	3005.0
2023-12-28 05:30:00	SPY	ETF	477.2	477.2	476.87	476.92	10307.0
2023-12-28 06:00:00	SPY	ETF	476.96	477.1	476.94	476.99	4150.0
2023-12-28 06:30:00	SPY	ETF	476.86	477.01	476.85	477.0	3470.0
2023-12-28 07:00:00	SPY	ETF	476.97	477.19	476.93	477.16	35402.0
2023-12-28 07:30:00	SPY	ETF	477.16	477.23	477.05	477.05	108893.0
2023-12-28 08:00:00	SPY	ETF	476.96	477.58	476.94	477.11	161076.0
2023-12-28 08:30:00	SPY	ETF	477.14	477.25	476.65	476.65	128253.0
2023-12-28 09:00:00	SPY	ETF	476.72	476.95	476.6	476.84	91366.0
2023-12-28 09:30:00	SPY	ETF	476.85	477.385	476.8	477.19	3002830.0
2023-12-28 10:00:00	SPY	ETF	477.18	477.3	476.805	477.2687	2050495.0
2023-12-28 10:30:00	SPY	ETF	477.27	477.5	476.955	477.08	2470059.0
2023-12-28 11:00:00	SPY	ETF	477.08	477.14	476.59	476.8593	2085895.0
2023-12-28 11:30:00	SPY	ETF	476.88	477.07	476.71	476.8601	1092929.0
2023-12-28 12:00:00	SPY	ETF	476.86	477.19	476.78	476.905	1559183.0
2023-12-28 12:30:00	SPY	ETF	476.9	477.41	476.86	477.2791	1238565.0
2023-12-28 13:00:00	SPY	ETF	477.27	477.33	476.43	477.04	2173610.0
2023-12-28 13:30:00	SPY	ETF	477.0382	477.55	476.9197	477.0199	1565248.0
2023-12-28 14:00:00	SPY	ETF	477.02	477.42	476.9999	477.35	1588568.0
2023-12-28 14:30:00	SPY	ETF	477.36	477.5	477.075	477.195	2148571.0
2023-12-28 15:00:00	SPY	ETF	477.2	477.21	476.62	476.9	2652306.0
2023-12-28 15:30:00	SPY	ETF	476.9	477.345	476.26	476.68	10971501.0
2023-12-28 16:00:00	SPY	ETF	476.68	477.0	476.463	476.95	3411461.0
2023-12-28 16:30:00	SPY	ETF	476.94	476.94	476.76	476.81	228895.0
2023-12-28 17:00:00	SPY	ETF	476.77	476.88	476.69	476.69	230109.0
2023-12-28 17:30:00	SPY	ETF	476.83	476.88	476.79	476.85	4954.0
2023-12-28 18:00:00	SPY	ETF	476.82	476.99	476.78	476.99	18244.0
2023-12-28 18:30:00	SPY	ETF	476.98	477.05	476.96	477.03	10253.0
2023-12-28 19:00:00	SPY	ETF	476.96	477.03	476.95	476.98	8254.0
2023-12-28 19:30:00	SPY	ETF	476.99	477.05	476.96	477.05	18415.0
2023-12-28 04:00:00	QQQ	ETF	412.55	412.83	412.14	412.8	44150.0
2023-12-28 04:30:00	QQQ	ETF	412.82	412.85	412.64	412.69	7602.0
2023-12-28 05:00:00	QQQ	ETF	412.73	412.81	412.73	412.79	3719.0
2023-12-28 05:30:00	QQQ	ETF	412.82	412.83	412.65	412.68	8484.0
2023-12-28 06:00:00	QQQ	ETF	412.72	412.76	412.71	412.72	2800.0
2023-12-28 06:30:00	QQQ	ETF	412.71	412.74	412.64	412.64	2967.0
2023-12-28 07:00:00	QQQ	ETF	412.72	412.95	412.66	412.91	29225.0
2023-12-28 07:30:00	QQQ	ETF	412.93	412.98	412.82	412.85	46004.0
2023-12-28 08:00:00	QQQ	ETF	412.7	412.98	412.0	412.9	86503.0
2023-12-28 08:30:00	QQQ	ETF	412.95	413.1	412.54	412.56	94556.0
2023-12-28 09:00:00	QQQ	ETF	412.62	412.72	412.3817	412.62	124848.0
2023-12-28 09:30:00	QQQ	ETF	412.67	412.92	411.84	412.0872	2062038.0
2023-12-28 10:00:00	QQQ	ETF	412.06	412.18	411.54	412.16	1299015.0
2023-12-28 10:30:00	QQQ	ETF	412.17	412.545	412.04	412.17	1754218.0
2023-12-28 11:00:00	QQQ	ETF	412.17	412.18	411.58	411.8	1389414.0
2023-12-28 11:30:00	QQQ	ETF	411.81	412.06	411.6318	411.775	823216.0
2023-12-28 12:00:00	QQQ	ETF	411.77	412.055	411.6901	411.92	655516.0
2023-12-28 12:30:00	QQQ	ETF	411.915	412.2691	411.83	412.215	924525.0

> showing 50 of 31,684 rows — these rows as CSV

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