PREVIEW / etf_1hour / 2001-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-31.parquet
  size:    12 KB
  rows:    241

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-08-31 09:00:00	SPY	ETF	113.4	113.6	113.13	113.4	2193100.0
2001-08-31 10:00:00	SPY	ETF	113.4	114.77	113.4	113.89	4187800.0
2001-08-31 11:00:00	SPY	ETF	113.86	113.92	113.35	113.37	1754800.0
2001-08-31 12:00:00	SPY	ETF	113.41	114.11	113.2	113.91	1589300.0
2001-08-31 13:00:00	SPY	ETF	113.95	114.29	113.84	114.09	1164300.0
2001-08-31 14:00:00	SPY	ETF	114.09	114.2	113.72	113.72	1230500.0
2001-08-31 15:00:00	SPY	ETF	113.7	114.07	113.61	113.92	2381200.0
2001-08-31 16:00:00	SPY	ETF	113.9	114.3	113.88	114.3	701700.0
2001-08-31 17:00:00	SPY	ETF	114.18	114.21	114.15	114.15	800.0
2001-08-31 09:00:00	QQQ	ETF	36.03	36.32	35.94	36.06	8462800.0
2001-08-31 10:00:00	QQQ	ETF	36.06	37.03	36.03	36.4	18118300.0
2001-08-31 11:00:00	QQQ	ETF	36.39	36.63	36.2	36.24	6151000.0
2001-08-31 12:00:00	QQQ	ETF	36.24	36.59	36.11	36.53	5624900.0
2001-08-31 13:00:00	QQQ	ETF	36.5	36.76	36.46	36.61	3335900.0
2001-08-31 14:00:00	QQQ	ETF	36.61	36.74	36.37	36.38	3064900.0
2001-08-31 15:00:00	QQQ	ETF	36.38	36.68	36.33	36.59	6605800.0
2001-08-31 16:00:00	QQQ	ETF	36.59	36.73	36.43	36.63	855600.0
2001-08-31 17:00:00	QQQ	ETF	36.6	37.25	36.55	36.6	57200.0
2001-08-31 18:00:00	QQQ	ETF	36.6	36.63	36.6	36.62	8700.0
2001-08-31 09:00:00	IWM	ETF	46.7	46.74	46.63	46.655	255800.0
2001-08-31 10:00:00	IWM	ETF	46.69	47.015	46.69	46.99	610000.0
2001-08-31 11:00:00	IWM	ETF	46.93	46.93	46.81	46.86	18800.0
2001-08-31 12:00:00	IWM	ETF	46.75	46.895	46.63	46.895	10800.0
2001-08-31 13:00:00	IWM	ETF	46.8	46.97	46.79	46.97	11200.0
2001-08-31 14:00:00	IWM	ETF	46.965	47.025	46.885	47.025	10000.0
2001-08-31 15:00:00	IWM	ETF	46.845	47.07	46.8	46.825	60000.0
2001-08-31 16:00:00	IWM	ETF	46.945	46.945	46.945	46.945	2000.0
2001-08-31 09:00:00	DIA	ETF	99.4	99.59	99.07	99.45	481000.0
2001-08-31 10:00:00	DIA	ETF	99.4	100.67	99.4	99.92	1397400.0
2001-08-31 11:00:00	DIA	ETF	99.92	99.96	99.48	99.5	511200.0
2001-08-31 12:00:00	DIA	ETF	99.48	99.98	99.34	99.81	285700.0
2001-08-31 13:00:00	DIA	ETF	99.83	100.15	99.76	99.92	263900.0
2001-08-31 14:00:00	DIA	ETF	99.91	100.06	99.62	99.62	209900.0
2001-08-31 15:00:00	DIA	ETF	99.62	99.87	99.55	99.76	250100.0
2001-08-31 16:00:00	DIA	ETF	99.78	99.95	99.74	99.9	61300.0

> showing 35 of 241 rows — these rows as CSV

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