PREVIEW / etf_1hour / 2001-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-24.parquet
  size:    13 KB
  rows:    271

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
2001-09-24 09:00:00	SPY	ETF	99.72	100.06	99.25	99.4	3889400.0
2001-09-24 10:00:00	SPY	ETF	99.3	99.96	99.06	99.8	4739600.0
2001-09-24 11:00:00	SPY	ETF	99.88	100.6	99.82	100.51	4807100.0
2001-09-24 12:00:00	SPY	ETF	100.47	100.82	100.34	100.82	1836300.0
2001-09-24 13:00:00	SPY	ETF	100.76	100.82	100.13	100.3	1862500.0
2001-09-24 14:00:00	SPY	ETF	100.32	101.13	100.3	100.96	2228200.0
2001-09-24 15:00:00	SPY	ETF	101.02	101.16	100.2	100.48	4568700.0
2001-09-24 16:00:00	SPY	ETF	100.48	100.85	100.25	100.7	897900.0
2001-09-24 17:00:00	SPY	ETF	100.8	100.87	100.65	100.7	14200.0
2001-09-24 18:00:00	SPY	ETF	100.85	100.85	100.85	100.85	100.0
2001-09-24 09:00:00	QQQ	ETF	29.08	29.93	28.9	29.0	14483800.0
2001-09-24 10:00:00	QQQ	ETF	28.95	29.47	28.8	29.44	19696900.0
2001-09-24 11:00:00	QQQ	ETF	29.42	29.69	29.4	29.62	11287000.0
2001-09-24 12:00:00	QQQ	ETF	29.64	29.85	29.52	29.8	6293500.0
2001-09-24 13:00:00	QQQ	ETF	29.8	29.82	29.45	29.45	6647000.0
2001-09-24 14:00:00	QQQ	ETF	29.48	29.95	29.43	29.9	7816100.0
2001-09-24 15:00:00	QQQ	ETF	29.9	29.99	29.36	29.6	13880300.0
2001-09-24 16:00:00	QQQ	ETF	29.59	29.66	29.34	29.51	2013600.0
2001-09-24 17:00:00	QQQ	ETF	29.56	29.7	29.49	29.65	23900.0
2001-09-24 18:00:00	QQQ	ETF	29.65	29.8	29.65	29.79	20900.0
2001-09-24 09:00:00	IWM	ETF	38.25	38.825	38.25	38.7	500400.0
2001-09-24 10:00:00	IWM	ETF	38.75	38.9	38.65	38.89	435600.0
2001-09-24 11:00:00	IWM	ETF	39.0	39.125	38.875	39.0	200200.0
2001-09-24 12:00:00	IWM	ETF	39.06	39.075	38.975	39.075	92000.0
2001-09-24 13:00:00	IWM	ETF	39.06	39.145	38.97	39.0	63600.0
2001-09-24 14:00:00	IWM	ETF	38.925	39.235	38.925	39.235	59000.0
2001-09-24 15:00:00	IWM	ETF	39.15	39.29	38.905	39.29	147200.0
2001-09-24 16:00:00	IWM	ETF	39.19	39.19	39.0	39.0	90400.0
2001-09-24 09:00:00	DIA	ETF	85.46	85.65	84.61	84.7	1221100.0
2001-09-24 10:00:00	DIA	ETF	84.66	85.35	84.5	85.33	1273400.0
2001-09-24 11:00:00	DIA	ETF	85.25	86.15	85.25	85.95	1350700.0
2001-09-24 12:00:00	DIA	ETF	85.91	86.19	85.81	86.15	340900.0
2001-09-24 13:00:00	DIA	ETF	86.19	86.19	85.53	85.6	576800.0
2001-09-24 14:00:00	DIA	ETF	85.56	86.5	85.55	86.32	976800.0
2001-09-24 15:00:00	DIA	ETF	86.21	86.69	85.9	86.1	1593400.0
2001-09-24 16:00:00	DIA	ETF	86.2	87.25	86.03	86.15	474300.0
2001-09-24 17:00:00	DIA	ETF	86.2	86.2	86.2	86.2	400.0
2001-09-24 18:00:00	DIA	ETF	86.3	86.4	86.3	86.4	200.0

> showing 38 of 271 rows — these rows as CSV

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