PREVIEW / etf_1hour / 2024-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-05-09.parquet
  size:    525 KB
  rows:    19,390

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-05-09 04:00:00	SPY	ETF	516.49	516.63	516.32	516.34	20318.0
2024-05-09 05:00:00	SPY	ETF	516.32	516.32	515.85	516.19	3968.0
2024-05-09 06:00:00	SPY	ETF	516.3	516.79	516.3	516.44	25859.0
2024-05-09 07:00:00	SPY	ETF	516.46	517.0	516.3	516.85	108026.0
2024-05-09 08:00:00	SPY	ETF	516.46	517.73	516.0496	517.41	379042.0
2024-05-09 09:00:00	SPY	ETF	517.34	517.85	516.705	517.5818	3628986.0
2024-05-09 10:00:00	SPY	ETF	517.58	519.28	517.505	519.165	6121057.0
2024-05-09 11:00:00	SPY	ETF	519.16	519.51	518.34	518.5	4049523.0
2024-05-09 12:00:00	SPY	ETF	518.49	519.37	518.37	519.2199	2527411.0
2024-05-09 13:00:00	SPY	ETF	519.21	519.64	518.79	519.2	3072770.0
2024-05-09 14:00:00	SPY	ETF	519.19	520.06	518.93	519.9	2785760.0
2024-05-09 15:00:00	SPY	ETF	519.9	520.2074	519.57	520.13	10066360.0
2024-05-09 16:00:00	SPY	ETF	520.13	520.66	519.8	520.25	3861408.0
2024-05-09 17:00:00	SPY	ETF	520.35	520.38	520.2622	520.34	32360.0
2024-05-09 18:00:00	SPY	ETF	520.25	520.66	520.17	520.57	30901.0
2024-05-09 19:00:00	SPY	ETF	520.59	520.78	520.56	520.56	27872.0
2024-05-09 04:00:00	QQQ	ETF	438.91	439.25	438.79	438.85	16976.0
2024-05-09 05:00:00	QQQ	ETF	438.94	438.94	438.4	438.91	4536.0
2024-05-09 06:00:00	QQQ	ETF	439.01	439.55	439.01	439.09	24807.0
2024-05-09 07:00:00	QQQ	ETF	439.15	439.81	438.92	439.65	44488.0
2024-05-09 08:00:00	QQQ	ETF	439.02	440.65	438.71	440.5	228872.0
2024-05-09 09:00:00	QQQ	ETF	440.37	440.9	438.46	439.64	3202515.0
2024-05-09 10:00:00	QQQ	ETF	439.67	441.19	438.98	440.945	3879588.0
2024-05-09 11:00:00	QQQ	ETF	440.93	441.555	439.97	440.16	2188913.0
2024-05-09 12:00:00	QQQ	ETF	440.17	441.17	439.96	441.01	1571921.0
2024-05-09 13:00:00	QQQ	ETF	441.0184	441.45	440.39	440.835	2337653.0
2024-05-09 14:00:00	QQQ	ETF	440.83	441.6	440.4405	441.43	1575556.0
2024-05-09 15:00:00	QQQ	ETF	441.43	441.4999	440.575	441.03	3829071.0
2024-05-09 16:00:00	QQQ	ETF	441.03	441.61	440.87	441.15	602624.0
2024-05-09 17:00:00	QQQ	ETF	441.15	441.15	441.08	441.12	35495.0
2024-05-09 18:00:00	QQQ	ETF	441.15	441.549	441.15	441.479	31750.0
2024-05-09 19:00:00	QQQ	ETF	441.45	441.67	441.39	441.45	41878.0
2024-05-09 04:00:00	IWM	ETF	203.13	203.22	202.97	203.0	8338.0
2024-05-09 05:00:00	IWM	ETF	203.03	203.14	202.9	202.97	30389.0
2024-05-09 06:00:00	IWM	ETF	203.1	203.32	203.0	203.0	4809.0
2024-05-09 07:00:00	IWM	ETF	203.04	203.63	202.99	203.53	40078.0
2024-05-09 08:00:00	IWM	ETF	203.1	204.67	203.01	204.41	215721.0
2024-05-09 09:00:00	IWM	ETF	204.35	204.47	203.41	203.98	2125073.0
2024-05-09 10:00:00	IWM	ETF	203.98	205.11	203.94	205.05	2175510.0
2024-05-09 11:00:00	IWM	ETF	205.06	205.27	204.8	204.83	1875729.0
2024-05-09 12:00:00	IWM	ETF	204.835	205.19	204.795	204.85	936168.0
2024-05-09 13:00:00	IWM	ETF	204.85	205.19	204.69	204.94	1377460.0
2024-05-09 14:00:00	IWM	ETF	204.92	205.425	204.85	205.365	1473861.0
2024-05-09 15:00:00	IWM	ETF	205.365	205.99	205.34	205.8	4957697.0
2024-05-09 16:00:00	IWM	ETF	205.86	206.06	205.78	205.81	1808101.0
2024-05-09 17:00:00	IWM	ETF	205.8	205.96	205.8	205.83	18123.0
2024-05-09 18:00:00	IWM	ETF	205.83	206.04	205.83	206.04	10340.0
2024-05-09 19:00:00	IWM	ETF	205.95	206.07	205.95	205.96	13529.0
2024-05-09 04:00:00	DIA	ETF	390.18	390.22	390.01	390.01	400.0
2024-05-09 07:00:00	DIA	ETF	390.0	390.08	390.0	390.08	500.0

> showing 50 of 19,390 rows — these rows as CSV

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