PREVIEW / etf_1hour / 2002-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-07-31.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-07-31 09:00:00	SPY	ETF	90.49	90.85	90.03	90.31	4315100.0
2002-07-31 10:00:00	SPY	ETF	90.3	90.36	89.25	89.48	7853200.0
2002-07-31 11:00:00	SPY	ETF	89.48	90.23	89.38	90.1	4589900.0
2002-07-31 12:00:00	SPY	ETF	90.1	90.55	89.9	90.32	4214500.0
2002-07-31 13:00:00	SPY	ETF	90.41	90.41	89.6	89.72	3334300.0
2002-07-31 14:00:00	SPY	ETF	89.72	90.08	89.37	89.78	4430300.0
2002-07-31 15:00:00	SPY	ETF	89.76	91.45	89.5	91.38	8557100.0
2002-07-31 16:00:00	SPY	ETF	91.39	91.55	91.16	91.16	2358300.0
2002-07-31 09:00:00	QQQ	ETF	24.0	24.19	23.88	23.88	11645000.0
2002-07-31 10:00:00	QQQ	ETF	23.9	23.95	23.5	23.66	22544800.0
2002-07-31 11:00:00	QQQ	ETF	23.64	23.84	23.58	23.77	9657800.0
2002-07-31 12:00:00	QQQ	ETF	23.77	23.92	23.64	23.77	6615700.0
2002-07-31 13:00:00	QQQ	ETF	23.77	23.8	23.44	23.5	8390300.0
2002-07-31 14:00:00	QQQ	ETF	23.51	23.67	23.36	23.5	10855400.0
2002-07-31 15:00:00	QQQ	ETF	23.48	23.92	23.42	23.89	16411900.0
2002-07-31 16:00:00	QQQ	ETF	23.9	23.93	23.81	23.85	1176300.0
2002-07-31 09:00:00	IWM	ETF	39.895	39.95	39.68	39.75	141800.0
2002-07-31 10:00:00	IWM	ETF	39.665	39.85	39.175	39.3	261200.0
2002-07-31 11:00:00	IWM	ETF	39.23	39.445	39.18	39.445	167200.0
2002-07-31 12:00:00	IWM	ETF	39.485	39.725	39.45	39.605	82600.0
2002-07-31 13:00:00	IWM	ETF	39.515	39.595	39.35	39.35	47800.0
2002-07-31 14:00:00	IWM	ETF	39.385	39.525	39.19	39.35	187000.0
2002-07-31 15:00:00	IWM	ETF	39.35	39.625	39.215	39.325	767800.0
2002-07-31 16:00:00	IWM	ETF	39.225	39.32	39.175	39.275	50200.0
2002-07-31 09:00:00	DIA	ETF	86.63	86.98	86.23	86.27	1248700.0
2002-07-31 10:00:00	DIA	ETF	86.28	86.34	85.39	85.63	2377000.0
2002-07-31 11:00:00	DIA	ETF	85.6	86.4	85.5	86.29	1278900.0
2002-07-31 12:00:00	DIA	ETF	86.25	86.71	86.03	86.45	742700.0
2002-07-31 13:00:00	DIA	ETF	86.45	86.45	85.7	85.92	748700.0
2002-07-31 14:00:00	DIA	ETF	85.95	86.2	85.5	85.91	1238900.0
2002-07-31 15:00:00	DIA	ETF	85.9	87.35	85.55	87.28	2489800.0
2002-07-31 16:00:00	DIA	ETF	87.26	87.39	87.05	87.15	176300.0
2002-07-31 09:00:00	TLT	ETF	81.95	81.97	81.9	81.96	1700.0
2002-07-31 10:00:00	TLT	ETF	82.38	82.38	82.37	82.37	3200.0
2002-07-31 11:00:00	TLT	ETF	82.36	82.39	82.25	82.38	3700.0
2002-07-31 12:00:00	TLT	ETF	82.32	82.56	82.32	82.52	1900.0
2002-07-31 13:00:00	TLT	ETF	82.48	82.55	82.46	82.46	2500.0
2002-07-31 14:00:00	TLT	ETF	82.66	82.78	82.66	82.68	2100.0
2002-07-31 15:00:00	TLT	ETF	82.8	82.8	82.6	82.62	4200.0
2002-07-31 16:00:00	TLT	ETF	82.53	82.53	82.53	82.53	10100.0

> showing 40 of 346 rows — these rows as CSV

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