PREVIEW / etf_1hour / 2005-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-04.parquet
  size:    29 KB
  rows:    833

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
2005-02-04 08:00:00	SPY	ETF	119.23	119.23	118.8	119.05	915700.0
2005-02-04 09:00:00	SPY	ETF	119.04	119.49	118.93	119.38	8451600.0
2005-02-04 10:00:00	SPY	ETF	119.37	119.63	119.37	119.57	8696900.0
2005-02-04 11:00:00	SPY	ETF	119.56	119.77	119.4	119.48	5326100.0
2005-02-04 12:00:00	SPY	ETF	119.47	119.74	119.46	119.72	3228200.0
2005-02-04 13:00:00	SPY	ETF	119.72	119.9	119.58	119.78	4692300.0
2005-02-04 14:00:00	SPY	ETF	119.78	119.92	119.71	119.81	4139700.0
2005-02-04 15:00:00	SPY	ETF	119.79	120.43	119.78	120.31	10382900.0
2005-02-04 16:00:00	SPY	ETF	120.3	120.375	120.16	120.21	2676200.0
2005-02-04 17:00:00	SPY	ETF	120.22	120.23	120.22	120.23	400.0
2005-02-04 18:00:00	SPY	ETF	120.22	120.22	120.2	120.2	4600.0
2005-02-04 19:00:00	SPY	ETF	120.21	120.23	120.2	120.23	7500.0
2005-02-04 09:00:00	QQQ	ETF	37.15	37.44	37.15	37.39	12783400.0
2005-02-04 10:00:00	QQQ	ETF	37.39	37.6	37.37	37.53	22430600.0
2005-02-04 11:00:00	QQQ	ETF	37.53	37.6	37.41	37.41	9504700.0
2005-02-04 12:00:00	QQQ	ETF	37.42	37.58	37.42	37.57	6466000.0
2005-02-04 13:00:00	QQQ	ETF	37.57	37.68	37.47	37.62	9397000.0
2005-02-04 14:00:00	QQQ	ETF	37.62	37.66	37.52	37.58	8238400.0
2005-02-04 15:00:00	QQQ	ETF	37.58	38.79	37.58	37.8	20212800.0
2005-02-04 08:00:00	IWM	ETF	62.645	62.645	62.5	62.56	18600.0
2005-02-04 09:00:00	IWM	ETF	62.51	63.045	62.47	63.005	1941200.0
2005-02-04 10:00:00	IWM	ETF	63.02	63.2	62.99	63.1	3047600.0
2005-02-04 11:00:00	IWM	ETF	63.1	63.16	62.935	62.99	1519200.0
2005-02-04 12:00:00	IWM	ETF	62.985	63.125	62.985	63.1	1598400.0
2005-02-04 13:00:00	IWM	ETF	63.0955	63.325	63.05	63.225	1629800.0
2005-02-04 14:00:00	IWM	ETF	63.245	63.34	63.075	63.265	1899800.0
2005-02-04 15:00:00	IWM	ETF	63.265	63.53	63.205	63.465	5402200.0
2005-02-04 16:00:00	IWM	ETF	63.455	63.52	63.38	63.4	1950000.0
2005-02-04 08:00:00	DIA	ETF	106.06	106.06	105.83	105.89	8800.0
2005-02-04 09:00:00	DIA	ETF	105.75	106.21	105.75	106.13	970900.0
2005-02-04 10:00:00	DIA	ETF	106.12	106.31	106.08	106.24	785600.0
2005-02-04 11:00:00	DIA	ETF	106.25	106.43	106.14	106.15	645800.0
2005-02-04 12:00:00	DIA	ETF	106.15	106.48	106.15	106.47	647600.0
2005-02-04 13:00:00	DIA	ETF	106.47	106.61	106.35	106.58	798100.0
2005-02-04 14:00:00	DIA	ETF	106.58	106.83	106.57	106.67	1062700.0
2005-02-04 15:00:00	DIA	ETF	106.66	107.21	106.66	107.07	1292700.0
2005-02-04 16:00:00	DIA	ETF	107.08	107.11	106.95	107.0	110500.0
2005-02-04 17:00:00	DIA	ETF	107.05	107.05	107.05	107.05	100.0
2005-02-04 18:00:00	DIA	ETF	107.08	107.08	107.08	107.08	400.0
2005-02-04 19:00:00	DIA	ETF	107.02	107.02	107.0	107.0	200.0
2005-02-04 09:00:00	GLD	ETF	41.59	41.65	41.56	41.59	484500.0
2005-02-04 10:00:00	GLD	ETF	41.6	41.62	41.5	41.5	443000.0
2005-02-04 11:00:00	GLD	ETF	41.51	41.51	41.39	41.42	333200.0
2005-02-04 12:00:00	GLD	ETF	41.42	41.47	41.39	41.45	156600.0
2005-02-04 13:00:00	GLD	ETF	41.46	41.47	41.39	41.46	116600.0
2005-02-04 14:00:00	GLD	ETF	41.45	41.47	41.42	41.44	107000.0
2005-02-04 15:00:00	GLD	ETF	41.42	41.49	41.41	41.47	156500.0
2005-02-04 16:00:00	GLD	ETF	41.48	41.48	41.43	41.43	2000.0
2005-02-04 08:00:00	TLT	ETF	91.54	92.19	91.4	92.15	616200.0
2005-02-04 09:00:00	TLT	ETF	92.19	92.74	92.19	92.65	679700.0

> showing 50 of 833 rows — these rows as CSV

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