PREVIEW / etf_1hour / 2002-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-08-01.parquet
  size:    15 KB
  rows:    341

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-01 09:00:00	SPY	ETF	90.88	91.25	90.8	91.24	3213900.0
2002-08-01 10:00:00	SPY	ETF	91.25	91.25	89.5	89.77	10594700.0
2002-08-01 11:00:00	SPY	ETF	89.71	89.89	88.79	89.35	8450300.0
2002-08-01 12:00:00	SPY	ETF	89.38	89.61	88.91	89.59	4357300.0
2002-08-01 13:00:00	SPY	ETF	89.56	90.04	89.25	89.9	6093500.0
2002-08-01 14:00:00	SPY	ETF	89.9	89.97	89.05	89.31	6510200.0
2002-08-01 15:00:00	SPY	ETF	89.4	89.97	88.46	88.64	15317400.0
2002-08-01 16:00:00	SPY	ETF	88.59	88.78	88.33	88.78	2354000.0
2002-08-01 09:00:00	QQQ	ETF	23.74	23.9	23.66	23.85	9169900.0
2002-08-01 10:00:00	QQQ	ETF	23.86	23.87	23.17	23.23	20145800.0
2002-08-01 11:00:00	QQQ	ETF	23.22	23.28	22.95	23.13	12050700.0
2002-08-01 12:00:00	QQQ	ETF	23.14	23.22	22.97	23.15	6900100.0
2002-08-01 13:00:00	QQQ	ETF	23.13	23.22	23.0	23.17	5623200.0
2002-08-01 14:00:00	QQQ	ETF	23.16	23.18	22.88	22.99	8419500.0
2002-08-01 15:00:00	QQQ	ETF	22.99	23.16	22.66	22.7	16348500.0
2002-08-01 16:00:00	QQQ	ETF	22.71	22.79	22.67	22.73	1733200.0
2002-08-01 09:00:00	IWM	ETF	39.15	39.375	39.115	39.3	322000.0
2002-08-01 10:00:00	IWM	ETF	39.25	39.305	38.885	38.965	141400.0
2002-08-01 11:00:00	IWM	ETF	38.99	39.0	38.5	38.685	602400.0
2002-08-01 12:00:00	IWM	ETF	38.705	38.775	38.615	38.775	28200.0
2002-08-01 13:00:00	IWM	ETF	38.81	38.9	38.715	38.9	117200.0
2002-08-01 14:00:00	IWM	ETF	38.875	38.88	38.7	38.795	194400.0
2002-08-01 15:00:00	IWM	ETF	38.775	39.125	38.6	38.675	557000.0
2002-08-01 16:00:00	IWM	ETF	38.7	38.75	38.7	38.7	43600.0
2002-08-01 09:00:00	DIA	ETF	86.86	87.27	86.7	87.19	867100.0
2002-08-01 10:00:00	DIA	ETF	87.19	87.21	85.67	85.97	2735200.0
2002-08-01 11:00:00	DIA	ETF	85.99	86.1	85.1	85.68	2079900.0
2002-08-01 12:00:00	DIA	ETF	85.69	85.85	85.21	85.85	975300.0
2002-08-01 13:00:00	DIA	ETF	85.82	86.19	85.42	86.1	1321600.0
2002-08-01 14:00:00	DIA	ETF	86.07	86.12	85.22	85.61	1699400.0
2002-08-01 15:00:00	DIA	ETF	85.63	86.3	84.76	84.93	2610000.0
2002-08-01 16:00:00	DIA	ETF	84.91	85.09	84.84	84.87	171400.0
2002-08-01 09:00:00	TLT	ETF	82.54	82.58	82.54	82.54	1400.0
2002-08-01 10:00:00	TLT	ETF	82.68	82.94	82.68	82.78	2200.0
2002-08-01 11:00:00	TLT	ETF	82.82	83.02	82.82	83.0	2500.0
2002-08-01 12:00:00	TLT	ETF	82.94	83.0	82.92	82.92	700.0
2002-08-01 13:00:00	TLT	ETF	82.85	82.85	82.75	82.75	11800.0
2002-08-01 14:00:00	TLT	ETF	82.69	82.69	82.69	82.69	100.0
2002-08-01 15:00:00	TLT	ETF	82.92	83.0	82.82	83.0	6300.0

> showing 39 of 341 rows — these rows as CSV

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