PREVIEW / etf_1hour / 2002-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-12-20.parquet
  size:    16 KB
  rows:    399

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-12-20 08:00:00	SPY	ETF	89.4	89.68	89.35	89.41	35700.0
2002-12-20 09:00:00	SPY	ETF	89.37	89.52	89.1	89.5	4770400.0
2002-12-20 10:00:00	SPY	ETF	89.47	89.65	89.3	89.41	3365400.0
2002-12-20 11:00:00	SPY	ETF	89.44	89.65	89.23	89.64	1774600.0
2002-12-20 12:00:00	SPY	ETF	89.65	90.02	89.51	89.8	2883300.0
2002-12-20 13:00:00	SPY	ETF	89.8	89.95	89.71	89.72	1301900.0
2002-12-20 14:00:00	SPY	ETF	89.7	89.83	89.31	89.39	4450500.0
2002-12-20 15:00:00	SPY	ETF	89.37	89.88	89.3	89.69	4354400.0
2002-12-20 16:00:00	SPY	ETF	89.71	90.0	89.67	89.83	3501700.0
2002-12-20 17:00:00	SPY	ETF	89.83	89.91	89.83	89.9	4600.0
2002-12-20 18:00:00	SPY	ETF	89.92	89.94	89.9	89.9	3200.0
2002-12-20 19:00:00	SPY	ETF	89.93	90.03	89.9	90.03	2400.0
2002-12-20 08:00:00	QQQ	ETF	25.22	25.35	25.21	25.26	112700.0
2002-12-20 09:00:00	QQQ	ETF	25.25	25.45	25.13	25.39	10286200.0
2002-12-20 10:00:00	QQQ	ETF	25.37	25.43	25.17	25.25	9379100.0
2002-12-20 11:00:00	QQQ	ETF	25.24	25.38	25.19	25.32	6547600.0
2002-12-20 12:00:00	QQQ	ETF	25.33	25.43	25.27	25.31	5513500.0
2002-12-20 13:00:00	QQQ	ETF	25.31	25.39	25.27	25.27	2543300.0
2002-12-20 14:00:00	QQQ	ETF	25.27	25.28	25.1	25.12	7442300.0
2002-12-20 15:00:00	QQQ	ETF	25.12	25.29	25.07	25.23	8814400.0
2002-12-20 16:00:00	QQQ	ETF	25.24	25.42	25.2	25.38	7997800.0
2002-12-20 17:00:00	QQQ	ETF	25.39	25.4	25.35	25.37	47100.0
2002-12-20 18:00:00	QQQ	ETF	25.37	25.39	25.35	25.35	22100.0
2002-12-20 19:00:00	QQQ	ETF	25.37	25.38	25.36	25.37	5800.0
2002-12-20 09:00:00	IWM	ETF	38.37	38.45	38.185	38.3	281200.0
2002-12-20 10:00:00	IWM	ETF	38.31	38.375	38.225	38.325	212200.0
2002-12-20 11:00:00	IWM	ETF	38.3	38.37	38.19	38.34	152800.0
2002-12-20 12:00:00	IWM	ETF	38.345	38.45	38.305	38.425	312400.0
2002-12-20 13:00:00	IWM	ETF	38.425	38.5	38.365	38.365	59800.0
2002-12-20 14:00:00	IWM	ETF	38.35	38.415	38.225	38.275	328400.0
2002-12-20 15:00:00	IWM	ETF	38.275	38.59	38.265	38.54	377800.0
2002-12-20 16:00:00	IWM	ETF	38.525	38.625	38.475	38.515	178200.0
2002-12-20 08:00:00	DIA	ETF	84.4	84.62	84.4	84.52	3400.0
2002-12-20 09:00:00	DIA	ETF	84.45	84.73	84.29	84.7	792400.0
2002-12-20 10:00:00	DIA	ETF	84.73	84.76	84.43	84.61	661200.0
2002-12-20 11:00:00	DIA	ETF	84.6	84.83	84.42	84.73	470600.0
2002-12-20 12:00:00	DIA	ETF	84.74	85.16	84.67	84.97	604600.0
2002-12-20 13:00:00	DIA	ETF	84.99	85.15	84.96	84.97	270800.0
2002-12-20 14:00:00	DIA	ETF	84.95	85.0	84.68	84.74	393300.0
2002-12-20 15:00:00	DIA	ETF	84.78	85.28	84.66	85.15	904200.0
2002-12-20 16:00:00	DIA	ETF	85.15	85.5	85.11	85.5	140600.0
2002-12-20 17:00:00	DIA	ETF	85.51	85.51	85.51	85.51	700.0
2002-12-20 19:00:00	DIA	ETF	85.59	85.6	85.4	85.4	1100.0
2002-12-20 09:00:00	TLT	ETF	87.23	87.31	87.15	87.15	10000.0
2002-12-20 10:00:00	TLT	ETF	87.16	87.3	87.16	87.22	15200.0
2002-12-20 11:00:00	TLT	ETF	87.39	87.42	87.3	87.39	3500.0
2002-12-20 12:00:00	TLT	ETF	87.52	87.52	87.42	87.46	2300.0
2002-12-20 13:00:00	TLT	ETF	87.3	87.46	87.3	87.46	1300.0
2002-12-20 14:00:00	TLT	ETF	87.47	87.5	87.47	87.5	1200.0
2002-12-20 15:00:00	TLT	ETF	87.46	87.5	87.38	87.38	6300.0

> showing 50 of 399 rows — these rows as CSV

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