PREVIEW / etf_1hour / 2002-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-12.parquet
  size:    16 KB
  rows:    387

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-11-12 08:00:00	SPY	ETF	88.74	88.84	88.74	88.8	2200.0
2002-11-12 09:00:00	SPY	ETF	88.74	88.93	88.43	88.55	4498700.0
2002-11-12 10:00:00	SPY	ETF	88.5	89.36	88.37	89.18	7364100.0
2002-11-12 11:00:00	SPY	ETF	89.18	89.41	88.99	89.29	3665100.0
2002-11-12 12:00:00	SPY	ETF	89.29	89.59	89.15	89.5	2291700.0
2002-11-12 13:00:00	SPY	ETF	89.54	89.73	89.19	89.41	3427600.0
2002-11-12 14:00:00	SPY	ETF	89.4	89.91	89.37	89.41	3576700.0
2002-11-12 15:00:00	SPY	ETF	89.44	89.45	88.4	88.75	9896500.0
2002-11-12 16:00:00	SPY	ETF	88.68	89.02	88.68	88.9	1322700.0
2002-11-12 17:00:00	SPY	ETF	88.91	88.91	88.68	88.71	54700.0
2002-11-12 18:00:00	SPY	ETF	88.68	88.69	88.54	88.58	18900.0
2002-11-12 08:00:00	QQQ	ETF	24.41	24.49	24.4	24.45	30800.0
2002-11-12 09:00:00	QQQ	ETF	24.43	24.63	24.38	24.47	10921000.0
2002-11-12 10:00:00	QQQ	ETF	24.47	25.02	24.45	24.96	18104500.0
2002-11-12 11:00:00	QQQ	ETF	24.96	25.08	24.85	25.05	8096000.0
2002-11-12 12:00:00	QQQ	ETF	25.04	25.16	24.95	25.13	6351200.0
2002-11-12 13:00:00	QQQ	ETF	25.12	25.21	25.0	25.12	6545200.0
2002-11-12 14:00:00	QQQ	ETF	25.12	25.4	25.09	25.21	10896700.0
2002-11-12 15:00:00	QQQ	ETF	25.23	25.24	24.81	24.94	19863000.0
2002-11-12 16:00:00	QQQ	ETF	24.93	25.0	24.88	24.89	3340100.0
2002-11-12 17:00:00	QQQ	ETF	24.89	24.9	24.82	24.83	201300.0
2002-11-12 18:00:00	QQQ	ETF	24.83	24.84	24.8	24.82	93800.0
2002-11-12 19:00:00	QQQ	ETF	24.82	24.84	24.81	24.84	5000.0
2002-11-12 09:00:00	IWM	ETF	37.175	37.18	37.025	37.125	334200.0
2002-11-12 10:00:00	IWM	ETF	37.075	37.5	37.075	37.42	476400.0
2002-11-12 11:00:00	IWM	ETF	37.45	37.47	37.35	37.39	126800.0
2002-11-12 12:00:00	IWM	ETF	37.395	37.5	37.325	37.5	212200.0
2002-11-12 13:00:00	IWM	ETF	37.495	37.58	37.4	37.475	211600.0
2002-11-12 14:00:00	IWM	ETF	37.5	37.75	37.49	37.575	212600.0
2002-11-12 15:00:00	IWM	ETF	37.52	37.54	37.14	37.365	776800.0
2002-11-12 16:00:00	IWM	ETF	37.46	37.575	37.36	37.4	19000.0
2002-11-12 18:00:00	IWM	ETF	37.215	37.215	37.215	37.215	200.0
2002-11-12 19:00:00	IWM	ETF	37.215	37.215	37.215	37.215	200.0
2002-11-12 08:00:00	DIA	ETF	84.4	84.42	84.4	84.42	1200.0
2002-11-12 09:00:00	DIA	ETF	84.18	84.55	84.0	84.16	828400.0
2002-11-12 10:00:00	DIA	ETF	84.17	84.97	84.02	84.89	1405700.0
2002-11-12 11:00:00	DIA	ETF	84.87	85.01	84.66	84.91	666200.0
2002-11-12 12:00:00	DIA	ETF	84.9	85.27	84.8	85.15	2217700.0
2002-11-12 13:00:00	DIA	ETF	85.18	85.34	84.67	84.85	1055100.0
2002-11-12 14:00:00	DIA	ETF	84.85	85.28	84.72	84.81	1029700.0
2002-11-12 15:00:00	DIA	ETF	84.81	84.81	83.8	84.07	1637400.0
2002-11-12 16:00:00	DIA	ETF	84.1	84.43	84.05	84.35	86000.0
2002-11-12 17:00:00	DIA	ETF	84.29	84.33	84.2	84.2	1300.0
2002-11-12 18:00:00	DIA	ETF	84.11	84.11	83.95	83.95	1700.0
2002-11-12 19:00:00	DIA	ETF	83.92	84.05	83.9	84.05	900.0
2002-11-12 09:00:00	TLT	ETF	89.15	89.15	88.95	89.1	13300.0
2002-11-12 10:00:00	TLT	ETF	89.01	89.14	88.8	88.81	139100.0
2002-11-12 11:00:00	TLT	ETF	88.81	89.0	88.73	88.85	62400.0
2002-11-12 12:00:00	TLT	ETF	88.87	89.0	88.8	88.8	33600.0
2002-11-12 13:00:00	TLT	ETF	88.84	88.84	88.64	88.64	61300.0

> showing 50 of 387 rows — these rows as CSV

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