PREVIEW / etf_1hour / 2024-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-06-12.parquet
  size:    553 KB
  rows:    20,593

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-12 04:00:00	SPY	ETF	537.26	537.56	537.23	537.51	7430.0
2024-06-12 05:00:00	SPY	ETF	537.34	537.77	537.34	537.6	4687.0
2024-06-12 06:00:00	SPY	ETF	537.55	537.79	537.51	537.68	13102.0
2024-06-12 07:00:00	SPY	ETF	537.74	537.83	537.51	537.65	81935.0
2024-06-12 08:00:00	SPY	ETF	537.77	542.0	536.95	541.77	1714566.0
2024-06-12 09:00:00	SPY	ETF	541.72	542.96	541.21	542.6887	5744731.0
2024-06-12 10:00:00	SPY	ETF	542.68	543.96	542.54	543.085	5310560.0
2024-06-12 11:00:00	SPY	ETF	543.1	543.4	542.53	543.0	2868813.0
2024-06-12 12:00:00	SPY	ETF	543.0	543.13	542.42	542.81	2129766.0
2024-06-12 13:00:00	SPY	ETF	542.82	543.37	541.9514	542.5651	2605424.0
2024-06-12 14:00:00	SPY	ETF	542.54	543.08	540.73	542.5	7122497.0
2024-06-12 15:00:00	SPY	ETF	542.5	544.12	540.3	541.34	12302322.0
2024-06-12 16:00:00	SPY	ETF	541.34	542.52	541.04	542.45	4062926.0
2024-06-12 17:00:00	SPY	ETF	542.44	542.5081	541.36	542.16	381171.0
2024-06-12 18:00:00	SPY	ETF	542.16	542.3	541.97	542.05	211888.0
2024-06-12 19:00:00	SPY	ETF	542.0304	542.28	541.9	542.23	28869.0
2024-06-12 04:00:00	QQQ	ETF	468.34	468.59	468.19	468.48	19589.0
2024-06-12 05:00:00	QQQ	ETF	468.47	468.81	468.47	468.78	20346.0
2024-06-12 06:00:00	QQQ	ETF	468.64	468.83	468.55	468.83	29704.0
2024-06-12 07:00:00	QQQ	ETF	468.7	468.95	468.61	468.76	84046.0
2024-06-12 08:00:00	QQQ	ETF	468.72	473.5	468.1	472.47	1124969.0
2024-06-12 09:00:00	QQQ	ETF	472.45	474.4599	471.29	474.13	4005655.0
2024-06-12 10:00:00	QQQ	ETF	474.14	475.43	473.85	474.4094	4643558.0
2024-06-12 11:00:00	QQQ	ETF	474.43	475.26	474.29	474.7075	1981433.0
2024-06-12 12:00:00	QQQ	ETF	474.68	474.94	474.18	474.57	1364476.0
2024-06-12 13:00:00	QQQ	ETF	474.57	475.23	474.12	474.775	1576697.0
2024-06-12 14:00:00	QQQ	ETF	474.67	475.34	473.11	474.77	4043405.0
2024-06-12 15:00:00	QQQ	ETF	474.79	476.5	472.72	474.14	5978721.0
2024-06-12 16:00:00	QQQ	ETF	474.15	477.0	473.47	476.89	1913386.0
2024-06-12 17:00:00	QQQ	ETF	476.91	476.99	476.36	476.6	125065.0
2024-06-12 18:00:00	QQQ	ETF	476.64	476.75	476.47	476.51	87181.0
2024-06-12 19:00:00	QQQ	ETF	476.4806	476.8	476.28	476.72	76615.0
2024-06-12 04:00:00	IWM	ETF	200.56	200.69	200.39	200.47	11264.0
2024-06-12 05:00:00	IWM	ETF	200.44	200.87	200.44	200.82	4371.0
2024-06-12 06:00:00	IWM	ETF	200.77	200.85	200.74	200.85	10148.0
2024-06-12 07:00:00	IWM	ETF	200.85	201.45	200.85	201.45	97257.0
2024-06-12 08:00:00	IWM	ETF	200.96	206.87	200.3504	206.61	3277955.0
2024-06-12 09:00:00	IWM	ETF	206.56	206.9	205.46	206.115	5427812.0
2024-06-12 10:00:00	IWM	ETF	206.11	207.27	205.94	206.435	4819531.0
2024-06-12 11:00:00	IWM	ETF	206.44	206.5	205.745	206.09	2156453.0
2024-06-12 12:00:00	IWM	ETF	206.09	206.15	205.7	205.82	1834504.0
2024-06-12 13:00:00	IWM	ETF	205.83	206.14	205.57	206.0162	1867951.0
2024-06-12 14:00:00	IWM	ETF	205.99	206.03	204.12	205.03	7133154.0
2024-06-12 15:00:00	IWM	ETF	205.04	205.48	203.1	203.78	7569960.0
2024-06-12 16:00:00	IWM	ETF	203.79	203.99	203.66	203.84	1122079.0
2024-06-12 17:00:00	IWM	ETF	203.83	203.9	203.55	203.63	242921.0
2024-06-12 18:00:00	IWM	ETF	203.68	203.8	203.5	203.779	61898.0
2024-06-12 19:00:00	IWM	ETF	203.75	203.75	203.56	203.61	50611.0
2024-06-12 04:00:00	DIA	ETF	388.4	388.4	388.4	388.4	149.0
2024-06-12 06:00:00	DIA	ETF	388.31	388.31	388.31	388.31	128.0

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

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