PREVIEW / etf_1hour / 2002-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-28.parquet
  size:    16 KB
  rows:    381

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-10-28 08:00:00	SPY	ETF	91.11	91.22	91.11	91.22	17000.0
2002-10-28 09:00:00	SPY	ETF	91.22	91.29	90.6	90.81	4823100.0
2002-10-28 10:00:00	SPY	ETF	90.77	90.94	89.72	89.82	6772900.0
2002-10-28 11:00:00	SPY	ETF	89.8	89.99	89.45	89.91	4170000.0
2002-10-28 12:00:00	SPY	ETF	89.85	90.44	89.85	90.17	3109500.0
2002-10-28 13:00:00	SPY	ETF	90.15	90.8	90.06	90.15	3025100.0
2002-10-28 14:00:00	SPY	ETF	90.15	90.33	89.6	89.9	5092400.0
2002-10-28 15:00:00	SPY	ETF	89.89	89.9	88.87	89.41	7123900.0
2002-10-28 16:00:00	SPY	ETF	89.41	89.72	89.33	89.53	2021300.0
2002-10-28 17:00:00	SPY	ETF	89.54	89.6	88.91	89.55	25700.0
2002-10-28 18:00:00	SPY	ETF	89.56	89.56	89.51	89.55	1200.0
2002-10-28 19:00:00	SPY	ETF	89.54	89.54	89.52	89.52	300.0
2002-10-28 08:00:00	QQQ	ETF	25.01	25.12	25.01	25.12	28600.0
2002-10-28 09:00:00	QQQ	ETF	25.13	25.13	24.83	24.85	16661300.0
2002-10-28 10:00:00	QQQ	ETF	24.86	24.92	24.41	24.5	18135200.0
2002-10-28 11:00:00	QQQ	ETF	24.47	24.53	24.26	24.48	10851500.0
2002-10-28 12:00:00	QQQ	ETF	24.49	24.71	24.46	24.62	7942400.0
2002-10-28 13:00:00	QQQ	ETF	24.63	24.82	24.57	24.6	7803400.0
2002-10-28 14:00:00	QQQ	ETF	24.6	24.69	24.4	24.51	7139200.0
2002-10-28 15:00:00	QQQ	ETF	24.51	24.54	24.17	24.32	14624500.0
2002-10-28 16:00:00	QQQ	ETF	24.33	24.52	24.3	24.49	2209600.0
2002-10-28 17:00:00	QQQ	ETF	24.49	24.5	24.43	24.47	69200.0
2002-10-28 18:00:00	QQQ	ETF	24.49	24.5	24.46	24.46	22500.0
2002-10-28 19:00:00	QQQ	ETF	24.47	24.49	24.47	24.48	4300.0
2002-10-28 09:00:00	IWM	ETF	37.7	37.7	37.23	37.3	588000.0
2002-10-28 10:00:00	IWM	ETF	37.355	37.355	37.02	37.135	595600.0
2002-10-28 11:00:00	IWM	ETF	37.175	37.175	37.0	37.13	54200.0
2002-10-28 12:00:00	IWM	ETF	37.15	37.25	37.14	37.2	263600.0
2002-10-28 13:00:00	IWM	ETF	37.18	37.275	37.135	37.14	99600.0
2002-10-28 14:00:00	IWM	ETF	37.15	37.16	37.0	37.1	169200.0
2002-10-28 15:00:00	IWM	ETF	37.02	37.06	36.675	36.8	527600.0
2002-10-28 16:00:00	IWM	ETF	36.825	36.825	36.82	36.825	7200.0
2002-10-28 08:00:00	DIA	ETF	85.33	85.58	85.33	85.58	1100.0
2002-10-28 09:00:00	DIA	ETF	85.6	85.8	84.86	85.0	1583000.0
2002-10-28 10:00:00	DIA	ETF	84.96	85.05	83.85	84.01	1720400.0
2002-10-28 11:00:00	DIA	ETF	83.96	84.25	83.68	84.2	951800.0
2002-10-28 12:00:00	DIA	ETF	84.21	84.64	84.15	84.44	700900.0
2002-10-28 13:00:00	DIA	ETF	84.44	84.95	84.32	84.39	738800.0
2002-10-28 14:00:00	DIA	ETF	84.38	84.56	83.88	84.22	971100.0
2002-10-28 15:00:00	DIA	ETF	84.18	84.2	83.3	83.82	1463900.0
2002-10-28 16:00:00	DIA	ETF	83.78	84.07	83.74	84.02	99300.0
2002-10-28 17:00:00	DIA	ETF	83.91	84.05	83.91	84.05	600.0
2002-10-28 18:00:00	DIA	ETF	84.11	84.11	84.0	84.11	2100.0
2002-10-28 19:00:00	DIA	ETF	84.02	84.02	84.02	84.02	100.0
2002-10-28 09:00:00	TLT	ETF	85.56	85.56	85.4	85.52	5000.0
2002-10-28 10:00:00	TLT	ETF	85.5	85.63	85.4	85.52	17300.0
2002-10-28 11:00:00	TLT	ETF	85.53	85.64	85.46	85.64	2200.0
2002-10-28 12:00:00	TLT	ETF	85.6	85.6	85.4	85.4	7200.0
2002-10-28 13:00:00	TLT	ETF	85.44	85.44	85.25	85.25	4800.0
2002-10-28 14:00:00	TLT	ETF	85.2	85.3	85.2	85.25	4400.0

> showing 50 of 381 rows — these rows as CSV

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