PREVIEW / etf_1hour / 2024-03-04

all etf 1-hour files

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

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-04 04:00:00	SPY	ETF	512.74	512.89	512.55	512.56	12126.0
2024-03-04 05:00:00	SPY	ETF	512.42	512.55	512.32	512.46	6469.0
2024-03-04 06:00:00	SPY	ETF	512.46	512.46	512.0	512.39	11819.0
2024-03-04 07:00:00	SPY	ETF	512.36	512.58	512.28	512.28	93467.0
2024-03-04 08:00:00	SPY	ETF	512.28	512.76	511.82	511.86	227002.0
2024-03-04 09:00:00	SPY	ETF	511.82	512.61	511.66	512.505	4630024.0
2024-03-04 10:00:00	SPY	ETF	512.5	512.88	512.07	512.66	4050364.0
2024-03-04 11:00:00	SPY	ETF	512.665	512.82	512.16	512.73	3467256.0
2024-03-04 12:00:00	SPY	ETF	512.72	513.18	512.49	512.96	3047435.0
2024-03-04 13:00:00	SPY	ETF	512.955	513.07	512.35	512.765	2889595.0
2024-03-04 14:00:00	SPY	ETF	512.76	514.13	512.6	513.815	5188980.0
2024-03-04 15:00:00	SPY	ETF	513.8178	514.2	512.17	512.25	12090643.0
2024-03-04 16:00:00	SPY	ETF	512.24	512.32	511.8	511.88	2804163.0
2024-03-04 17:00:00	SPY	ETF	511.87	511.87	511.75	511.8	74040.0
2024-03-04 18:00:00	SPY	ETF	511.8	511.94	511.46	511.59	110901.0
2024-03-04 19:00:00	SPY	ETF	511.5	511.9	511.41	511.59	82797.0
2024-03-04 04:00:00	QQQ	ETF	446.48	446.77	445.69	445.69	82608.0
2024-03-04 05:00:00	QQQ	ETF	445.68	445.75	445.43	445.62	30251.0
2024-03-04 06:00:00	QQQ	ETF	445.61	445.76	445.2	445.76	17812.0
2024-03-04 07:00:00	QQQ	ETF	445.77	446.15	445.66	445.73	148411.0
2024-03-04 08:00:00	QQQ	ETF	445.79	446.65	445.56	445.76	245841.0
2024-03-04 09:00:00	QQQ	ETF	445.75	445.78	444.59	444.82	4046575.0
2024-03-04 10:00:00	QQQ	ETF	444.82	445.71	444.43	445.445	3768944.0
2024-03-04 11:00:00	QQQ	ETF	445.45	445.555	444.47	445.31	2418563.0
2024-03-04 12:00:00	QQQ	ETF	445.28	445.59	444.77	445.0013	2383980.0
2024-03-04 13:00:00	QQQ	ETF	445.005	445.2001	444.2	444.98	2074453.0
2024-03-04 14:00:00	QQQ	ETF	444.97	446.01	444.66	445.69	3099355.0
2024-03-04 15:00:00	QQQ	ETF	445.69	446.04	443.77	443.9	6512737.0
2024-03-04 16:00:00	QQQ	ETF	443.9	445.0	443.35	443.56	998690.0
2024-03-04 17:00:00	QQQ	ETF	443.56	443.6	443.39	443.529	24546.0
2024-03-04 18:00:00	QQQ	ETF	443.61	443.76	442.95	443.05	117108.0
2024-03-04 19:00:00	QQQ	ETF	443.04	443.4	442.8	443.01	56705.0
2024-03-04 04:00:00	IWM	ETF	206.03	206.91	206.02	206.81	27248.0
2024-03-04 05:00:00	IWM	ETF	206.81	207.22	206.81	207.06	27191.0
2024-03-04 06:00:00	IWM	ETF	207.13	207.29	206.93	207.27	27785.0
2024-03-04 07:00:00	IWM	ETF	207.24	207.29	207.07	207.22	85517.0
2024-03-04 08:00:00	IWM	ETF	207.18	207.2996	205.44	206.99	125987.0
2024-03-04 09:00:00	IWM	ETF	207.03	207.77	206.78	207.48	3237689.0
2024-03-04 10:00:00	IWM	ETF	207.47	207.47	206.07	206.3299	3892696.0
2024-03-04 11:00:00	IWM	ETF	206.32	207.185	206.32	207.18	1934126.0
2024-03-04 12:00:00	IWM	ETF	207.1799	207.22	206.7351	206.815	1438107.0
2024-03-04 13:00:00	IWM	ETF	206.81	207.07	206.47	206.56	1443052.0
2024-03-04 14:00:00	IWM	ETF	206.55	206.92	206.31	206.63	2129766.0
2024-03-04 15:00:00	IWM	ETF	206.63	206.79	205.45	205.68	4087101.0
2024-03-04 16:00:00	IWM	ETF	205.7	205.75	205.44	205.49	815604.0
2024-03-04 17:00:00	IWM	ETF	205.47	205.56	205.44	205.5	16481.0
2024-03-04 18:00:00	IWM	ETF	205.5	205.54	205.14	205.14	27653.0
2024-03-04 19:00:00	IWM	ETF	205.1199	205.28	205.01	205.1	20350.0
2024-03-04 04:00:00	DIA	ETF	390.6	390.79	390.6	390.79	300.0
2024-03-04 07:00:00	DIA	ETF	390.51	390.51	390.23	390.23	11502.0

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

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