PREVIEW / etf_30min / 2024-04-03

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-03.parquet
  size:    811 KB
  rows:    32,705

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-04-03 04:00:00	SPY	ETF	517.82	518.1	517.74	518.08	6245.0
2024-04-03 04:30:00	SPY	ETF	518.18	518.46	518.01	518.24	5320.0
2024-04-03 05:00:00	SPY	ETF	518.18	518.4	518.06	518.06	4154.0
2024-04-03 05:30:00	SPY	ETF	518.06	518.29	517.82	517.83	4784.0
2024-04-03 06:00:00	SPY	ETF	517.85	518.06	517.79	517.9	9874.0
2024-04-03 06:30:00	SPY	ETF	517.88	517.95	517.67	517.95	12170.0
2024-04-03 07:00:00	SPY	ETF	517.92	518.5	517.92	518.49	51626.0
2024-04-03 07:30:00	SPY	ETF	518.5	518.75	518.2	518.7	70055.0
2024-04-03 08:00:00	SPY	ETF	518.15	519.01	517.69	517.84	185820.0
2024-04-03 08:30:00	SPY	ETF	517.8	518.24	517.57	517.98	123478.0
2024-04-03 09:00:00	SPY	ETF	517.9494	518.22	517.39	517.69	225324.0
2024-04-03 09:30:00	SPY	ETF	517.72	518.64	517.665	518.39	3596177.0
2024-04-03 10:00:00	SPY	ETF	518.45	520.63	518.42	520.4	5473756.0
2024-04-03 10:30:00	SPY	ETF	520.41	520.84	520.1701	520.68	2441280.0
2024-04-03 11:00:00	SPY	ETF	520.67	520.95	520.6	520.81	1696697.0
2024-04-03 11:30:00	SPY	ETF	520.83	520.93	520.1	520.1901	1947529.0
2024-04-03 12:00:00	SPY	ETF	520.18	520.65	519.72	520.645	3229880.0
2024-04-03 12:30:00	SPY	ETF	520.64	520.845	519.39	520.31	2851174.0
2024-04-03 13:00:00	SPY	ETF	520.32	520.68	520.3	520.62	1480050.0
2024-04-03 13:30:00	SPY	ETF	520.63	520.8	520.39	520.55	1195797.0
2024-04-03 14:00:00	SPY	ETF	520.56	520.8	520.15	520.205	1715705.0
2024-04-03 14:30:00	SPY	ETF	520.19	520.425	519.8496	519.96	1981939.0
2024-04-03 15:00:00	SPY	ETF	519.95	520.03	517.77	518.53	4331776.0
2024-04-03 15:30:00	SPY	ETF	518.55	519.77	518.28	519.36	9484114.0
2024-04-03 16:00:00	SPY	ETF	519.37	519.9	519.2555	519.86	2566511.0
2024-04-03 16:30:00	SPY	ETF	519.89	519.99	519.78	519.78	86027.0
2024-04-03 17:00:00	SPY	ETF	519.78	519.85	519.74	519.81	20709.0
2024-04-03 17:30:00	SPY	ETF	519.83	519.93	519.41	519.93	216282.0
2024-04-03 18:00:00	SPY	ETF	519.93	519.93	519.6	519.66	45302.0
2024-04-03 18:30:00	SPY	ETF	519.649	519.71	519.6408	519.7	22204.0
2024-04-03 19:00:00	SPY	ETF	519.75	520.2	519.71	520.2	15388.0
2024-04-03 19:30:00	SPY	ETF	520.2	521.24	520.2	520.7	64120.0
2024-04-03 04:00:00	QQQ	ETF	435.05	440.7	435.05	440.04	13766.0
2024-04-03 04:30:00	QQQ	ETF	440.1	440.53	440.05	440.41	5127.0
2024-04-03 05:00:00	QQQ	ETF	440.15	440.24	439.8	439.8	4935.0
2024-04-03 05:30:00	QQQ	ETF	439.89	439.89	439.58	439.58	3596.0
2024-04-03 06:00:00	QQQ	ETF	439.71	439.89	439.6	439.71	9663.0
2024-04-03 06:30:00	QQQ	ETF	439.51	439.69	439.3	439.63	6715.0
2024-04-03 07:00:00	QQQ	ETF	439.69	440.374	439.69	440.33	43983.0
2024-04-03 07:30:00	QQQ	ETF	440.5	440.65	440.03	440.55	66778.0
2024-04-03 08:00:00	QQQ	ETF	439.99	440.88	439.51	439.6	166515.0
2024-04-03 08:30:00	QQQ	ETF	439.511	439.929	439.23	439.63	117621.0
2024-04-03 09:00:00	QQQ	ETF	439.6	439.98	438.78	438.96	219034.0
2024-04-03 09:30:00	QQQ	ETF	438.96	440.025	438.95	439.7	2785359.0
2024-04-03 10:00:00	QQQ	ETF	439.75	443.23	439.72	443.0001	3670864.0
2024-04-03 10:30:00	QQQ	ETF	443.01	443.585	442.84	443.48	2288640.0
2024-04-03 11:00:00	QQQ	ETF	443.49	443.96	443.41	443.78	1806831.0
2024-04-03 11:30:00	QQQ	ETF	443.79	444.0	442.75	442.87	1736274.0
2024-04-03 12:00:00	QQQ	ETF	442.88	443.43	442.24	443.415	2417139.0
2024-04-03 12:30:00	QQQ	ETF	443.41	443.71	442.09	443.06	2177736.0

> showing 50 of 32,705 rows — these rows as CSV

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