PREVIEW / etf_30min / 2024-01-26

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-26.parquet
  size:    787 KB
  rows:    31,024

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-01-26 04:00:00	SPY	ETF	486.21	486.57	485.91	486.57	13997.0
2024-01-26 04:30:00	SPY	ETF	486.6	487.06	486.51	487.06	21325.0
2024-01-26 05:00:00	SPY	ETF	487.08	487.28	486.91	487.28	13166.0
2024-01-26 05:30:00	SPY	ETF	487.31	487.35	487.11	487.23	7505.0
2024-01-26 06:00:00	SPY	ETF	487.25	487.43	487.04	487.34	6340.0
2024-01-26 06:30:00	SPY	ETF	487.44	487.55	487.2	487.39	17090.0
2024-01-26 07:00:00	SPY	ETF	487.37	487.89	487.37	487.75	77603.0
2024-01-26 07:30:00	SPY	ETF	487.8	488.01	487.57	487.57	105130.0
2024-01-26 08:00:00	SPY	ETF	487.62	488.0	485.71	487.6	108597.0
2024-01-26 08:30:00	SPY	ETF	487.46	488.63	486.95	488.4	376538.0
2024-01-26 09:00:00	SPY	ETF	488.4	488.4	487.15	487.58	323720.0
2024-01-26 09:30:00	SPY	ETF	487.59	488.35	487.235	487.7001	4156336.0
2024-01-26 10:00:00	SPY	ETF	487.7	488.2	487.0399	488.14	3511485.0
2024-01-26 10:30:00	SPY	ETF	488.1419	489.0365	488.059	489.015	4052828.0
2024-01-26 11:00:00	SPY	ETF	489.02	489.12	488.355	488.68	3453726.0
2024-01-26 11:30:00	SPY	ETF	488.67	488.83	488.1	488.74	2668230.0
2024-01-26 12:00:00	SPY	ETF	488.74	488.88	488.225	488.35	2302920.0
2024-01-26 12:30:00	SPY	ETF	488.35	488.36	486.71	487.015	5330348.0
2024-01-26 13:00:00	SPY	ETF	487.02	487.515	486.78	487.42	2907990.0
2024-01-26 13:30:00	SPY	ETF	487.41	487.53	486.54	486.98	2371499.0
2024-01-26 14:00:00	SPY	ETF	486.9941	487.48	486.95	487.2	2050049.0
2024-01-26 14:30:00	SPY	ETF	487.21	488.15	486.945	487.97	3279460.0
2024-01-26 15:00:00	SPY	ETF	487.98	488.0599	487.34	487.47	2436394.0
2024-01-26 15:30:00	SPY	ETF	487.475	487.68	487.025	487.47	7776017.0
2024-01-26 16:00:00	SPY	ETF	487.465	487.7	487.17	487.26	4692807.0
2024-01-26 16:30:00	SPY	ETF	487.25	487.25	487.09	487.11	145928.0
2024-01-26 17:00:00	SPY	ETF	487.11	487.26	487.09	487.16	46124.0
2024-01-26 17:30:00	SPY	ETF	487.15	487.25	487.15	487.24	3139.0
2024-01-26 18:00:00	SPY	ETF	487.15	487.25	487.0	487.15	19803.0
2024-01-26 18:30:00	SPY	ETF	487.11	487.12	486.5	486.97	13341.0
2024-01-26 19:00:00	SPY	ETF	486.93	487.07	486.9	487.07	4825.0
2024-01-26 19:30:00	SPY	ETF	486.92	487.0	486.75	486.75	4260.0
2024-01-26 04:00:00	QQQ	ETF	423.28	423.28	422.3	423.21	60050.0
2024-01-26 04:30:00	QQQ	ETF	423.24	423.85	422.96	423.85	43458.0
2024-01-26 05:00:00	QQQ	ETF	423.82	424.19	423.53	424.14	68187.0
2024-01-26 05:30:00	QQQ	ETF	424.16	424.17	423.71	423.85	26372.0
2024-01-26 06:00:00	QQQ	ETF	423.99	424.06	423.62	424.05	39615.0
2024-01-26 06:30:00	QQQ	ETF	424.08	424.39	423.91	424.36	36971.0
2024-01-26 07:00:00	QQQ	ETF	424.32	425.06	424.27	424.95	134629.0
2024-01-26 07:30:00	QQQ	ETF	424.93	425.24	424.6	424.64	179716.0
2024-01-26 08:00:00	QQQ	ETF	424.252	426.669	422.28	424.7	210081.0
2024-01-26 08:30:00	QQQ	ETF	424.7	425.71	424.0	425.4	499851.0
2024-01-26 09:00:00	QQQ	ETF	425.37	425.39	423.85	424.43	411697.0
2024-01-26 09:30:00	QQQ	ETF	424.42	424.76	423.48	424.25	3455608.0
2024-01-26 10:00:00	QQQ	ETF	424.25	425.036	423.18	424.99	2794287.0
2024-01-26 10:30:00	QQQ	ETF	425.01	426.11	424.95	426.11	2635921.0
2024-01-26 11:00:00	QQQ	ETF	426.1	426.17	425.32	425.71	1925862.0
2024-01-26 11:30:00	QQQ	ETF	425.7	426.025	424.92	425.695	1708154.0
2024-01-26 12:00:00	QQQ	ETF	425.7	426.21	425.3	425.41	1461761.0
2024-01-26 12:30:00	QQQ	ETF	425.4	425.4	423.4399	423.74	2638798.0

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

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