PREVIEW / etf_1hour / 2024-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-08-05.parquet
  size:    612 KB
  rows:    24,355

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-08-05 04:00:00	SPY	ETF	523.78	523.99	519.65	519.94	441361.0
2024-08-05 05:00:00	SPY	ETF	519.99	521.0	517.49	520.01	247117.0
2024-08-05 06:00:00	SPY	ETF	519.94	520.03	516.13	518.25	600459.0
2024-08-05 07:00:00	SPY	ETF	518.36	519.0	514.24	515.28	1550109.0
2024-08-05 08:00:00	SPY	ETF	518.53	524.5	507.83	510.92	4640499.0
2024-08-05 09:00:00	SPY	ETF	510.83	518.04	510.27	515.22	20583784.0
2024-08-05 10:00:00	SPY	ETF	515.25	520.93	514.61	516.43	15162543.0
2024-08-05 11:00:00	SPY	ETF	516.41	521.95	515.35	520.4201	10098916.0
2024-08-05 12:00:00	SPY	ETF	520.41	523.58	518.44	518.91	7578022.0
2024-08-05 13:00:00	SPY	ETF	518.9	520.88	518.25	519.06	6569965.0
2024-08-05 14:00:00	SPY	ETF	519.04	519.4	515.61	515.72	7757198.0
2024-08-05 15:00:00	SPY	ETF	515.73	517.75	514.88	517.41	23367357.0
2024-08-05 16:00:00	SPY	ETF	517.41	520.57	516.92	520.37	10906493.0
2024-08-05 17:00:00	SPY	ETF	520.43	520.57	519.9643	520.39	273664.0
2024-08-05 18:00:00	SPY	ETF	520.54	522.8	520.54	521.62	187975.0
2024-08-05 19:00:00	SPY	ETF	521.86	522.92	521.2935	522.81	304621.0
2024-08-05 20:00:00	SPY	ETF	522.92	522.92	522.92	522.92	100.0
2024-08-05 04:00:00	QQQ	ETF	434.88	435.53	430.42	431.18	378251.0
2024-08-05 05:00:00	QQQ	ETF	431.16	432.62	427.54	430.88	343160.0
2024-08-05 06:00:00	QQQ	ETF	430.77	430.84	426.59	429.99	349378.0
2024-08-05 07:00:00	QQQ	ETF	429.94	430.9	425.5	426.79	1004493.0
2024-08-05 08:00:00	QQQ	ETF	430.46	436.17	420.0	423.8	2828697.0
2024-08-05 09:00:00	QQQ	ETF	423.96	434.2	423.45	432.53	13278273.0
2024-08-05 10:00:00	QQQ	ETF	432.54	438.07	431.73	433.99	11279120.0
2024-08-05 11:00:00	QQQ	ETF	433.96	439.91	432.68	437.91	8028442.0
2024-08-05 12:00:00	QQQ	ETF	437.855	442.29	435.81	436.35	5856200.0
2024-08-05 13:00:00	QQQ	ETF	436.3	439.35	435.88	437.215	3968822.0
2024-08-05 14:00:00	QQQ	ETF	437.18	437.4413	432.73	433.05	5446055.0
2024-08-05 15:00:00	QQQ	ETF	433.07	436.04	433.06	435.75	12100534.0
2024-08-05 16:00:00	QQQ	ETF	435.75	439.29	435.24	438.7	3276489.0
2024-08-05 17:00:00	QQQ	ETF	438.6309	439.25	438.21	439.25	145931.0
2024-08-05 18:00:00	QQQ	ETF	439.3	441.5	439.3	440.15	369558.0
2024-08-05 19:00:00	QQQ	ETF	440.48	442.11	440.03	442.11	145039.0
2024-08-05 04:00:00	IWM	ETF	200.0	204.0	200.0	200.75	261322.0
2024-08-05 05:00:00	IWM	ETF	200.9	201.09	199.73	200.88	94955.0
2024-08-05 06:00:00	IWM	ETF	200.82	201.0	197.18	199.5	247967.0
2024-08-05 07:00:00	IWM	ETF	199.55	200.75	199.11	199.84	772633.0
2024-08-05 08:00:00	IWM	ETF	200.52	203.94	196.78	198.71	1577622.0
2024-08-05 09:00:00	IWM	ETF	198.61	200.4	196.7	198.45	11657168.0
2024-08-05 10:00:00	IWM	ETF	198.47	202.27	198.46	200.08	9693703.0
2024-08-05 11:00:00	IWM	ETF	200.04	203.34	199.68	202.9	5725600.0
2024-08-05 12:00:00	IWM	ETF	202.88	204.74	202.04	202.47	4820087.0
2024-08-05 13:00:00	IWM	ETF	202.44	203.38	201.9	202.47	2665556.0
2024-08-05 14:00:00	IWM	ETF	202.45	202.65	201.12	201.14	3508339.0
2024-08-05 15:00:00	IWM	ETF	201.21	202.36	200.94	202.31	7993756.0
2024-08-05 16:00:00	IWM	ETF	202.31	203.67	202.09	203.37	2722219.0
2024-08-05 17:00:00	IWM	ETF	203.42	203.56	203.25	203.5	37263.0
2024-08-05 18:00:00	IWM	ETF	203.5	204.82	203.5	204.57	114022.0
2024-08-05 19:00:00	IWM	ETF	204.69	205.28	204.47	205.05	90570.0
2024-08-05 04:00:00	DIA	ETF	391.13	392.16	390.78	390.98	42700.0

> showing 50 of 24,355 rows — these rows as CSV

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