PREVIEW / etf_1hour / 2024-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-06-04.parquet
  size:    528 KB
  rows:    20,203

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-06-04 04:00:00	SPY	ETF	526.81	526.81	524.97	525.24	61076.0
2024-06-04 05:00:00	SPY	ETF	525.06	525.1	524.31	524.72	22330.0
2024-06-04 06:00:00	SPY	ETF	524.76	525.1	524.27	524.95	61139.0
2024-06-04 07:00:00	SPY	ETF	525.03	526.0	525.0	525.96	221041.0
2024-06-04 08:00:00	SPY	ETF	525.22	527.96	524.335	526.1	325020.0
2024-06-04 09:00:00	SPY	ETF	526.18	526.79	525.77	526.49	2644986.0
2024-06-04 10:00:00	SPY	ETF	526.49	527.75	525.74	525.93	4703617.0
2024-06-04 11:00:00	SPY	ETF	525.97	526.615	525.14	525.2501	2801717.0
2024-06-04 12:00:00	SPY	ETF	525.265	526.94	524.96	526.4799	2581212.0
2024-06-04 13:00:00	SPY	ETF	526.4713	527.11	525.695	526.84	1857919.0
2024-06-04 14:00:00	SPY	ETF	526.81	529.15	526.71	528.3999	3818688.0
2024-06-04 15:00:00	SPY	ETF	528.37	528.6	526.61	528.35	6911084.0
2024-06-04 16:00:00	SPY	ETF	528.35	528.61	528.02	528.45	1968204.0
2024-06-04 17:00:00	SPY	ETF	528.41	528.47	528.3	528.36	53772.0
2024-06-04 18:00:00	SPY	ETF	528.39	528.78	528.26	528.751	54713.0
2024-06-04 19:00:00	SPY	ETF	528.77	529.17	528.77	529.1	41949.0
2024-06-04 04:00:00	QQQ	ETF	452.27	452.33	450.59	450.91	74415.0
2024-06-04 05:00:00	QQQ	ETF	450.91	451.01	449.9	450.53	47832.0
2024-06-04 06:00:00	QQQ	ETF	450.7	451.15	450.25	450.85	98293.0
2024-06-04 07:00:00	QQQ	ETF	450.83	451.89	450.83	451.78	64533.0
2024-06-04 08:00:00	QQQ	ETF	451.02	453.41	450.55	452.14	206790.0
2024-06-04 09:00:00	QQQ	ETF	452.13	453.15	451.44	451.98	2530407.0
2024-06-04 10:00:00	QQQ	ETF	452.0	453.46	451.1311	451.93	3091149.0
2024-06-04 11:00:00	QQQ	ETF	451.95	452.84	451.3	451.56	1866121.0
2024-06-04 12:00:00	QQQ	ETF	451.54	453.15	451.2	452.59	1762561.0
2024-06-04 13:00:00	QQQ	ETF	452.57	452.995	451.78	452.585	1149205.0
2024-06-04 14:00:00	QQQ	ETF	452.58	455.575	452.49	454.6	2815230.0
2024-06-04 15:00:00	QQQ	ETF	454.57	454.64	452.68	454.35	3989490.0
2024-06-04 16:00:00	QQQ	ETF	454.34	454.64	453.97	454.5099	669140.0
2024-06-04 17:00:00	QQQ	ETF	454.43	454.6	454.0	454.45	63341.0
2024-06-04 18:00:00	QQQ	ETF	454.44	454.8	454.26	454.78	65368.0
2024-06-04 19:00:00	QQQ	ETF	454.79	455.26	454.79	455.2	34392.0
2024-06-04 04:00:00	IWM	ETF	204.77	204.77	202.86	202.96	35908.0
2024-06-04 05:00:00	IWM	ETF	202.8	202.92	202.3	202.62	44179.0
2024-06-04 06:00:00	IWM	ETF	202.5	202.7	202.19	202.57	102732.0
2024-06-04 07:00:00	IWM	ETF	202.72	203.31	202.68	203.31	41939.0
2024-06-04 08:00:00	IWM	ETF	202.76	204.25	202.63	202.93	371162.0
2024-06-04 09:00:00	IWM	ETF	202.94	203.64	202.66	202.78	2244867.0
2024-06-04 10:00:00	IWM	ETF	202.81	203.49	202.22	202.28	3637392.0
2024-06-04 11:00:00	IWM	ETF	202.28	202.75	201.76	201.93	2438829.0
2024-06-04 12:00:00	IWM	ETF	201.93	202.31	201.73	202.0716	1396503.0
2024-06-04 13:00:00	IWM	ETF	202.07	202.16	201.71	202.125	1352640.0
2024-06-04 14:00:00	IWM	ETF	202.12	202.84	202.04	202.325	2369758.0
2024-06-04 15:00:00	IWM	ETF	202.305	202.31	201.65	201.92	3977940.0
2024-06-04 16:00:00	IWM	ETF	201.92	202.18	201.84	202.07	1310637.0
2024-06-04 17:00:00	IWM	ETF	202.04	202.07	201.82	201.98	162866.0
2024-06-04 18:00:00	IWM	ETF	202.03	202.29	201.97	202.29	22746.0
2024-06-04 19:00:00	IWM	ETF	202.24	202.52	202.24	202.47	7170.0
2024-06-04 04:00:00	DIA	ETF	385.26	385.26	384.8	384.8	800.0
2024-06-04 05:00:00	DIA	ETF	384.18	384.35	384.03	384.22	927.0

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

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