PREVIEW / etf_1hour / 2001-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-26.parquet
  size:    12 KB
  rows:    258

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-26 09:00:00	SPY	ETF	102.35	102.4	101.25	101.51	3629800.0
2001-09-26 10:00:00	SPY	ETF	101.51	101.8	101.15	101.56	2477500.0
2001-09-26 11:00:00	SPY	ETF	101.6	101.66	100.65	100.76	2395600.0
2001-09-26 12:00:00	SPY	ETF	100.8	101.1	100.75	100.81	1403000.0
2001-09-26 13:00:00	SPY	ETF	100.75	100.84	100.49	100.74	2358600.0
2001-09-26 14:00:00	SPY	ETF	100.76	101.0	100.43	100.68	1273600.0
2001-09-26 15:00:00	SPY	ETF	100.69	101.0	100.48	101.0	2628500.0
2001-09-26 16:00:00	SPY	ETF	101.0	101.42	100.97	101.15	1367300.0
2001-09-26 17:00:00	SPY	ETF	101.25	101.45	101.25	101.45	1700.0
2001-09-26 18:00:00	SPY	ETF	101.15	101.15	101.15	101.15	200.0
2001-09-26 09:00:00	QQQ	ETF	29.95	30.0	29.38	29.48	8251500.0
2001-09-26 10:00:00	QQQ	ETF	29.48	29.57	29.05	29.35	12224900.0
2001-09-26 11:00:00	QQQ	ETF	29.32	29.38	28.8	28.89	8142800.0
2001-09-26 12:00:00	QQQ	ETF	28.89	29.08	28.83	28.9	5332500.0
2001-09-26 13:00:00	QQQ	ETF	28.89	28.9	28.58	28.7	6035200.0
2001-09-26 14:00:00	QQQ	ETF	28.73	28.86	28.48	28.55	5637500.0
2001-09-26 15:00:00	QQQ	ETF	28.56	28.73	28.41	28.51	9369100.0
2001-09-26 16:00:00	QQQ	ETF	28.5	28.75	28.48	28.6	1913200.0
2001-09-26 17:00:00	QQQ	ETF	28.6	28.61	28.44	28.53	61200.0
2001-09-26 18:00:00	QQQ	ETF	28.5	28.5	28.4	28.45	23300.0
2001-09-26 09:00:00	IWM	ETF	39.6	39.8	39.5	39.5	497000.0
2001-09-26 10:00:00	IWM	ETF	39.48	39.5	39.2	39.39	150400.0
2001-09-26 11:00:00	IWM	ETF	39.4	39.4	39.0	39.0	28800.0
2001-09-26 12:00:00	IWM	ETF	39.05	39.125	38.94	39.0	23400.0
2001-09-26 13:00:00	IWM	ETF	39.075	39.075	38.905	38.905	15400.0
2001-09-26 14:00:00	IWM	ETF	39.025	39.05	38.9	38.9	27200.0
2001-09-26 15:00:00	IWM	ETF	38.875	38.945	38.675	38.825	224400.0
2001-09-26 16:00:00	IWM	ETF	38.88	38.89	38.88	38.89	3000.0
2001-09-26 09:00:00	DIA	ETF	87.39	87.5	86.05	86.5	772500.0
2001-09-26 10:00:00	DIA	ETF	86.4	86.79	85.86	86.35	664800.0
2001-09-26 11:00:00	DIA	ETF	86.27	86.39	85.55	85.7	532600.0
2001-09-26 12:00:00	DIA	ETF	85.7	86.08	85.61	85.7	249000.0
2001-09-26 13:00:00	DIA	ETF	85.7	85.72	85.3	85.55	324700.0
2001-09-26 14:00:00	DIA	ETF	85.66	85.89	85.3	85.54	481700.0
2001-09-26 15:00:00	DIA	ETF	85.54	85.84	85.37	85.78	400500.0
2001-09-26 16:00:00	DIA	ETF	85.78	86.2	85.73	85.95	299000.0
2001-09-26 17:00:00	DIA	ETF	85.65	87.35	84.01	86.05	6400.0

> showing 37 of 258 rows — these rows as CSV

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