PREVIEW / etf_1hour / 2024-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-03-12.parquet
  size:    538 KB
  rows:    19,848

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-03-12 04:00:00	SPY	ETF	513.39	513.61	512.22	512.54	14009.0
2024-03-12 05:00:00	SPY	ETF	512.53	512.71	512.19	512.23	10641.0
2024-03-12 06:00:00	SPY	ETF	512.22	512.92	512.22	512.81	9995.0
2024-03-12 07:00:00	SPY	ETF	512.65	512.7	512.2	512.48	110834.0
2024-03-12 08:00:00	SPY	ETF	512.46	514.85	510.1	513.56	2365839.0
2024-03-12 09:00:00	SPY	ETF	513.58	513.8	510.86	513.44	8298800.0
2024-03-12 10:00:00	SPY	ETF	513.44	516.485	513.0	515.94	10778222.0
2024-03-12 11:00:00	SPY	ETF	515.93	516.535	515.18	515.88	6208836.0
2024-03-12 12:00:00	SPY	ETF	515.87	515.955	513.55	514.4	5326863.0
2024-03-12 13:00:00	SPY	ETF	514.41	515.8	513.62	515.6	4267021.0
2024-03-12 14:00:00	SPY	ETF	515.61	517.12	515.51	516.75	5846574.0
2024-03-12 15:00:00	SPY	ETF	516.7423	517.38	516.41	516.81	10574626.0
2024-03-12 16:00:00	SPY	ETF	516.81	517.11	516.66	516.66	2991655.0
2024-03-12 17:00:00	SPY	ETF	516.7	516.8	516.62	516.67	43716.0
2024-03-12 18:00:00	SPY	ETF	516.62	517.02	516.49	516.87	143693.0
2024-03-12 19:00:00	SPY	ETF	516.84	517.18	516.84	517.01	43559.0
2024-03-12 04:00:00	QQQ	ETF	440.06	440.43	438.92	439.17	53314.0
2024-03-12 05:00:00	QQQ	ETF	439.17	439.41	438.96	438.97	14324.0
2024-03-12 06:00:00	QQQ	ETF	438.94	439.65	438.94	439.52	39970.0
2024-03-12 07:00:00	QQQ	ETF	439.37	439.59	438.94	439.36	73095.0
2024-03-12 08:00:00	QQQ	ETF	439.34	441.33	437.0	439.79	1282686.0
2024-03-12 09:00:00	QQQ	ETF	439.9	440.4	436.46	439.335	6389145.0
2024-03-12 10:00:00	QQQ	ETF	439.315	442.95	438.87	442.32	8568683.0
2024-03-12 11:00:00	QQQ	ETF	442.36	443.2	441.59	442.34	4085657.0
2024-03-12 12:00:00	QQQ	ETF	442.35	442.45	440.07	440.81	4338796.0
2024-03-12 13:00:00	QQQ	ETF	440.82	442.1	440.07	441.9001	3707559.0
2024-03-12 14:00:00	QQQ	ETF	441.91	443.47	441.78	443.16	3718992.0
2024-03-12 15:00:00	QQQ	ETF	443.16	444.02	442.7	443.69	7314770.0
2024-03-12 16:00:00	QQQ	ETF	443.68	443.82	443.41	443.6	1636789.0
2024-03-12 17:00:00	QQQ	ETF	443.601	443.95	443.6	443.6	83738.0
2024-03-12 18:00:00	QQQ	ETF	443.56	443.77	443.44	443.66	100514.0
2024-03-12 19:00:00	QQQ	ETF	443.66	443.97	443.58	443.8	81016.0
2024-03-12 04:00:00	IWM	ETF	205.83	205.84	205.01	205.4	34214.0
2024-03-12 05:00:00	IWM	ETF	205.42	205.57	205.33	205.43	6709.0
2024-03-12 06:00:00	IWM	ETF	205.48	205.76	205.47	205.65	6581.0
2024-03-12 07:00:00	IWM	ETF	205.64	205.67	205.38	205.56	22227.0
2024-03-12 08:00:00	IWM	ETF	205.56	206.9	203.2	205.67	1607270.0
2024-03-12 09:00:00	IWM	ETF	205.72	206.11	203.39	205.05	5517202.0
2024-03-12 10:00:00	IWM	ETF	205.06	205.92	204.09	205.39	4095375.0
2024-03-12 11:00:00	IWM	ETF	205.39	205.915	204.58	204.91	2326958.0
2024-03-12 12:00:00	IWM	ETF	204.92	204.95	203.73	204.13	2680248.0
2024-03-12 13:00:00	IWM	ETF	204.13	204.355	203.56	204.3001	1915661.0
2024-03-12 14:00:00	IWM	ETF	204.31	204.98	204.26	204.83	1776863.0
2024-03-12 15:00:00	IWM	ETF	204.83	205.27	204.68	204.96	4502754.0
2024-03-12 16:00:00	IWM	ETF	204.91	205.12	204.7	204.7	762848.0
2024-03-12 17:00:00	IWM	ETF	204.66	204.85	204.64	204.85	28753.0
2024-03-12 18:00:00	IWM	ETF	204.77	204.91	204.65	204.8	25687.0
2024-03-12 19:00:00	IWM	ETF	204.72	205.0	204.72	204.84	37945.0
2024-03-12 04:00:00	DIA	ETF	388.51	388.51	388.41	388.41	300.0
2024-03-12 06:00:00	DIA	ETF	388.52	388.52	388.52	388.52	100.0

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

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