PREVIEW / etf_1hour / 2002-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-08-07.parquet
  size:    15 KB
  rows:    338

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-08-07 09:00:00	SPY	ETF	87.87	88.5	86.6	86.95	6511200.0
2002-08-07 10:00:00	SPY	ETF	86.88	87.35	86.67	86.85	5714800.0
2002-08-07 11:00:00	SPY	ETF	86.83	86.95	86.18	86.64	5584300.0
2002-08-07 12:00:00	SPY	ETF	86.64	86.79	86.3	86.68	2201000.0
2002-08-07 13:00:00	SPY	ETF	86.62	86.7	85.9	86.14	3084000.0
2002-08-07 14:00:00	SPY	ETF	86.13	87.05	85.77	86.77	5390800.0
2002-08-07 15:00:00	SPY	ETF	86.8	88.25	86.61	88.17	9967700.0
2002-08-07 16:00:00	SPY	ETF	88.2	88.27	88.01	88.1	1929700.0
2002-08-07 09:00:00	QQQ	ETF	23.2	23.37	22.74	22.86	23471500.0
2002-08-07 10:00:00	QQQ	ETF	22.83	22.99	22.58	22.62	16901800.0
2002-08-07 11:00:00	QQQ	ETF	22.63	22.63	22.3	22.44	14789400.0
2002-08-07 12:00:00	QQQ	ETF	22.45	22.46	22.25	22.36	6585600.0
2002-08-07 13:00:00	QQQ	ETF	22.37	22.38	21.96	22.09	10344800.0
2002-08-07 14:00:00	QQQ	ETF	22.09	22.65	21.97	22.5	17372300.0
2002-08-07 15:00:00	QQQ	ETF	22.53	22.97	22.4	22.84	28507700.0
2002-08-07 16:00:00	QQQ	ETF	22.84	22.88	22.78	22.8	985000.0
2002-08-07 09:00:00	IWM	ETF	38.375	38.675	37.875	37.97	419200.0
2002-08-07 10:00:00	IWM	ETF	37.9	38.1	37.795	37.845	279800.0
2002-08-07 11:00:00	IWM	ETF	37.725	37.795	37.445	37.77	775200.0
2002-08-07 12:00:00	IWM	ETF	37.685	37.775	37.64	37.64	126000.0
2002-08-07 13:00:00	IWM	ETF	37.69	37.7	37.425	37.505	37600.0
2002-08-07 14:00:00	IWM	ETF	37.55	37.945	37.405	37.825	411000.0
2002-08-07 15:00:00	IWM	ETF	37.805	38.45	37.805	38.25	1080800.0
2002-08-07 16:00:00	IWM	ETF	38.225	38.225	38.22	38.22	11000.0
2002-08-07 09:00:00	DIA	ETF	84.01	84.85	82.8	83.13	2491200.0
2002-08-07 10:00:00	DIA	ETF	83.16	83.64	82.9	83.19	1706600.0
2002-08-07 11:00:00	DIA	ETF	83.22	83.37	82.51	83.03	1427000.0
2002-08-07 12:00:00	DIA	ETF	83.06	83.33	82.75	83.08	536400.0
2002-08-07 13:00:00	DIA	ETF	83.1	83.14	82.43	82.7	1322400.0
2002-08-07 14:00:00	DIA	ETF	82.76	83.67	82.25	83.27	2203200.0
2002-08-07 15:00:00	DIA	ETF	83.27	84.8	83.1	84.68	2660000.0
2002-08-07 16:00:00	DIA	ETF	84.75	84.75	84.58	84.65	83700.0
2002-08-07 09:00:00	TLT	ETF	83.6	83.66	83.36	83.66	5000.0
2002-08-07 10:00:00	TLT	ETF	83.58	83.81	83.58	83.8	3400.0
2002-08-07 11:00:00	TLT	ETF	83.91	84.14	83.85	83.85	9100.0
2002-08-07 12:00:00	TLT	ETF	84.0	84.01	83.71	83.86	4100.0
2002-08-07 13:00:00	TLT	ETF	83.6	83.66	83.48	83.66	8100.0
2002-08-07 14:00:00	TLT	ETF	83.87	84.04	83.85	83.85	5500.0
2002-08-07 15:00:00	TLT	ETF	83.91	83.95	83.64	83.7	5100.0

> showing 39 of 338 rows — these rows as CSV

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