PREVIEW / etf_1hour / 2024-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-04-05.parquet
  size:    536 KB
  rows:    19,805

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-04-05 04:00:00	SPY	ETF	514.42	514.74	514.1	514.28	18038.0
2024-04-05 05:00:00	SPY	ETF	514.57	514.75	514.31	514.5	12627.0
2024-04-05 06:00:00	SPY	ETF	514.63	514.67	514.24	514.57	16517.0
2024-04-05 07:00:00	SPY	ETF	514.6	515.24	514.46	514.73	213626.0
2024-04-05 08:00:00	SPY	ETF	514.66	515.749	512.51	514.49	2200130.0
2024-04-05 09:00:00	SPY	ETF	514.51	516.4	513.87	515.92	6591877.0
2024-04-05 10:00:00	SPY	ETF	515.92	518.0913	514.89	518.06	8919513.0
2024-04-05 11:00:00	SPY	ETF	518.05	519.72	516.43	519.43	8046969.0
2024-04-05 12:00:00	SPY	ETF	519.43	520.44	519.08	520.3398	7011657.0
2024-04-05 13:00:00	SPY	ETF	520.33	520.43	517.43	517.8099	6193903.0
2024-04-05 14:00:00	SPY	ETF	517.8	519.28	516.97	517.865	7233992.0
2024-04-05 15:00:00	SPY	ETF	517.88	519.295	517.68	518.4	10815710.0
2024-04-05 16:00:00	SPY	ETF	518.39	518.79	518.17	518.79	2523069.0
2024-04-05 17:00:00	SPY	ETF	518.73	518.85	518.3	518.38	86430.0
2024-04-05 18:00:00	SPY	ETF	518.38	518.48	518.35	518.39	13287.0
2024-04-05 19:00:00	SPY	ETF	518.38	518.7	518.25	518.51	42713.0
2024-04-05 04:00:00	QQQ	ETF	436.76	437.08	436.45	436.7	37332.0
2024-04-05 05:00:00	QQQ	ETF	436.8	437.04	436.6	436.83	49742.0
2024-04-05 06:00:00	QQQ	ETF	436.75	436.92	436.42	436.86	64774.0
2024-04-05 07:00:00	QQQ	ETF	436.84	437.46	436.7	437.04	172008.0
2024-04-05 08:00:00	QQQ	ETF	436.88	438.02	434.48	436.93	1538061.0
2024-04-05 09:00:00	QQQ	ETF	436.95	439.0	435.96	438.47	5260117.0
2024-04-05 10:00:00	QQQ	ETF	438.47	440.9499	437.71	440.9101	6003184.0
2024-04-05 11:00:00	QQQ	ETF	440.92	442.21	439.06	441.96	6066145.0
2024-04-05 12:00:00	QQQ	ETF	441.97	443.14	441.44	443.0101	4862598.0
2024-04-05 13:00:00	QQQ	ETF	443.01	443.17	440.12	440.37	4165156.0
2024-04-05 14:00:00	QQQ	ETF	440.38	441.62	439.45	440.1	4943767.0
2024-04-05 15:00:00	QQQ	ETF	440.11	441.38	439.89	440.51	8518283.0
2024-04-05 16:00:00	QQQ	ETF	440.51	440.89	440.25	440.87	1699366.0
2024-04-05 17:00:00	QQQ	ETF	440.9	441.08	440.54	440.55	51702.0
2024-04-05 18:00:00	QQQ	ETF	440.57	440.73	440.51	440.7	8706.0
2024-04-05 19:00:00	QQQ	ETF	440.66	440.71	440.61	440.63	9097.0
2024-04-05 04:00:00	IWM	ETF	204.1	204.59	204.05	204.06	16095.0
2024-04-05 05:00:00	IWM	ETF	204.14	204.28	204.06	204.27	19971.0
2024-04-05 06:00:00	IWM	ETF	204.24	204.24	204.0	204.23	55722.0
2024-04-05 07:00:00	IWM	ETF	204.2	204.42	204.07	204.09	51973.0
2024-04-05 08:00:00	IWM	ETF	204.26	205.27	202.72	203.03	1387932.0
2024-04-05 09:00:00	IWM	ETF	203.05	204.15	202.26	203.94	3777955.0
2024-04-05 10:00:00	IWM	ETF	203.92	204.65	203.42	204.63	4032609.0
2024-04-05 11:00:00	IWM	ETF	204.63	205.07	203.71	205.0051	3164517.0
2024-04-05 12:00:00	IWM	ETF	205.01	205.695	204.75	205.648	2388737.0
2024-04-05 13:00:00	IWM	ETF	205.64	205.64	204.41	204.57	1591587.0
2024-04-05 14:00:00	IWM	ETF	204.57	205.13	204.23	204.53	1906777.0
2024-04-05 15:00:00	IWM	ETF	204.54	205.05	204.38	204.45	3108909.0
2024-04-05 16:00:00	IWM	ETF	204.45	204.73	204.29	204.57	536661.0
2024-04-05 17:00:00	IWM	ETF	204.56	204.62	204.34	204.52	33372.0
2024-04-05 18:00:00	IWM	ETF	204.47	204.49	204.42	204.48	2095.0
2024-04-05 19:00:00	IWM	ETF	204.45	204.45	204.33	204.42	3470.0
2024-04-05 04:00:00	DIA	ETF	386.6	386.6	386.5	386.5	900.0
2024-04-05 05:00:00	DIA	ETF	386.66	386.67	386.61	386.62	5300.0

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

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