PREVIEW / etf_1hour / 2002-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-02.parquet
  size:    16 KB
  rows:    357

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-02 08:00:00	SPY	ETF	85.18	85.18	84.75	84.87	22200.0
2002-10-02 09:00:00	SPY	ETF	84.9	85.24	84.09	84.11	6427800.0
2002-10-02 10:00:00	SPY	ETF	84.11	84.71	83.8	84.3	8866600.0
2002-10-02 11:00:00	SPY	ETF	84.31	85.19	84.1	85.09	5982900.0
2002-10-02 12:00:00	SPY	ETF	85.09	85.53	84.75	85.1	5728900.0
2002-10-02 13:00:00	SPY	ETF	85.08	85.36	84.35	84.58	4326700.0
2002-10-02 14:00:00	SPY	ETF	84.55	84.67	83.95	84.13	5220600.0
2002-10-02 15:00:00	SPY	ETF	84.13	84.45	82.6	83.05	14646700.0
2002-10-02 16:00:00	SPY	ETF	83.05	83.59	83.01	83.05	3094100.0
2002-10-02 17:00:00	SPY	ETF	83.05	83.92	83.0	83.02	177400.0
2002-10-02 18:00:00	SPY	ETF	83.06	83.07	82.92	83.07	4100.0
2002-10-02 08:00:00	QQQ	ETF	21.8	21.8	21.58	21.58	37800.0
2002-10-02 09:00:00	QQQ	ETF	21.6	21.74	21.41	21.42	9857300.0
2002-10-02 10:00:00	QQQ	ETF	21.42	21.59	21.26	21.41	17097600.0
2002-10-02 11:00:00	QQQ	ETF	21.39	21.74	21.35	21.7	10340400.0
2002-10-02 12:00:00	QQQ	ETF	21.7	21.97	21.6	21.84	10814600.0
2002-10-02 13:00:00	QQQ	ETF	21.85	21.92	21.53	21.56	8260000.0
2002-10-02 14:00:00	QQQ	ETF	21.56	21.58	21.24	21.43	15853300.0
2002-10-02 15:00:00	QQQ	ETF	21.42	21.49	20.97	21.16	17337300.0
2002-10-02 16:00:00	QQQ	ETF	21.16	21.27	20.9	21.1	3722400.0
2002-10-02 17:00:00	QQQ	ETF	21.13	21.25	21.08	21.11	377300.0
2002-10-02 18:00:00	QQQ	ETF	21.11	21.16	21.1	21.11	31700.0
2002-10-02 19:00:00	QQQ	ETF	21.11	21.16	21.11	21.16	2700.0
2002-10-02 09:00:00	IWM	ETF	36.575	36.62	36.4	36.485	67600.0
2002-10-02 10:00:00	IWM	ETF	36.465	36.605	36.225	36.46	312400.0
2002-10-02 11:00:00	IWM	ETF	36.45	36.725	36.37	36.725	167800.0
2002-10-02 12:00:00	IWM	ETF	36.725	36.865	36.62	36.785	183800.0
2002-10-02 13:00:00	IWM	ETF	36.86	36.86	36.575	36.6	152800.0
2002-10-02 14:00:00	IWM	ETF	36.615	36.615	36.35	36.51	365200.0
2002-10-02 15:00:00	IWM	ETF	36.51	36.53	35.9	36.0	781200.0
2002-10-02 16:00:00	IWM	ETF	36.0	36.205	36.0	36.025	62000.0
2002-10-02 18:00:00	IWM	ETF	35.89	35.89	35.89	35.89	1393000.0
2002-10-02 09:00:00	DIA	ETF	79.16	79.39	78.35	78.35	1636600.0
2002-10-02 10:00:00	DIA	ETF	78.44	79.07	78.14	78.7	2275300.0
2002-10-02 11:00:00	DIA	ETF	78.7	79.46	78.48	79.4	1372900.0
2002-10-02 12:00:00	DIA	ETF	79.4	79.88	79.11	79.49	1795200.0
2002-10-02 13:00:00	DIA	ETF	79.45	79.72	78.75	78.89	1658500.0
2002-10-02 14:00:00	DIA	ETF	78.97	79.09	78.44	78.73	1271600.0
2002-10-02 15:00:00	DIA	ETF	78.72	78.98	77.3	77.78	3126600.0
2002-10-02 16:00:00	DIA	ETF	77.78	78.08	77.65	77.72	242300.0
2002-10-02 17:00:00	DIA	ETF	77.8	77.95	77.7	77.79	6200.0
2002-10-02 18:00:00	DIA	ETF	77.79	77.9	77.7	77.7	1000.0
2002-10-02 19:00:00	DIA	ETF	77.41	77.41	77.41	77.41	200.0
2002-10-02 09:00:00	TLT	ETF	89.24	89.43	89.24	89.4	14900.0
2002-10-02 10:00:00	TLT	ETF	89.3	89.35	88.98	89.0	11000.0
2002-10-02 11:00:00	TLT	ETF	89.12	89.22	88.98	88.98	2500.0
2002-10-02 12:00:00	TLT	ETF	88.93	89.07	88.84	88.96	8300.0
2002-10-02 13:00:00	TLT	ETF	88.96	89.14	88.87	89.14	14400.0
2002-10-02 14:00:00	TLT	ETF	89.12	89.33	89.12	89.2	5700.0
2002-10-02 15:00:00	TLT	ETF	89.23	89.48	89.23	89.45	34200.0

> showing 50 of 357 rows — these rows as CSV

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