PREVIEW / etf_1hour / 2001-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-21.parquet
  size:    12 KB
  rows:    257

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-21 09:00:00	SPY	ETF	94.05	95.6	93.8	94.9	9785300.0
2001-09-21 10:00:00	SPY	ETF	94.85	98.99	94.6	96.85	14168100.0
2001-09-21 11:00:00	SPY	ETF	96.86	97.19	95.86	96.0	5192800.0
2001-09-21 12:00:00	SPY	ETF	96.0	97.3	95.63	96.67	4408500.0
2001-09-21 13:00:00	SPY	ETF	96.67	97.49	96.37	96.6	2824600.0
2001-09-21 14:00:00	SPY	ETF	96.6	97.05	96.25	96.64	3136600.0
2001-09-21 15:00:00	SPY	ETF	96.6	97.1	95.9	96.85	5218600.0
2001-09-21 16:00:00	SPY	ETF	96.81	97.45	96.72	97.15	1621100.0
2001-09-21 17:00:00	SPY	ETF	97.0	97.35	97.0	97.0	1100.0
2001-09-21 18:00:00	SPY	ETF	97.15	97.15	97.15	97.15	1500.0
2001-09-21 09:00:00	QQQ	ETF	27.41	28.0	27.2	27.7	19390100.0
2001-09-21 10:00:00	QQQ	ETF	27.7	28.97	27.41	28.25	30646200.0
2001-09-21 11:00:00	QQQ	ETF	28.25	28.45	27.86	28.02	11677700.0
2001-09-21 12:00:00	QQQ	ETF	28.03	28.39	27.8	28.12	8411700.0
2001-09-21 13:00:00	QQQ	ETF	28.13	28.47	27.95	28.01	8662400.0
2001-09-21 14:00:00	QQQ	ETF	27.99	28.19	27.83	28.02	7892400.0
2001-09-21 15:00:00	QQQ	ETF	28.03	28.33	27.65	28.17	17886000.0
2001-09-21 16:00:00	QQQ	ETF	28.13	28.3	28.05	28.21	1441800.0
2001-09-21 17:00:00	QQQ	ETF	28.12	28.19	28.0	28.15	52600.0
2001-09-21 18:00:00	QQQ	ETF	28.15	28.25	28.14	28.21	14100.0
2001-09-21 09:00:00	IWM	ETF	37.25	37.5	36.75	37.375	203600.0
2001-09-21 10:00:00	IWM	ETF	37.375	38.025	37.115	37.475	363000.0
2001-09-21 11:00:00	IWM	ETF	37.675	37.725	37.18	37.445	13600.0
2001-09-21 12:00:00	IWM	ETF	37.35	37.5	37.175	37.5	18200.0
2001-09-21 13:00:00	IWM	ETF	37.365	37.55	37.225	37.55	37200.0
2001-09-21 14:00:00	IWM	ETF	37.37	37.77	37.33	37.65	62200.0
2001-09-21 15:00:00	IWM	ETF	37.65	37.87	37.455	37.825	306000.0
2001-09-21 16:00:00	IWM	ETF	37.83	37.83	37.83	37.83	200.0
2001-09-21 09:00:00	DIA	ETF	80.05	82.45	79.5	81.3	2540900.0
2001-09-21 10:00:00	DIA	ETF	81.05	85.0	80.5	82.28	3781000.0
2001-09-21 11:00:00	DIA	ETF	82.16	82.6	81.3	81.56	1306800.0
2001-09-21 12:00:00	DIA	ETF	81.69	82.65	81.1	81.96	1492300.0
2001-09-21 13:00:00	DIA	ETF	82.1	82.95	81.71	82.05	537000.0
2001-09-21 14:00:00	DIA	ETF	81.97	82.65	81.76	82.2	578700.0
2001-09-21 15:00:00	DIA	ETF	82.15	82.9	81.4	82.51	1666900.0
2001-09-21 16:00:00	DIA	ETF	82.66	82.82	82.45	82.8	251400.0
2001-09-21 17:00:00	DIA	ETF	82.54	82.54	82.5	82.5	1900.0

> showing 37 of 257 rows — these rows as CSV

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