PREVIEW / etf_1hour / 2001-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-05-25.parquet
  size:    11 KB
  rows:    221

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-05-25 09:00:00	SPY	ETF	129.65	129.7	129.29	129.5	938600.0
2001-05-25 10:00:00	SPY	ETF	129.53	129.53	128.25	128.4	1798000.0
2001-05-25 11:00:00	SPY	ETF	128.41	128.84	128.33	128.62	725600.0
2001-05-25 12:00:00	SPY	ETF	128.7	128.74	128.47	128.6	324000.0
2001-05-25 13:00:00	SPY	ETF	128.6	128.68	128.23	128.66	665100.0
2001-05-25 14:00:00	SPY	ETF	128.6	128.74	128.4	128.4	426500.0
2001-05-25 15:00:00	SPY	ETF	128.35	128.59	128.01	128.23	1621900.0
2001-05-25 16:00:00	SPY	ETF	128.25	128.27	127.9	128.1	373200.0
2001-05-25 09:00:00	QQQ	ETF	49.96	50.02	49.51	49.67	6742700.0
2001-05-25 10:00:00	QQQ	ETF	49.67	49.75	48.65	48.79	11130600.0
2001-05-25 11:00:00	QQQ	ETF	48.79	49.15	48.7	49.01	4393900.0
2001-05-25 12:00:00	QQQ	ETF	49.0	49.17	48.81	49.06	1834700.0
2001-05-25 13:00:00	QQQ	ETF	49.06	49.2	48.81	49.14	2448300.0
2001-05-25 14:00:00	QQQ	ETF	49.12	49.29	48.96	49.0	3161900.0
2001-05-25 15:00:00	QQQ	ETF	48.97	49.08	48.73	48.9	4730400.0
2001-05-25 16:00:00	QQQ	ETF	48.97	49.85	48.8	49.02	524000.0
2001-05-25 17:00:00	QQQ	ETF	49.0	49.02	48.97	49.0	15800.0
2001-05-25 18:00:00	QQQ	ETF	48.98	49.05	48.94	48.94	4600.0
2001-05-25 09:00:00	IWM	ETF	51.05	51.1	50.925	51.075	20000.0
2001-05-25 10:00:00	IWM	ETF	51.1	51.1	50.75	50.805	66400.0
2001-05-25 11:00:00	IWM	ETF	50.8	50.96	50.725	50.96	42600.0
2001-05-25 12:00:00	IWM	ETF	50.95	50.96	50.925	50.95	16400.0
2001-05-25 13:00:00	IWM	ETF	50.865	50.87	50.765	50.765	118200.0
2001-05-25 14:00:00	IWM	ETF	50.87	51.025	50.87	50.97	8600.0
2001-05-25 15:00:00	IWM	ETF	50.96	50.96	50.655	50.655	48000.0
2001-05-25 16:00:00	IWM	ETF	50.8	50.8	50.65	50.65	8000.0
2001-05-25 09:00:00	DIA	ETF	111.35	111.35	110.92	111.05	236100.0
2001-05-25 10:00:00	DIA	ETF	111.05	111.05	110.25	110.32	384100.0
2001-05-25 11:00:00	DIA	ETF	110.32	110.69	110.31	110.6	294600.0
2001-05-25 12:00:00	DIA	ETF	110.53	110.56	110.35	110.46	55700.0
2001-05-25 13:00:00	DIA	ETF	110.4	110.66	110.24	110.62	100200.0
2001-05-25 14:00:00	DIA	ETF	110.62	110.65	110.33	110.48	81700.0
2001-05-25 15:00:00	DIA	ETF	110.35	110.48	110.06	110.23	227900.0
2001-05-25 16:00:00	DIA	ETF	110.23	110.32	110.01	110.05	1045800.0

> showing 34 of 221 rows — these rows as CSV

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