PREVIEW / etf_1hour / 2024-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-06-05.parquet
  size:    538 KB
  rows:    20,135

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-05 04:00:00	SPY	ETF	528.91	529.19	528.75	529.15	15073.0
2024-06-05 05:00:00	SPY	ETF	529.2	529.56	529.17	529.51	30008.0
2024-06-05 06:00:00	SPY	ETF	529.49	529.73	529.41	529.45	21191.0
2024-06-05 07:00:00	SPY	ETF	529.5	530.13	528.92	530.05	212565.0
2024-06-05 08:00:00	SPY	ETF	529.44	530.49	528.72	530.49	270308.0
2024-06-05 09:00:00	SPY	ETF	530.5	530.85	529.51	530.08	3747530.0
2024-06-05 10:00:00	SPY	ETF	530.09	531.1198	528.7254	530.96	5308922.0
2024-06-05 11:00:00	SPY	ETF	530.95	532.44	530.95	532.03	4081842.0
2024-06-05 12:00:00	SPY	ETF	532.025	532.81	531.73	532.645	2371216.0
2024-06-05 13:00:00	SPY	ETF	532.65	533.3	532.15	533.26	2683937.0
2024-06-05 14:00:00	SPY	ETF	533.25	534.0	533.015	533.85	3447486.0
2024-06-05 15:00:00	SPY	ETF	533.86	534.69	533.24	534.65	8435967.0
2024-06-05 16:00:00	SPY	ETF	534.64	534.79	533.6	534.56	3319440.0
2024-06-05 17:00:00	SPY	ETF	534.6787	534.6787	534.32	534.62	88221.0
2024-06-05 18:00:00	SPY	ETF	534.53	535.0	534.3597	534.95	72599.0
2024-06-05 19:00:00	SPY	ETF	535.0	535.19	534.9	534.98	43760.0
2024-06-05 04:00:00	QQQ	ETF	455.17	455.85	455.1	455.72	24495.0
2024-06-05 05:00:00	QQQ	ETF	455.78	456.51	455.73	456.47	58304.0
2024-06-05 06:00:00	QQQ	ETF	456.5	456.72	456.24	456.24	88649.0
2024-06-05 07:00:00	QQQ	ETF	456.31	457.18	456.0	456.99	123198.0
2024-06-05 08:00:00	QQQ	ETF	456.3103	457.48	454.6	457.43	280581.0
2024-06-05 09:00:00	QQQ	ETF	457.43	458.25	457.14	458.21	2789033.0
2024-06-05 10:00:00	QQQ	ETF	458.21	460.11	456.77	459.75	4215694.0
2024-06-05 11:00:00	QQQ	ETF	459.75	461.3	459.74	460.76	3335138.0
2024-06-05 12:00:00	QQQ	ETF	460.76	461.8	460.53	461.7	1537588.0
2024-06-05 13:00:00	QQQ	ETF	461.72	462.2968	461.09	462.225	2440132.0
2024-06-05 14:00:00	QQQ	ETF	462.215	462.72	461.785	462.5625	2348301.0
2024-06-05 15:00:00	QQQ	ETF	462.55	463.61	462.16	463.59	6735812.0
2024-06-05 16:00:00	QQQ	ETF	463.59	463.85	462.3132	463.76	1996234.0
2024-06-05 17:00:00	QQQ	ETF	463.75	463.7673	463.48	463.65	76690.0
2024-06-05 18:00:00	QQQ	ETF	463.65	464.0	463.497	463.92	112967.0
2024-06-05 19:00:00	QQQ	ETF	463.94	464.23	463.84	463.89	33894.0
2024-06-05 04:00:00	IWM	ETF	202.2	202.29	201.95	202.24	44068.0
2024-06-05 05:00:00	IWM	ETF	202.3	202.3	202.15	202.18	4320.0
2024-06-05 06:00:00	IWM	ETF	202.17	202.46	202.17	202.23	11293.0
2024-06-05 07:00:00	IWM	ETF	202.32	202.72	202.23	202.54	32292.0
2024-06-05 08:00:00	IWM	ETF	202.31	203.16	202.2	203.16	197547.0
2024-06-05 09:00:00	IWM	ETF	203.13	203.51	202.22	202.61	1975213.0
2024-06-05 10:00:00	IWM	ETF	202.49	203.99	201.79	203.28	3970424.0
2024-06-05 11:00:00	IWM	ETF	203.29	204.465	203.29	204.37	1745718.0
2024-06-05 12:00:00	IWM	ETF	204.38	204.7	204.21	204.38	1283235.0
2024-06-05 13:00:00	IWM	ETF	204.375	204.815	204.265	204.7299	1343119.0
2024-06-05 14:00:00	IWM	ETF	204.72	204.92	204.62	204.84	1088199.0
2024-06-05 15:00:00	IWM	ETF	204.835	205.02	204.45	205.01	4158127.0
2024-06-05 16:00:00	IWM	ETF	205.06	205.1199	204.7	205.06	1153700.0
2024-06-05 17:00:00	IWM	ETF	205.05	205.09	204.9	204.95	35636.0
2024-06-05 18:00:00	IWM	ETF	204.97	205.0185	204.75	204.95	37638.0
2024-06-05 19:00:00	IWM	ETF	205.03	205.03	204.85	204.88	5199.0
2024-06-05 05:00:00	DIA	ETF	387.96	388.0	387.96	388.0	200.0
2024-06-05 06:00:00	DIA	ETF	388.05	388.05	388.05	388.05	500.0

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

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