PREVIEW / etf_1hour / 2024-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-04-03.parquet
  size:    543 KB
  rows:    20,211

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-03 04:00:00	SPY	ETF	517.82	518.46	517.74	518.24	11565.0
2024-04-03 05:00:00	SPY	ETF	518.18	518.4	517.82	517.83	8938.0
2024-04-03 06:00:00	SPY	ETF	517.85	518.06	517.67	517.95	22044.0
2024-04-03 07:00:00	SPY	ETF	517.92	518.75	517.92	518.7	121681.0
2024-04-03 08:00:00	SPY	ETF	518.15	519.01	517.57	517.98	309298.0
2024-04-03 09:00:00	SPY	ETF	517.9494	518.64	517.39	518.39	3821501.0
2024-04-03 10:00:00	SPY	ETF	518.45	520.84	518.42	520.68	7915036.0
2024-04-03 11:00:00	SPY	ETF	520.67	520.95	520.1	520.1901	3644226.0
2024-04-03 12:00:00	SPY	ETF	520.18	520.845	519.39	520.31	6081054.0
2024-04-03 13:00:00	SPY	ETF	520.32	520.8	520.3	520.55	2675847.0
2024-04-03 14:00:00	SPY	ETF	520.56	520.8	519.8496	519.96	3697644.0
2024-04-03 15:00:00	SPY	ETF	519.95	520.03	517.77	519.36	13815890.0
2024-04-03 16:00:00	SPY	ETF	519.37	519.99	519.2555	519.78	2652538.0
2024-04-03 17:00:00	SPY	ETF	519.78	519.93	519.41	519.93	236991.0
2024-04-03 18:00:00	SPY	ETF	519.93	519.93	519.6	519.7	67506.0
2024-04-03 19:00:00	SPY	ETF	519.75	521.24	519.71	520.7	79508.0
2024-04-03 04:00:00	QQQ	ETF	435.05	440.7	435.05	440.41	18893.0
2024-04-03 05:00:00	QQQ	ETF	440.15	440.24	439.58	439.58	8531.0
2024-04-03 06:00:00	QQQ	ETF	439.71	439.89	439.3	439.63	16378.0
2024-04-03 07:00:00	QQQ	ETF	439.69	440.65	439.69	440.55	110761.0
2024-04-03 08:00:00	QQQ	ETF	439.99	440.88	439.23	439.63	284136.0
2024-04-03 09:00:00	QQQ	ETF	439.6	440.025	438.78	439.7	3004393.0
2024-04-03 10:00:00	QQQ	ETF	439.75	443.585	439.72	443.48	5959504.0
2024-04-03 11:00:00	QQQ	ETF	443.49	444.0	442.75	442.87	3543105.0
2024-04-03 12:00:00	QQQ	ETF	442.88	443.71	442.09	443.06	4594875.0
2024-04-03 13:00:00	QQQ	ETF	443.07	443.52	442.94	443.17	1749969.0
2024-04-03 14:00:00	QQQ	ETF	443.1789	443.5299	442.58	442.72	2067981.0
2024-04-03 15:00:00	QQQ	ETF	442.71	442.73	440.46	442.06	6957518.0
2024-04-03 16:00:00	QQQ	ETF	442.04	442.75	442.02	442.49	1003071.0
2024-04-03 17:00:00	QQQ	ETF	442.46	442.58	442.43	442.58	46201.0
2024-04-03 18:00:00	QQQ	ETF	442.48	442.5	442.22	442.5	50695.0
2024-04-03 19:00:00	QQQ	ETF	442.55	444.77	442.51	443.81	109606.0
2024-04-03 04:00:00	IWM	ETF	203.88	204.26	203.84	204.02	15213.0
2024-04-03 05:00:00	IWM	ETF	204.02	204.35	203.97	204.25	7870.0
2024-04-03 06:00:00	IWM	ETF	204.21	204.6	204.2	204.56	16150.0
2024-04-03 07:00:00	IWM	ETF	204.58	205.25	204.58	205.03	148156.0
2024-04-03 08:00:00	IWM	ETF	205.03	205.19	203.61	203.74	272850.0
2024-04-03 09:00:00	IWM	ETF	203.75	204.72	203.19	203.95	2688147.0
2024-04-03 10:00:00	IWM	ETF	203.96	206.24	203.96	205.96	5052345.0
2024-04-03 11:00:00	IWM	ETF	205.98	206.17	205.37	205.47	1773741.0
2024-04-03 12:00:00	IWM	ETF	205.48	206.4	205.25	206.0	2521269.0
2024-04-03 13:00:00	IWM	ETF	206.0	206.345	205.925	206.06	1422354.0
2024-04-03 14:00:00	IWM	ETF	206.06	206.315	206.02	206.185	1252209.0
2024-04-03 15:00:00	IWM	ETF	206.19	206.195	205.23	205.78	4698206.0
2024-04-03 16:00:00	IWM	ETF	205.83	206.09	205.7	205.97	1365996.0
2024-04-03 17:00:00	IWM	ETF	206.09	206.1	205.95	206.09	16623.0
2024-04-03 18:00:00	IWM	ETF	206.03	206.03	205.86	205.97	12802.0
2024-04-03 19:00:00	IWM	ETF	206.02	206.76	206.0	206.331	50093.0
2024-04-03 07:00:00	DIA	ETF	391.5	391.61	391.48	391.48	2200.0
2024-04-03 08:00:00	DIA	ETF	391.54	391.73	391.19	391.24	7700.0

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

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