PREVIEW / etf_1hour / 2002-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-09-20.parquet
  size:    15 KB
  rows:    348

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-09-20 09:00:00	SPY	ETF	84.92	85.2	84.55	84.65	5690200.0
2002-09-20 10:00:00	SPY	ETF	84.57	84.96	84.07	84.21	9869200.0
2002-09-20 11:00:00	SPY	ETF	84.22	84.68	84.05	84.38	3918100.0
2002-09-20 12:00:00	SPY	ETF	84.39	85.0	84.31	84.78	4369200.0
2002-09-20 13:00:00	SPY	ETF	84.78	85.0	84.56	84.69	2364600.0
2002-09-20 14:00:00	SPY	ETF	84.68	84.8	84.17	84.56	3569000.0
2002-09-20 15:00:00	SPY	ETF	84.61	85.14	84.25	84.66	6612800.0
2002-09-20 16:00:00	SPY	ETF	84.73	84.73	84.35	84.35	1661400.0
2002-09-20 09:00:00	QQQ	ETF	21.83	21.9	21.53	21.62	14703300.0
2002-09-20 10:00:00	QQQ	ETF	21.62	21.79	21.48	21.55	20430600.0
2002-09-20 11:00:00	QQQ	ETF	21.54	21.72	21.51	21.63	7525100.0
2002-09-20 12:00:00	QQQ	ETF	21.64	21.85	21.61	21.8	7798000.0
2002-09-20 13:00:00	QQQ	ETF	21.77	21.83	21.61	21.65	4832600.0
2002-09-20 14:00:00	QQQ	ETF	21.66	21.74	21.53	21.68	8408100.0
2002-09-20 15:00:00	QQQ	ETF	21.68	21.79	21.56	21.65	9885400.0
2002-09-20 16:00:00	QQQ	ETF	21.61	21.7	21.61	21.67	1443800.0
2002-09-20 09:00:00	IWM	ETF	36.875	36.965	36.4	36.64	312800.0
2002-09-20 10:00:00	IWM	ETF	36.625	36.715	36.455	36.48	278000.0
2002-09-20 11:00:00	IWM	ETF	36.525	36.6	36.46	36.5	236200.0
2002-09-20 12:00:00	IWM	ETF	36.49	36.615	36.485	36.535	79000.0
2002-09-20 13:00:00	IWM	ETF	36.575	36.605	36.495	36.515	71600.0
2002-09-20 14:00:00	IWM	ETF	36.49	36.53	36.4	36.53	155400.0
2002-09-20 15:00:00	IWM	ETF	36.465	36.68	36.455	36.565	337000.0
2002-09-20 16:00:00	IWM	ETF	36.55	36.55	36.55	36.55	600.0
2002-09-20 09:00:00	DIA	ETF	79.88	80.08	79.5	79.65	1644800.0
2002-09-20 10:00:00	DIA	ETF	79.6	80.05	79.23	79.36	1921400.0
2002-09-20 11:00:00	DIA	ETF	79.37	79.79	79.2	79.59	1022700.0
2002-09-20 12:00:00	DIA	ETF	79.56	80.09	79.5	79.9	1042400.0
2002-09-20 13:00:00	DIA	ETF	79.87	80.08	79.67	79.83	783300.0
2002-09-20 14:00:00	DIA	ETF	79.83	79.94	79.34	79.72	941000.0
2002-09-20 15:00:00	DIA	ETF	79.73	80.25	79.45	79.84	1612800.0
2002-09-20 16:00:00	DIA	ETF	79.82	79.94	79.58	79.67	113800.0
2002-09-20 09:00:00	TLT	ETF	89.45	89.45	89.18	89.28	74700.0
2002-09-20 10:00:00	TLT	ETF	89.35	89.52	89.18	89.45	20200.0
2002-09-20 11:00:00	TLT	ETF	89.36	89.5	89.2	89.22	1400.0
2002-09-20 12:00:00	TLT	ETF	89.2	89.22	89.06	89.06	1200.0
2002-09-20 13:00:00	TLT	ETF	89.2	89.29	89.2	89.29	1600.0
2002-09-20 14:00:00	TLT	ETF	89.36	89.36	89.26	89.26	200.0
2002-09-20 15:00:00	TLT	ETF	89.29	89.35	89.29	89.3	14200.0

> showing 39 of 348 rows — these rows as CSV

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