PREVIEW / etf_1hour / 2002-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-08-09.parquet
  size:    15 KB
  rows:    337

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-09 09:00:00	SPY	ETF	90.1	90.23	89.35	89.61	4989500.0
2002-08-09 10:00:00	SPY	ETF	89.59	90.79	89.5	90.62	6585600.0
2002-08-09 11:00:00	SPY	ETF	90.6	91.4	90.43	91.2	6719200.0
2002-08-09 12:00:00	SPY	ETF	91.13	91.19	90.52	90.79	3175900.0
2002-08-09 13:00:00	SPY	ETF	90.76	91.37	90.3	91.2	4534100.0
2002-08-09 14:00:00	SPY	ETF	91.19	91.94	90.79	91.39	6722800.0
2002-08-09 15:00:00	SPY	ETF	91.39	91.85	91.0	91.24	6197600.0
2002-08-09 16:00:00	SPY	ETF	91.26	91.45	91.15	91.29	1563300.0
2002-08-09 09:00:00	QQQ	ETF	23.2	23.21	22.95	23.01	10962900.0
2002-08-09 10:00:00	QQQ	ETF	23.0	23.27	22.88	23.21	16582400.0
2002-08-09 11:00:00	QQQ	ETF	23.21	23.51	23.11	23.35	16170300.0
2002-08-09 12:00:00	QQQ	ETF	23.35	23.45	23.2	23.31	7809600.0
2002-08-09 13:00:00	QQQ	ETF	23.3	23.52	23.11	23.45	10161900.0
2002-08-09 14:00:00	QQQ	ETF	23.46	23.71	23.31	23.51	16157100.0
2002-08-09 15:00:00	QQQ	ETF	23.5	23.6	23.29	23.29	11741500.0
2002-08-09 16:00:00	QQQ	ETF	23.29	23.33	23.25	23.33	1088600.0
2002-08-09 09:00:00	IWM	ETF	38.3	38.485	38.22	38.22	268600.0
2002-08-09 10:00:00	IWM	ETF	38.35	38.645	38.31	38.62	101200.0
2002-08-09 11:00:00	IWM	ETF	38.65	38.935	38.56	38.885	106000.0
2002-08-09 12:00:00	IWM	ETF	38.805	38.845	38.69	38.715	40000.0
2002-08-09 13:00:00	IWM	ETF	38.715	38.83	38.59	38.77	226400.0
2002-08-09 14:00:00	IWM	ETF	38.77	38.975	38.65	38.805	317600.0
2002-08-09 15:00:00	IWM	ETF	38.815	39.095	38.635	38.66	824200.0
2002-08-09 16:00:00	IWM	ETF	38.555	38.555	38.505	38.505	5200.0
2002-08-09 09:00:00	DIA	ETF	86.55	86.73	85.82	86.04	1503500.0
2002-08-09 10:00:00	DIA	ETF	86.04	87.02	85.95	86.9	1969200.0
2002-08-09 11:00:00	DIA	ETF	86.87	87.54	86.59	87.25	1852600.0
2002-08-09 12:00:00	DIA	ETF	87.23	87.32	86.7	86.95	1036000.0
2002-08-09 13:00:00	DIA	ETF	86.93	87.6	86.48	87.43	1425000.0
2002-08-09 14:00:00	DIA	ETF	87.41	88.24	87.0	87.69	2490000.0
2002-08-09 15:00:00	DIA	ETF	87.67	88.1	87.16	87.51	1994500.0
2002-08-09 16:00:00	DIA	ETF	87.6	87.65	87.41	87.6	182300.0
2002-08-09 09:00:00	TLT	ETF	84.0	84.11	84.0	84.11	5200.0
2002-08-09 10:00:00	TLT	ETF	84.2	84.38	84.2	84.32	6100.0
2002-08-09 11:00:00	TLT	ETF	84.3	84.38	84.19	84.38	6500.0
2002-08-09 12:00:00	TLT	ETF	84.42	84.52	84.4	84.42	4000.0
2002-08-09 13:00:00	TLT	ETF	84.45	84.77	84.45	84.74	6400.0
2002-08-09 14:00:00	TLT	ETF	84.79	84.82	84.72	84.75	4700.0
2002-08-09 15:00:00	TLT	ETF	84.75	84.88	84.75	84.88	3000.0

> showing 39 of 337 rows — these rows as CSV

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