PREVIEW / etf_1hour / 2002-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-23.parquet
  size:    16 KB
  rows:    367

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-23 09:00:00	SPY	ETF	88.77	89.5	88.58	89.25	5951200.0
2002-10-23 10:00:00	SPY	ETF	89.3	89.31	87.95	88.29	9250500.0
2002-10-23 11:00:00	SPY	ETF	88.28	88.45	87.77	87.8	5513400.0
2002-10-23 12:00:00	SPY	ETF	87.88	88.26	87.68	88.26	4854500.0
2002-10-23 13:00:00	SPY	ETF	88.25	88.38	87.95	88.37	2842500.0
2002-10-23 14:00:00	SPY	ETF	88.37	89.75	87.9	89.45	10144200.0
2002-10-23 15:00:00	SPY	ETF	89.41	89.99	89.0	89.97	9059500.0
2002-10-23 16:00:00	SPY	ETF	89.93	90.5	89.91	90.36	3268000.0
2002-10-23 17:00:00	SPY	ETF	90.36	90.45	87.97	90.45	142700.0
2002-10-23 18:00:00	SPY	ETF	90.45	90.49	90.43	90.43	15200.0
2002-10-23 19:00:00	SPY	ETF	90.55	90.55	90.55	90.55	1000.0
2002-10-23 08:00:00	QQQ	ETF	23.81	23.81	23.8	23.81	4300.0
2002-10-23 09:00:00	QQQ	ETF	23.81	24.2	23.8	24.06	12246100.0
2002-10-23 10:00:00	QQQ	ETF	24.08	24.11	23.69	23.88	12756400.0
2002-10-23 11:00:00	QQQ	ETF	23.89	23.94	23.7	23.73	5801800.0
2002-10-23 12:00:00	QQQ	ETF	23.73	23.96	23.67	23.95	6578100.0
2002-10-23 13:00:00	QQQ	ETF	23.95	24.08	23.82	24.07	8008600.0
2002-10-23 14:00:00	QQQ	ETF	24.07	24.56	23.9	24.45	19972000.0
2002-10-23 15:00:00	QQQ	ETF	24.45	24.63	23.81	24.59	18132300.0
2002-10-23 16:00:00	QQQ	ETF	24.58	24.78	24.51	24.7	2311200.0
2002-10-23 17:00:00	QQQ	ETF	24.71	24.76	24.3	24.75	374700.0
2002-10-23 18:00:00	QQQ	ETF	24.75	24.75	24.7	24.73	49100.0
2002-10-23 19:00:00	QQQ	ETF	24.75	24.75	24.75	24.75	600.0
2002-10-23 09:00:00	IWM	ETF	36.0	36.37	35.855	36.275	380400.0
2002-10-23 10:00:00	IWM	ETF	36.315	36.315	35.825	35.855	649400.0
2002-10-23 11:00:00	IWM	ETF	35.875	36.01	35.815	35.86	197400.0
2002-10-23 12:00:00	IWM	ETF	35.8	36.05	35.8	36.05	175200.0
2002-10-23 13:00:00	IWM	ETF	36.05	36.175	36.01	36.175	117000.0
2002-10-23 14:00:00	IWM	ETF	36.175	36.7	36.105	36.59	669600.0
2002-10-23 15:00:00	IWM	ETF	36.635	36.87	36.545	36.815	549800.0
2002-10-23 16:00:00	IWM	ETF	36.75	36.84	36.73	36.78	882800.0
2002-10-23 09:00:00	DIA	ETF	84.08	84.94	83.9	84.75	1182400.0
2002-10-23 10:00:00	DIA	ETF	84.7	84.75	83.39	83.66	2357700.0
2002-10-23 11:00:00	DIA	ETF	83.66	83.8	83.12	83.17	1583500.0
2002-10-23 12:00:00	DIA	ETF	83.16	83.56	83.0	83.53	1086400.0
2002-10-23 13:00:00	DIA	ETF	83.55	83.6	83.22	83.55	780300.0
2002-10-23 14:00:00	DIA	ETF	83.51	84.85	83.3	84.55	2337500.0
2002-10-23 15:00:00	DIA	ETF	84.55	85.02	84.05	85.0	2155700.0
2002-10-23 16:00:00	DIA	ETF	85.0	85.63	84.94	85.5	341200.0
2002-10-23 17:00:00	DIA	ETF	85.54	85.7	85.39	85.51	7400.0
2002-10-23 19:00:00	DIA	ETF	85.63	85.63	85.63	85.63	400.0
2002-10-23 09:00:00	TLT	ETF	84.75	84.75	84.41	84.46	16700.0
2002-10-23 10:00:00	TLT	ETF	84.55	84.8	84.55	84.8	24500.0
2002-10-23 11:00:00	TLT	ETF	84.86	85.2	84.7	85.2	6600.0
2002-10-23 12:00:00	TLT	ETF	85.17	85.17	84.87	84.87	26300.0
2002-10-23 13:00:00	TLT	ETF	84.82	85.08	84.78	84.91	7500.0
2002-10-23 14:00:00	TLT	ETF	84.99	84.99	84.18	84.23	30400.0
2002-10-23 15:00:00	TLT	ETF	84.34	84.53	84.33	84.33	15800.0

> showing 48 of 367 rows — these rows as CSV

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