PREVIEW / etf_1hour / 2001-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-19.parquet
  size:    12 KB
  rows:    252

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-19 09:00:00	SPY	ETF	107.0	107.2	106.7	106.83	2380100.0
2001-10-19 10:00:00	SPY	ETF	106.71	106.76	106.07	106.53	4225800.0
2001-10-19 11:00:00	SPY	ETF	106.52	106.63	106.01	106.06	2810600.0
2001-10-19 12:00:00	SPY	ETF	106.04	106.38	106.04	106.2	718900.0
2001-10-19 13:00:00	SPY	ETF	106.19	106.75	106.12	106.64	1498000.0
2001-10-19 14:00:00	SPY	ETF	106.63	107.28	106.54	107.04	3312100.0
2001-10-19 15:00:00	SPY	ETF	107.02	107.91	106.94	107.55	5411900.0
2001-10-19 16:00:00	SPY	ETF	107.56	107.6	107.33	107.35	1033600.0
2001-10-19 17:00:00	SPY	ETF	107.25	108.15	107.14	107.6	3800.0
2001-10-19 18:00:00	SPY	ETF	107.7	107.7	107.67	107.67	200.0
2001-10-19 09:00:00	QQQ	ETF	32.86	33.17	32.76	32.8	8326400.0
2001-10-19 10:00:00	QQQ	ETF	32.77	32.88	32.51	32.88	12505100.0
2001-10-19 11:00:00	QQQ	ETF	32.88	32.93	32.45	32.46	6461500.0
2001-10-19 12:00:00	QQQ	ETF	32.46	32.73	32.45	32.58	3782800.0
2001-10-19 13:00:00	QQQ	ETF	32.61	33.06	32.56	33.05	7338400.0
2001-10-19 14:00:00	QQQ	ETF	33.03	33.55	32.95	33.32	14173100.0
2001-10-19 15:00:00	QQQ	ETF	33.32	33.75	33.25	33.55	13667600.0
2001-10-19 16:00:00	QQQ	ETF	33.53	33.68	33.2	33.52	4256800.0
2001-10-19 17:00:00	QQQ	ETF	33.52	33.58	33.5	33.51	24500.0
2001-10-19 18:00:00	QQQ	ETF	33.55	33.58	33.5	33.5	15600.0
2001-10-19 09:00:00	IWM	ETF	41.725	42.0	41.725	41.99	57800.0
2001-10-19 10:00:00	IWM	ETF	41.75	41.955	41.725	41.955	69400.0
2001-10-19 11:00:00	IWM	ETF	41.96	42.05	41.81	41.875	79400.0
2001-10-19 12:00:00	IWM	ETF	41.865	41.87	41.785	41.865	6400.0
2001-10-19 13:00:00	IWM	ETF	41.865	42.0	41.8	41.975	75400.0
2001-10-19 14:00:00	IWM	ETF	42.015	42.3	42.015	42.21	114000.0
2001-10-19 15:00:00	IWM	ETF	42.2	42.475	42.125	42.325	85000.0
2001-10-19 16:00:00	IWM	ETF	42.3	42.3	42.3	42.3	21600.0
2001-10-19 09:00:00	DIA	ETF	91.65	91.98	91.41	91.5	390200.0
2001-10-19 10:00:00	DIA	ETF	91.4	91.4	90.85	91.16	811300.0
2001-10-19 11:00:00	DIA	ETF	91.16	91.34	90.87	90.87	455900.0
2001-10-19 12:00:00	DIA	ETF	90.9	91.1	90.86	90.98	308200.0
2001-10-19 13:00:00	DIA	ETF	91.02	91.36	90.93	91.17	272900.0
2001-10-19 14:00:00	DIA	ETF	91.2	91.75	91.12	91.56	550600.0
2001-10-19 15:00:00	DIA	ETF	91.62	92.35	91.45	92.0	493300.0
2001-10-19 16:00:00	DIA	ETF	91.95	92.05	91.66	91.66	86000.0

> showing 36 of 252 rows — these rows as CSV

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