PREVIEW / etf_1hour / 2002-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-08-20.parquet
  size:    15 KB
  rows:    354

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-20 09:00:00	SPY	ETF	94.82	95.02	94.2	94.6	5489900.0
2002-08-20 10:00:00	SPY	ETF	94.58	94.67	94.02	94.6	4925300.0
2002-08-20 11:00:00	SPY	ETF	94.6	94.9	93.76	94.03	5447900.0
2002-08-20 12:00:00	SPY	ETF	94.03	94.25	93.85	94.07	2202000.0
2002-08-20 13:00:00	SPY	ETF	94.09	94.34	93.62	94.34	2915900.0
2002-08-20 14:00:00	SPY	ETF	94.35	94.62	93.93	94.56	3372000.0
2002-08-20 15:00:00	SPY	ETF	94.56	94.83	94.01	94.27	4389700.0
2002-08-20 16:00:00	SPY	ETF	94.27	94.48	94.14	94.39	843200.0
2002-08-20 09:00:00	QQQ	ETF	25.18	25.28	24.95	25.07	13225300.0
2002-08-20 10:00:00	QQQ	ETF	25.07	25.31	25.0	25.31	16331500.0
2002-08-20 11:00:00	QQQ	ETF	25.3	25.43	25.03	25.14	13380300.0
2002-08-20 12:00:00	QQQ	ETF	25.14	25.2	25.04	25.13	5754400.0
2002-08-20 13:00:00	QQQ	ETF	25.14	25.2	24.85	25.2	15888300.0
2002-08-20 14:00:00	QQQ	ETF	25.19	25.26	25.0	25.23	8557500.0
2002-08-20 15:00:00	QQQ	ETF	25.22	25.28	24.95	25.1	12654400.0
2002-08-20 16:00:00	QQQ	ETF	25.1	25.19	25.08	25.19	639300.0
2002-08-20 09:00:00	IWM	ETF	39.905	39.945	39.595	39.725	246400.0
2002-08-20 10:00:00	IWM	ETF	39.67	39.83	39.65	39.83	334200.0
2002-08-20 11:00:00	IWM	ETF	39.82	39.9	39.56	39.685	373200.0
2002-08-20 12:00:00	IWM	ETF	39.68	39.72	39.575	39.7	314800.0
2002-08-20 13:00:00	IWM	ETF	39.675	39.7	39.525	39.7	129800.0
2002-08-20 14:00:00	IWM	ETF	39.64	39.8	39.585	39.785	254600.0
2002-08-20 15:00:00	IWM	ETF	39.8	39.925	39.6	39.6	664600.0
2002-08-20 16:00:00	IWM	ETF	39.825	39.825	39.825	39.825	200.0
2002-08-20 09:00:00	DIA	ETF	89.32	89.64	88.8	89.18	1547500.0
2002-08-20 10:00:00	DIA	ETF	89.18	89.23	88.65	89.15	2219600.0
2002-08-20 11:00:00	DIA	ETF	89.19	89.5	88.38	88.6	1807000.0
2002-08-20 12:00:00	DIA	ETF	88.54	88.85	88.41	88.66	525300.0
2002-08-20 13:00:00	DIA	ETF	88.65	88.95	88.25	88.94	878400.0
2002-08-20 14:00:00	DIA	ETF	88.96	89.1	88.45	89.06	858500.0
2002-08-20 15:00:00	DIA	ETF	89.06	89.35	88.62	88.79	2057500.0
2002-08-20 16:00:00	DIA	ETF	88.8	89.0	88.63	89.0	38100.0
2002-08-20 09:00:00	TLT	ETF	85.62	85.7	85.6	85.67	4500.0
2002-08-20 10:00:00	TLT	ETF	85.77	85.87	85.7	85.7	11900.0
2002-08-20 11:00:00	TLT	ETF	85.72	85.87	85.62	85.82	2200.0
2002-08-20 12:00:00	TLT	ETF	85.8	86.11	85.8	86.05	8000.0
2002-08-20 13:00:00	TLT	ETF	86.12	86.22	86.08	86.08	4100.0
2002-08-20 14:00:00	TLT	ETF	86.12	86.2	86.1	86.2	7500.0
2002-08-20 15:00:00	TLT	ETF	86.2	86.29	86.2	86.27	2600.0

> showing 39 of 354 rows — these rows as CSV

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