PREVIEW / etf_1hour / 2024-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-05-07.parquet
  size:    530 KB
  rows:    19,587

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-07 04:00:00	SPY	ETF	516.35	517.16	516.2	517.16	14424.0
2024-05-07 05:00:00	SPY	ETF	517.18	517.23	516.75	516.8	6018.0
2024-05-07 06:00:00	SPY	ETF	516.84	516.98	516.73	516.95	10568.0
2024-05-07 07:00:00	SPY	ETF	516.97	517.0	516.44	516.65	71946.0
2024-05-07 08:00:00	SPY	ETF	516.88	517.24	516.4	517.24	183497.0
2024-05-07 09:00:00	SPY	ETF	517.2	517.93	517.165	517.18	4139984.0
2024-05-07 10:00:00	SPY	ETF	517.21	518.24	516.945	518.125	4538555.0
2024-05-07 11:00:00	SPY	ETF	518.13	518.28	517.69	518.08	3698185.0
2024-05-07 12:00:00	SPY	ETF	518.0888	518.295	517.5702	517.89	2667159.0
2024-05-07 13:00:00	SPY	ETF	517.895	518.57	516.79	516.99	4558329.0
2024-05-07 14:00:00	SPY	ETF	517.0	517.44	516.45	517.015	4949674.0
2024-05-07 15:00:00	SPY	ETF	517.02	517.86	516.68	517.2	11598854.0
2024-05-07 16:00:00	SPY	ETF	517.2	517.5	517.03	517.09	3339919.0
2024-05-07 17:00:00	SPY	ETF	517.14	517.28	517.07	517.14	15293.0
2024-05-07 18:00:00	SPY	ETF	517.08	517.35	516.78	517.35	170738.0
2024-05-07 19:00:00	SPY	ETF	517.34	517.4499	517.22	517.32	49654.0
2024-05-07 04:00:00	QQQ	ETF	439.6	440.3	439.33	440.3	47420.0
2024-05-07 05:00:00	QQQ	ETF	440.28	440.39	439.59	439.83	24191.0
2024-05-07 06:00:00	QQQ	ETF	439.8	439.9	439.61	439.9	12676.0
2024-05-07 07:00:00	QQQ	ETF	439.96	440.02	439.26	439.55	152687.0
2024-05-07 08:00:00	QQQ	ETF	439.9	440.58	439.28	440.21	121214.0
2024-05-07 09:00:00	QQQ	ETF	440.23	441.2914	440.14	440.25	3471899.0
2024-05-07 10:00:00	QQQ	ETF	440.28	441.65	439.98	441.6294	3450096.0
2024-05-07 11:00:00	QQQ	ETF	441.625	441.92	441.24	441.665	2528074.0
2024-05-07 12:00:00	QQQ	ETF	441.7	441.94	441.1	441.35	2156399.0
2024-05-07 13:00:00	QQQ	ETF	441.37	441.97	440.0	440.23	2262835.0
2024-05-07 14:00:00	QQQ	ETF	440.25	440.74	439.58	440.26	2872232.0
2024-05-07 15:00:00	QQQ	ETF	440.265	440.89	439.95	440.29	3864967.0
2024-05-07 16:00:00	QQQ	ETF	440.3	440.76	440.25	440.32	883852.0
2024-05-07 17:00:00	QQQ	ETF	440.3	440.3	440.06	440.16	28393.0
2024-05-07 18:00:00	QQQ	ETF	440.22	440.45	439.98	440.44	50277.0
2024-05-07 19:00:00	QQQ	ETF	440.5	440.58	440.35	440.47	29328.0
2024-05-07 04:00:00	IWM	ETF	204.49	205.0	204.29	205.0	9809.0
2024-05-07 05:00:00	IWM	ETF	204.95	205.14	204.8	204.85	9763.0
2024-05-07 06:00:00	IWM	ETF	204.88	205.01	204.8	204.82	14177.0
2024-05-07 07:00:00	IWM	ETF	204.82	204.97	204.67	204.88	26827.0
2024-05-07 08:00:00	IWM	ETF	204.86	204.98	204.46	204.95	39979.0
2024-05-07 09:00:00	IWM	ETF	204.97	205.32	204.5	204.96	2186926.0
2024-05-07 10:00:00	IWM	ETF	204.96	205.81	204.645	205.765	2202090.0
2024-05-07 11:00:00	IWM	ETF	205.76	206.04	205.7051	205.969	1970282.0
2024-05-07 12:00:00	IWM	ETF	205.97	206.15	205.72	205.805	1259540.0
2024-05-07 13:00:00	IWM	ETF	205.81	205.93	205.28	205.325	1215861.0
2024-05-07 14:00:00	IWM	ETF	205.32	205.485	205.035	205.175	1735913.0
2024-05-07 15:00:00	IWM	ETF	205.18	205.36	204.87	204.91	3101593.0
2024-05-07 16:00:00	IWM	ETF	204.97	204.97	204.48	204.53	1153049.0
2024-05-07 17:00:00	IWM	ETF	204.54	204.97	204.5	204.97	11641.0
2024-05-07 18:00:00	IWM	ETF	204.51	204.67	204.38	204.62	27719.0
2024-05-07 19:00:00	IWM	ETF	204.64	204.66	204.52	204.55	10593.0
2024-05-07 04:00:00	DIA	ETF	388.5	389.03	388.45	388.97	2758.0
2024-05-07 06:00:00	DIA	ETF	389.31	389.31	388.97	388.99	2229.0

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

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