PREVIEW / etf_1hour / 2001-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-31.parquet
  size:    12 KB
  rows:    255

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-10-31 09:00:00	SPY	ETF	106.9	107.43	106.75	107.18	2792600.0
2001-10-31 10:00:00	SPY	ETF	107.22	107.86	107.04	107.27	6990700.0
2001-10-31 11:00:00	SPY	ETF	107.27	107.44	107.01	107.06	1611200.0
2001-10-31 12:00:00	SPY	ETF	107.06	107.12	106.01	106.15	3031300.0
2001-10-31 13:00:00	SPY	ETF	106.15	106.88	106.11	106.74	2633700.0
2001-10-31 14:00:00	SPY	ETF	106.71	107.72	106.67	107.7	3342500.0
2001-10-31 15:00:00	SPY	ETF	107.7	107.77	106.2	106.27	5642000.0
2001-10-31 16:00:00	SPY	ETF	106.32	106.35	105.6	105.82	2068000.0
2001-10-31 17:00:00	SPY	ETF	105.75	105.85	105.67	105.84	6900.0
2001-10-31 18:00:00	SPY	ETF	105.82	105.82	105.82	105.82	1500.0
2001-10-31 09:00:00	QQQ	ETF	34.04	34.53	34.04	34.4	16454300.0
2001-10-31 10:00:00	QQQ	ETF	34.4	34.96	34.27	34.51	22435400.0
2001-10-31 11:00:00	QQQ	ETF	34.54	34.72	34.4	34.5	7527100.0
2001-10-31 12:00:00	QQQ	ETF	34.5	34.59	33.68	33.81	14297600.0
2001-10-31 13:00:00	QQQ	ETF	33.85	34.4	33.7	34.27	11902300.0
2001-10-31 14:00:00	QQQ	ETF	34.27	34.86	34.23	34.81	11572600.0
2001-10-31 15:00:00	QQQ	ETF	34.82	34.89	33.9	33.96	17917000.0
2001-10-31 16:00:00	QQQ	ETF	33.95	34.54	33.8	33.86	2657900.0
2001-10-31 17:00:00	QQQ	ETF	33.9	33.9	33.82	33.89	48500.0
2001-10-31 18:00:00	QQQ	ETF	33.9	33.95	33.86	33.89	19600.0
2001-10-31 09:00:00	IWM	ETF	42.325	42.615	42.275	42.275	17800.0
2001-10-31 10:00:00	IWM	ETF	42.4	42.885	42.4	42.75	226000.0
2001-10-31 11:00:00	IWM	ETF	42.58	42.725	42.51	42.59	252000.0
2001-10-31 12:00:00	IWM	ETF	42.55	42.55	42.205	42.205	348000.0
2001-10-31 13:00:00	IWM	ETF	42.245	42.425	42.205	42.425	79000.0
2001-10-31 14:00:00	IWM	ETF	42.475	42.8	42.43	42.74	103600.0
2001-10-31 15:00:00	IWM	ETF	42.74	42.74	42.48	42.55	195600.0
2001-10-31 16:00:00	IWM	ETF	42.55	42.55	42.45	42.45	101400.0
2001-10-31 09:00:00	DIA	ETF	91.92	92.1	91.4	91.7	595100.0
2001-10-31 10:00:00	DIA	ETF	91.8	92.43	91.7	91.83	1074200.0
2001-10-31 11:00:00	DIA	ETF	91.77	91.96	91.42	91.45	482500.0
2001-10-31 12:00:00	DIA	ETF	91.44	91.52	90.6	90.74	417300.0
2001-10-31 13:00:00	DIA	ETF	90.75	91.37	90.65	91.12	474400.0
2001-10-31 14:00:00	DIA	ETF	91.24	92.05	91.24	92.0	710100.0
2001-10-31 15:00:00	DIA	ETF	92.02	92.08	90.75	90.81	800300.0
2001-10-31 16:00:00	DIA	ETF	90.82	91.0	90.55	90.7	176700.0

> showing 36 of 255 rows — these rows as CSV

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