PREVIEW / etf_1hour / 2024-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-10-09.parquet
  size:    568 KB
  rows:    20,972

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-10-09 04:00:00	SPY	ETF	571.8	572.14	571.52	572.02	19422.0
2024-10-09 05:00:00	SPY	ETF	572.14	572.71	572.13	572.66	14063.0
2024-10-09 06:00:00	SPY	ETF	572.59	573.2	572.46	572.93	18936.0
2024-10-09 07:00:00	SPY	ETF	573.0	573.15	572.7	572.7	96612.0
2024-10-09 08:00:00	SPY	ETF	573.02	573.12	571.56	572.94	230082.0
2024-10-09 09:00:00	SPY	ETF	572.94	573.79	572.55	573.532	2649173.0
2024-10-09 10:00:00	SPY	ETF	573.53	574.98	573.449	574.896	3144647.0
2024-10-09 11:00:00	SPY	ETF	574.9	577.06	574.9	576.89	4286679.0
2024-10-09 12:00:00	SPY	ETF	576.9	576.91	575.56	575.9	2436369.0
2024-10-09 13:00:00	SPY	ETF	575.89	576.85	575.0	575.736	2324929.0
2024-10-09 14:00:00	SPY	ETF	575.77	576.55	575.46	576.22	2236343.0
2024-10-09 15:00:00	SPY	ETF	576.22	577.71	575.72	577.1	8184195.0
2024-10-09 16:00:00	SPY	ETF	577.09	577.18	576.26	576.77	2250235.0
2024-10-09 17:00:00	SPY	ETF	576.83	577.14	576.64	576.7	87332.0
2024-10-09 18:00:00	SPY	ETF	576.75	576.95	576.51	576.88	39773.0
2024-10-09 19:00:00	SPY	ETF	576.88	577.1281	576.84	577.0	34183.0
2024-10-09 04:00:00	QQQ	ETF	487.99	488.14	487.26	488.0	77936.0
2024-10-09 05:00:00	QQQ	ETF	488.17	488.63	488.12	488.55	25088.0
2024-10-09 06:00:00	QQQ	ETF	488.48	489.18	488.47	488.9	33521.0
2024-10-09 07:00:00	QQQ	ETF	488.94	489.18	488.35	488.35	73816.0
2024-10-09 08:00:00	QQQ	ETF	489.15	489.198	487.0	488.72	157214.0
2024-10-09 09:00:00	QQQ	ETF	488.72	489.39	487.95	488.595	2046368.0
2024-10-09 10:00:00	QQQ	ETF	488.59	490.92	488.51	490.888	2869072.0
2024-10-09 11:00:00	QQQ	ETF	490.91	492.9	490.91	492.8589	2739744.0
2024-10-09 12:00:00	QQQ	ETF	492.84	492.865	491.02	491.6599	2323061.0
2024-10-09 13:00:00	QQQ	ETF	491.66	492.45	490.73	491.73	1428270.0
2024-10-09 14:00:00	QQQ	ETF	491.73	493.22	491.54	492.57	1533426.0
2024-10-09 15:00:00	QQQ	ETF	492.56	493.73	491.91	493.17	3289088.0
2024-10-09 16:00:00	QQQ	ETF	493.16	493.19	492.2	492.88	1122308.0
2024-10-09 17:00:00	QQQ	ETF	492.94	492.94	492.7	492.77	24907.0
2024-10-09 18:00:00	QQQ	ETF	492.8	492.96	492.61	492.95	29245.0
2024-10-09 19:00:00	QQQ	ETF	492.95	493.2	492.73	492.95	59028.0
2024-10-09 04:00:00	IWM	ETF	216.88	216.93	216.55	216.93	15943.0
2024-10-09 05:00:00	IWM	ETF	216.98	217.35	216.91	217.35	8391.0
2024-10-09 06:00:00	IWM	ETF	217.29	217.54	217.26	217.53	10604.0
2024-10-09 07:00:00	IWM	ETF	217.52	217.67	217.3	217.61	23369.0
2024-10-09 08:00:00	IWM	ETF	217.61	217.86	216.42	217.5	131351.0
2024-10-09 09:00:00	IWM	ETF	217.46	218.4299	216.92	218.38	1761397.0
2024-10-09 10:00:00	IWM	ETF	218.38	218.81	217.53	218.38	1919293.0
2024-10-09 11:00:00	IWM	ETF	218.39	219.61	218.2	219.295	1748309.0
2024-10-09 12:00:00	IWM	ETF	219.31	219.35	218.36	218.62	1061816.0
2024-10-09 13:00:00	IWM	ETF	218.61	218.885	218.08	218.42	802475.0
2024-10-09 14:00:00	IWM	ETF	218.42	218.73	217.83	217.83	1520564.0
2024-10-09 15:00:00	IWM	ETF	217.84	218.23	217.67	218.1	2717863.0
2024-10-09 16:00:00	IWM	ETF	218.06	218.2444	217.56	217.68	866114.0
2024-10-09 17:00:00	IWM	ETF	217.68	217.82	217.64	217.64	20003.0
2024-10-09 18:00:00	IWM	ETF	217.7	217.8	217.67	217.79	26453.0
2024-10-09 19:00:00	IWM	ETF	217.82	217.94	217.78	217.9	6534.0
2024-10-09 04:00:00	DIA	ETF	419.86	419.86	419.86	419.86	100.0
2024-10-09 06:00:00	DIA	ETF	420.6	420.6	420.6	420.6	100.0

> showing 50 of 20,972 rows — these rows as CSV

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