PREVIEW / etf_1hour / 2024-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-04-09.parquet
  size:    529 KB
  rows:    19,737

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-09 04:00:00	SPY	ETF	518.32	518.73	518.25	518.73	9707.0
2024-04-09 05:00:00	SPY	ETF	518.85	519.23	518.65	519.01	13013.0
2024-04-09 06:00:00	SPY	ETF	519.01	519.2	518.01	518.37	20146.0
2024-04-09 07:00:00	SPY	ETF	518.39	519.46	518.39	519.46	86614.0
2024-04-09 08:00:00	SPY	ETF	519.48	520.15	518.2596	519.96	197696.0
2024-04-09 09:00:00	SPY	ETF	519.96	520.75	518.77	518.88	4646780.0
2024-04-09 10:00:00	SPY	ETF	518.89	519.28	514.35	515.515	11175414.0
2024-04-09 11:00:00	SPY	ETF	515.52	517.125	515.19	516.825	5841792.0
2024-04-09 12:00:00	SPY	ETF	516.825	517.78	516.575	516.79	3638982.0
2024-04-09 13:00:00	SPY	ETF	516.8	517.64	516.6	516.6701	3530969.0
2024-04-09 14:00:00	SPY	ETF	516.67	517.29	516.23	516.51	3622528.0
2024-04-09 15:00:00	SPY	ETF	516.5	519.44	515.71	519.29	12116375.0
2024-04-09 16:00:00	SPY	ETF	519.3	520.45	519.22	519.79	2706894.0
2024-04-09 17:00:00	SPY	ETF	519.82	519.92	519.62	519.75	54013.0
2024-04-09 18:00:00	SPY	ETF	519.72	519.8	519.5302	519.61	38570.0
2024-04-09 19:00:00	SPY	ETF	519.61	519.65	519.53	519.55	51459.0
2024-04-09 04:00:00	QQQ	ETF	440.08	441.03	440.05	440.88	17822.0
2024-04-09 05:00:00	QQQ	ETF	440.8	441.55	440.76	441.29	21790.0
2024-04-09 06:00:00	QQQ	ETF	441.3	441.33	439.68	440.34	31138.0
2024-04-09 07:00:00	QQQ	ETF	440.525	441.81	440.44	441.78	71690.0
2024-04-09 08:00:00	QQQ	ETF	440.4099	442.44	440.0	442.27	189222.0
2024-04-09 09:00:00	QQQ	ETF	442.26	443.24	441.61	441.78	3637356.0
2024-04-09 10:00:00	QQQ	ETF	441.78	442.4402	437.44	438.8	7152739.0
2024-04-09 11:00:00	QQQ	ETF	438.78	440.17	438.49	439.85	4118147.0
2024-04-09 12:00:00	QQQ	ETF	439.83	440.85	439.71	439.89	2831831.0
2024-04-09 13:00:00	QQQ	ETF	439.9	440.6788	439.63	439.7	2479501.0
2024-04-09 14:00:00	QQQ	ETF	439.69	440.38	439.29	439.6	2820842.0
2024-04-09 15:00:00	QQQ	ETF	439.59	442.33	438.7301	442.26	7095425.0
2024-04-09 16:00:00	QQQ	ETF	442.24	443.31	442.2	442.76	1826835.0
2024-04-09 17:00:00	QQQ	ETF	442.81	442.83	442.45	442.66	58269.0
2024-04-09 18:00:00	QQQ	ETF	442.67	442.74	442.47	442.56	58256.0
2024-04-09 19:00:00	QQQ	ETF	442.6	442.62	442.4	442.41	41206.0
2024-04-09 04:00:00	IWM	ETF	205.5	205.5	204.97	205.25	15722.0
2024-04-09 05:00:00	IWM	ETF	205.14	205.91	205.13	205.91	6238.0
2024-04-09 06:00:00	IWM	ETF	205.76	205.93	205.57	205.83	9783.0
2024-04-09 07:00:00	IWM	ETF	205.82	206.22	205.78	206.08	21817.0
2024-04-09 08:00:00	IWM	ETF	205.8013	206.4	204.9996	206.2	57039.0
2024-04-09 09:00:00	IWM	ETF	206.14	206.97	205.625	205.89	2281540.0
2024-04-09 10:00:00	IWM	ETF	205.9	206.465	204.47	204.94	3503829.0
2024-04-09 11:00:00	IWM	ETF	204.93	205.59	204.77	205.34	2705332.0
2024-04-09 12:00:00	IWM	ETF	205.33	205.91	205.24	205.65	1269742.0
2024-04-09 13:00:00	IWM	ETF	205.65	206.02	205.45	205.55	1164938.0
2024-04-09 14:00:00	IWM	ETF	205.55	205.82	205.3	205.645	1551454.0
2024-04-09 15:00:00	IWM	ETF	205.64	206.49	205.01	206.38	4446985.0
2024-04-09 16:00:00	IWM	ETF	206.38	206.84	206.36	206.57	844131.0
2024-04-09 17:00:00	IWM	ETF	206.5709	206.69	206.53	206.55	9083.0
2024-04-09 18:00:00	IWM	ETF	206.62	206.66	206.58	206.65	13352.0
2024-04-09 19:00:00	IWM	ETF	206.65	206.71	206.6	206.65	27126.0
2024-04-09 06:00:00	DIA	ETF	389.14	389.14	388.74	388.74	865.0
2024-04-09 07:00:00	DIA	ETF	388.67	389.12	388.67	388.97	1298.0

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

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