PREVIEW / etf_1hour / 2002-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-08-06.parquet
  size:    15 KB
  rows:    349

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-06 09:00:00	SPY	ETF	85.23	86.16	85.11	85.75	7940000.0
2002-08-06 10:00:00	SPY	ETF	85.76	87.45	85.76	86.91	15995900.0
2002-08-06 11:00:00	SPY	ETF	86.91	87.39	86.71	87.16	6305200.0
2002-08-06 12:00:00	SPY	ETF	87.19	87.76	85.5	87.4	5133000.0
2002-08-06 13:00:00	SPY	ETF	87.38	87.58	87.05	87.23	4304000.0
2002-08-06 14:00:00	SPY	ETF	87.21	87.84	86.9	87.69	5860100.0
2002-08-06 15:00:00	SPY	ETF	87.75	87.9	86.07	86.4	11359600.0
2002-08-06 16:00:00	SPY	ETF	86.35	86.59	86.25	86.59	1825900.0
2002-08-06 09:00:00	QQQ	ETF	21.8	22.04	21.8	21.94	12240500.0
2002-08-06 10:00:00	QQQ	ETF	21.94	22.56	21.93	22.38	21324800.0
2002-08-06 11:00:00	QQQ	ETF	22.39	22.65	22.36	22.54	10442400.0
2002-08-06 12:00:00	QQQ	ETF	22.51	22.8	21.83	22.67	9022600.0
2002-08-06 13:00:00	QQQ	ETF	22.67	22.76	22.54	22.7	9683500.0
2002-08-06 14:00:00	QQQ	ETF	22.71	22.97	22.55	22.95	12304000.0
2002-08-06 15:00:00	QQQ	ETF	22.95	23.01	22.26	22.43	27154900.0
2002-08-06 16:00:00	QQQ	ETF	22.43	22.55	22.4	22.5	1302000.0
2002-08-06 09:00:00	IWM	ETF	37.15	37.425	37.0	37.2	103800.0
2002-08-06 10:00:00	IWM	ETF	37.26	37.975	37.26	37.765	519800.0
2002-08-06 11:00:00	IWM	ETF	37.805	37.985	37.8	37.875	172400.0
2002-08-06 12:00:00	IWM	ETF	37.885	37.92	37.8	37.92	123000.0
2002-08-06 13:00:00	IWM	ETF	37.855	37.905	37.765	37.855	77600.0
2002-08-06 14:00:00	IWM	ETF	37.775	37.895	37.705	37.895	154200.0
2002-08-06 15:00:00	IWM	ETF	37.905	37.93	37.635	37.93	319000.0
2002-08-06 16:00:00	IWM	ETF	37.925	38.075	37.925	38.075	14400.0
2002-08-06 09:00:00	DIA	ETF	82.05	82.75	81.85	82.25	1629800.0
2002-08-06 10:00:00	DIA	ETF	82.27	84.0	82.23	83.44	3085600.0
2002-08-06 11:00:00	DIA	ETF	83.46	83.95	83.23	83.75	1276400.0
2002-08-06 12:00:00	DIA	ETF	83.74	84.25	83.55	83.91	871300.0
2002-08-06 13:00:00	DIA	ETF	83.94	84.07	83.47	83.67	975200.0
2002-08-06 14:00:00	DIA	ETF	83.64	84.25	83.28	84.15	1545200.0
2002-08-06 15:00:00	DIA	ETF	84.17	84.33	82.52	83.0	2320100.0
2002-08-06 16:00:00	DIA	ETF	82.97	83.09	82.86	83.0	78700.0
2002-08-06 09:00:00	TLT	ETF	83.8	83.9	83.72	83.9	4800.0
2002-08-06 10:00:00	TLT	ETF	83.76	83.76	83.5	83.56	13600.0
2002-08-06 11:00:00	TLT	ETF	83.6	83.62	83.49	83.56	3700.0
2002-08-06 12:00:00	TLT	ETF	83.6	83.6	83.37	83.37	2900.0
2002-08-06 13:00:00	TLT	ETF	83.5	83.5	83.22	83.4	9300.0
2002-08-06 14:00:00	TLT	ETF	83.4	83.5	83.25	83.25	15300.0
2002-08-06 15:00:00	TLT	ETF	83.24	83.59	83.24	83.5	15300.0

> showing 39 of 349 rows — these rows as CSV

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