PREVIEW / etf_1hour / 2002-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-08-02.parquet
  size:    15 KB
  rows:    346

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-02 09:00:00	SPY	ETF	88.5	88.91	88.1	88.46	5773400.0
2002-08-02 10:00:00	SPY	ETF	88.46	88.8	87.5	87.82	7994600.0
2002-08-02 11:00:00	SPY	ETF	87.81	87.88	86.9	87.03	5403900.0
2002-08-02 12:00:00	SPY	ETF	87.0	87.03	86.15	86.35	7189800.0
2002-08-02 13:00:00	SPY	ETF	86.2	87.21	86.2	86.8	4948800.0
2002-08-02 14:00:00	SPY	ETF	86.81	86.9	86.2	86.53	6105100.0
2002-08-02 15:00:00	SPY	ETF	86.51	86.85	85.62	86.65	10760200.0
2002-08-02 16:00:00	SPY	ETF	86.61	86.88	86.49	86.79	1472400.0
2002-08-02 09:00:00	QQQ	ETF	22.78	22.84	22.47	22.63	9298200.0
2002-08-02 10:00:00	QQQ	ETF	22.63	22.74	22.27	22.35	16844700.0
2002-08-02 11:00:00	QQQ	ETF	22.36	22.4	22.04	22.09	14056000.0
2002-08-02 12:00:00	QQQ	ETF	22.09	22.1	21.91	21.94	10148400.0
2002-08-02 13:00:00	QQQ	ETF	21.94	22.26	21.9	22.1	6966500.0
2002-08-02 14:00:00	QQQ	ETF	22.09	22.17	21.93	22.1	7847600.0
2002-08-02 15:00:00	QQQ	ETF	22.06	22.25	21.82	22.19	16482800.0
2002-08-02 16:00:00	QQQ	ETF	22.21	22.27	22.15	22.25	929000.0
2002-08-02 09:00:00	IWM	ETF	38.625	38.675	38.465	38.6	148400.0
2002-08-02 10:00:00	IWM	ETF	38.47	38.65	37.91	38.0	366400.0
2002-08-02 11:00:00	IWM	ETF	38.05	38.1	37.84	37.905	206000.0
2002-08-02 12:00:00	IWM	ETF	37.82	37.85	37.54	37.54	203600.0
2002-08-02 13:00:00	IWM	ETF	37.6	37.75	37.55	37.675	980800.0
2002-08-02 14:00:00	IWM	ETF	37.675	37.675	37.54	37.59	246200.0
2002-08-02 15:00:00	IWM	ETF	37.56	37.75	37.43	37.75	403000.0
2002-08-02 16:00:00	IWM	ETF	37.675	37.7	37.485	37.485	97800.0
2002-08-02 09:00:00	DIA	ETF	84.7	85.07	84.47	84.95	999600.0
2002-08-02 10:00:00	DIA	ETF	84.91	85.15	83.9	84.2	2304000.0
2002-08-02 11:00:00	DIA	ETF	84.21	84.37	83.45	83.59	1826600.0
2002-08-02 12:00:00	DIA	ETF	83.45	83.52	82.65	82.84	1545000.0
2002-08-02 13:00:00	DIA	ETF	82.84	83.54	82.8	83.15	1451600.0
2002-08-02 14:00:00	DIA	ETF	83.15	83.24	82.52	82.78	1646700.0
2002-08-02 15:00:00	DIA	ETF	82.8	83.26	82.03	83.16	2854900.0
2002-08-02 16:00:00	DIA	ETF	82.97	83.23	82.95	83.2	143700.0
2002-08-02 09:00:00	TLT	ETF	83.16	83.16	83.09	83.09	4200.0
2002-08-02 10:00:00	TLT	ETF	82.88	83.19	82.88	83.19	3500.0
2002-08-02 11:00:00	TLT	ETF	83.22	83.34	83.17	83.34	1900.0
2002-08-02 12:00:00	TLT	ETF	83.49	83.94	83.43	83.94	6200.0
2002-08-02 13:00:00	TLT	ETF	83.82	83.88	83.55	83.77	18800.0
2002-08-02 14:00:00	TLT	ETF	83.72	83.96	83.72	83.92	11600.0
2002-08-02 15:00:00	TLT	ETF	84.0	84.1	83.85	83.85	6600.0

> showing 39 of 346 rows — these rows as CSV

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