PREVIEW / etf_1hour / 2002-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-07.parquet
  size:    15 KB
  rows:    361

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-07 08:00:00	SPY	ETF	80.09	80.52	80.06	80.52	3300.0
2002-10-07 09:00:00	SPY	ETF	80.6	80.95	79.75	80.05	6929000.0
2002-10-07 10:00:00	SPY	ETF	80.14	80.75	79.75	80.03	7144800.0
2002-10-07 11:00:00	SPY	ETF	80.01	80.52	79.4	80.3	6894100.0
2002-10-07 12:00:00	SPY	ETF	80.3	81.2	80.1	80.2	6489800.0
2002-10-07 13:00:00	SPY	ETF	80.2	80.5	79.83	80.17	4515500.0
2002-10-07 14:00:00	SPY	ETF	80.17	80.23	79.46	79.64	4757800.0
2002-10-07 15:00:00	SPY	ETF	79.68	79.68	78.55	78.82	10157500.0
2002-10-07 16:00:00	SPY	ETF	78.89	79.24	78.79	79.14	3342300.0
2002-10-07 17:00:00	SPY	ETF	79.16	81.0	78.65	79.13	58600.0
2002-10-07 18:00:00	SPY	ETF	79.13	79.19	79.11	79.16	7200.0
2002-10-07 08:00:00	QQQ	ETF	20.15	20.23	20.15	20.23	6000.0
2002-10-07 09:00:00	QQQ	ETF	20.25	20.47	20.08	20.24	8453700.0
2002-10-07 10:00:00	QQQ	ETF	20.23	20.4	20.09	20.23	12695600.0
2002-10-07 11:00:00	QQQ	ETF	20.23	20.33	20.03	20.27	10092700.0
2002-10-07 12:00:00	QQQ	ETF	20.25	20.59	20.22	20.33	13413500.0
2002-10-07 13:00:00	QQQ	ETF	20.33	20.44	20.23	20.36	4639700.0
2002-10-07 14:00:00	QQQ	ETF	20.35	20.39	20.11	20.17	8238100.0
2002-10-07 15:00:00	QQQ	ETF	20.17	20.19	19.85	19.99	16719000.0
2002-10-07 16:00:00	QQQ	ETF	20.01	20.26	19.9	20.13	3928300.0
2002-10-07 17:00:00	QQQ	ETF	20.12	20.22	20.12	20.18	164200.0
2002-10-07 18:00:00	QQQ	ETF	20.18	20.2	20.11	20.15	16300.0
2002-10-07 19:00:00	QQQ	ETF	20.18	20.2	20.16	20.2	9900.0
2002-10-07 09:00:00	IWM	ETF	34.475	34.8	34.4	34.435	412000.0
2002-10-07 10:00:00	IWM	ETF	34.45	34.485	34.14	34.185	789200.0
2002-10-07 11:00:00	IWM	ETF	34.195	34.265	34.0	34.255	288600.0
2002-10-07 12:00:00	IWM	ETF	34.265	34.385	34.175	34.175	222800.0
2002-10-07 13:00:00	IWM	ETF	34.185	34.225	34.07	34.07	86600.0
2002-10-07 14:00:00	IWM	ETF	34.085	34.105	33.845	33.845	290000.0
2002-10-07 15:00:00	IWM	ETF	33.89	33.89	33.55	33.745	348000.0
2002-10-07 16:00:00	IWM	ETF	33.805	33.85	33.685	33.745	236200.0
2002-10-07 17:00:00	IWM	ETF	33.72	33.72	33.72	33.72	207400.0
2002-10-07 08:00:00	DIA	ETF	75.0	75.51	75.0	75.5	2000.0
2002-10-07 09:00:00	DIA	ETF	75.46	76.22	75.0	75.48	1643000.0
2002-10-07 10:00:00	DIA	ETF	75.47	76.1	75.0	75.27	2256900.0
2002-10-07 11:00:00	DIA	ETF	75.24	75.97	74.7	75.71	1812900.0
2002-10-07 12:00:00	DIA	ETF	75.69	76.65	75.51	75.6	1656000.0
2002-10-07 13:00:00	DIA	ETF	75.54	75.84	75.26	75.62	1179900.0
2002-10-07 14:00:00	DIA	ETF	75.64	75.68	74.95	75.13	1240500.0
2002-10-07 15:00:00	DIA	ETF	75.13	75.18	74.14	74.46	2866000.0
2002-10-07 16:00:00	DIA	ETF	74.45	74.8	74.35	74.7	256900.0
2002-10-07 17:00:00	DIA	ETF	74.72	74.72	74.72	74.72	300.0
2002-10-07 18:00:00	DIA	ETF	74.72	74.75	74.65	74.68	1400.0
2002-10-07 09:00:00	TLT	ETF	89.9	89.9	89.65	89.86	4200.0
2002-10-07 10:00:00	TLT	ETF	89.81	89.96	89.7	89.96	208400.0
2002-10-07 11:00:00	TLT	ETF	89.95	89.95	89.8	89.87	102900.0
2002-10-07 12:00:00	TLT	ETF	89.8	89.8	89.46	89.52	104700.0
2002-10-07 13:00:00	TLT	ETF	89.71	89.71	89.57	89.57	1600.0
2002-10-07 14:00:00	TLT	ETF	89.62	89.71	89.59	89.71	1300.0
2002-10-07 15:00:00	TLT	ETF	89.74	89.87	89.61	89.81	8800.0

> showing 50 of 361 rows — these rows as CSV

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