PREVIEW / etf_1hour / 2002-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-08.parquet
  size:    16 KB
  rows:    367

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
2002-10-08 08:00:00	SPY	ETF	79.64	79.98	79.64	79.98	2200.0
2002-10-08 09:00:00	SPY	ETF	80.01	80.17	79.51	79.56	6661000.0
2002-10-08 10:00:00	SPY	ETF	79.55	80.18	79.2	79.4	7954500.0
2002-10-08 11:00:00	SPY	ETF	79.35	79.43	78.2	78.33	8215700.0
2002-10-08 12:00:00	SPY	ETF	78.26	79.69	78.2	79.6	8485100.0
2002-10-08 13:00:00	SPY	ETF	79.62	80.46	78.94	80.32	10229200.0
2002-10-08 14:00:00	SPY	ETF	80.34	81.31	80.1	80.94	14455400.0
2002-10-08 15:00:00	SPY	ETF	80.93	81.2	79.83	80.11	13742100.0
2002-10-08 16:00:00	SPY	ETF	80.17	80.58	79.85	80.46	2258800.0
2002-10-08 17:00:00	SPY	ETF	80.49	81.17	78.27	80.44	441500.0
2002-10-08 18:00:00	SPY	ETF	80.45	80.52	80.45	80.52	3700.0
2002-10-08 19:00:00	SPY	ETF	80.51	80.51	80.51	80.51	200.0
2002-10-08 08:00:00	QQQ	ETF	20.2	20.35	20.2	20.35	6800.0
2002-10-08 09:00:00	QQQ	ETF	20.35	20.42	20.05	20.06	11855200.0
2002-10-08 10:00:00	QQQ	ETF	20.09	20.32	20.0	20.04	12395000.0
2002-10-08 11:00:00	QQQ	ETF	20.04	20.05	19.77	19.78	10784000.0
2002-10-08 12:00:00	QQQ	ETF	19.78	20.19	19.76	20.12	9357800.0
2002-10-08 13:00:00	QQQ	ETF	20.15	20.35	19.93	20.29	10880800.0
2002-10-08 14:00:00	QQQ	ETF	20.3	20.61	20.15	20.46	18555900.0
2002-10-08 15:00:00	QQQ	ETF	20.46	20.58	20.12	20.16	13655800.0
2002-10-08 16:00:00	QQQ	ETF	20.18	20.25	20.11	20.18	1981300.0
2002-10-08 17:00:00	QQQ	ETF	20.19	20.22	20.15	20.18	68000.0
2002-10-08 18:00:00	QQQ	ETF	20.18	20.22	20.17	20.2	16100.0
2002-10-08 19:00:00	QQQ	ETF	20.22	20.24	20.22	20.24	2100.0
2002-10-08 09:00:00	IWM	ETF	34.255	34.255	33.755	33.82	93800.0
2002-10-08 10:00:00	IWM	ETF	33.83	33.93	33.6	33.66	389600.0
2002-10-08 11:00:00	IWM	ETF	33.66	33.66	33.29	33.29	388800.0
2002-10-08 12:00:00	IWM	ETF	33.28	33.49	33.225	33.49	656200.0
2002-10-08 13:00:00	IWM	ETF	33.52	33.775	33.38	33.75	983400.0
2002-10-08 14:00:00	IWM	ETF	33.75	34.05	33.7	33.975	394600.0
2002-10-08 15:00:00	IWM	ETF	34.0	34.01	33.74	33.9	595000.0
2002-10-08 16:00:00	IWM	ETF	33.925	34.02	33.885	33.96	218200.0
2002-10-08 17:00:00	IWM	ETF	33.915	33.915	33.915	33.915	1916400.0
2002-10-08 09:00:00	DIA	ETF	75.4	75.69	74.8	74.9	2122600.0
2002-10-08 10:00:00	DIA	ETF	74.84	75.49	74.51	74.72	2330700.0
2002-10-08 11:00:00	DIA	ETF	74.73	74.76	73.45	73.46	2641300.0
2002-10-08 12:00:00	DIA	ETF	73.46	74.94	73.4	74.8	2614000.0
2002-10-08 13:00:00	DIA	ETF	74.85	75.63	74.15	75.5	2995400.0
2002-10-08 14:00:00	DIA	ETF	75.53	76.5	75.25	76.08	3888400.0
2002-10-08 15:00:00	DIA	ETF	76.08	76.33	74.9	75.16	3745400.0
2002-10-08 16:00:00	DIA	ETF	75.15	75.52	74.77	75.45	126700.0
2002-10-08 17:00:00	DIA	ETF	75.45	75.51	75.45	75.45	1500.0
2002-10-08 18:00:00	DIA	ETF	75.62	75.62	75.62	75.62	100.0
2002-10-08 09:00:00	TLT	ETF	89.5	89.51	89.32	89.51	164800.0
2002-10-08 10:00:00	TLT	ETF	89.44	89.99	89.44	89.96	12800.0
2002-10-08 11:00:00	TLT	ETF	89.93	90.49	89.93	90.42	125200.0
2002-10-08 12:00:00	TLT	ETF	90.52	90.52	90.2	90.27	28300.0
2002-10-08 13:00:00	TLT	ETF	90.08	90.21	89.57	89.57	11500.0
2002-10-08 14:00:00	TLT	ETF	89.74	89.75	89.42	89.44	176700.0
2002-10-08 15:00:00	TLT	ETF	89.54	89.7	89.54	89.69	8500.0

> showing 50 of 367 rows — these rows as CSV

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