PREVIEW / etf_daily / 2008-01-25

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-25.parquet
  size:    25 KB
  rows:    563

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2008-01-25	SPY	ETF	136.51	136.76	132.6	133.04	269603900.0
2008-01-25	QQQ	ETF	45.86	45.87	43.94	43.99	199299091.0
2008-01-25	IWM	ETF	69.96	70.22	68.08	68.47	95436000.0
2008-01-25	DIA	ETF	124.64	124.71	121.72	122.19	19580700.0
2008-01-25	GLD	ETF	90.93	91.08	89.5	90.3	9703900.0
2008-01-25	TLT	ETF	94.19	96.0	94.13	95.95	4371100.0
2008-01-25	ADRE	ETF	50.46	50.46	48.36	48.65	460266.0
2008-01-25	AGG	ETF	102.58	103.26	102.22	103.02	585400.0
2008-01-25	AIA	ETF	45.84	45.84	43.1	43.3725	5700.0
2008-01-25	AIQ	ETF	50.85	52.2	49.85	50.8	54080.0
2008-01-25	AIS	ETF	0.84	0.96	0.84	0.94	132690.0
2008-01-25	AIVI	ETF	65.0	68.44	63.51	63.69	137100.0
2008-01-25	ARB	ETF	41.0	41.03	39.66	40.26	320100.0
2008-01-25	BBH	ETF	54.1533	54.1767	53.3067	53.3933	599100.0
2008-01-25	BIL	ETF	91.8	91.92	91.78	91.78	32700.0
2008-01-25	BITS	ETF	21.12	22.72	20.28	21.56	15791.0
2008-01-25	BIV	ETF	78.87	79.69	78.57	79.69	31900.0
2008-01-25	BJK	ETF	41.75	45.0	41.65	45.0	800.0
2008-01-25	BKF	ETF	52.68	52.79	50.79	51.4	102600.0
2008-01-25	BLV	ETF	77.33	78.27	76.96	78.2	25800.0
2008-01-25	BMVP	ETF	15.73	15.83	15.46	15.47	72300.0
2008-01-25	BND	ETF	77.71	78.65	77.59	78.65	168800.0
2008-01-25	BNE	ETF	12.96	13.05	12.74	12.8	246400.0
2008-01-25	BRF	ETF	14.62	14.64	14.6	14.63	9779.0
2008-01-25	BSV	ETF	78.4	78.68	78.01	78.68	103600.0
2008-01-25	BTF	ETF	106.5	107.65	104.94999999999999	104.94999999999999	2280.0
2008-01-25	BWX	ETF	27.25	27.34	27.2	27.34	126436.0
2008-01-25	CBON	ETF	16.53	17.24	15.59	15.68	78525.0
2008-01-25	CDL	ETF	1.67	1.75	1.63	1.65	1151280.0
2008-01-25	CEF	ETF	11.86	11.87	11.61	11.68	568000.0
2008-01-25	CGO	ETF	17.17	17.2499	17.0	17.0	17100.0
2008-01-25	CGW	ETF	22.95	24.01	22.65	22.8599	96350.0
2008-01-25	CHB	ETF	9.2	9.64	8.65	9.04	1940458.0
2008-01-25	CHI	ETF	15.89	15.94	15.54	15.81	129913.0
2008-01-25	CHIC	ETF	16.24	16.52	15.69	15.97	736977.0
2008-01-25	CHW	ETF	12.19	12.24	11.92	12.05	153186.0
2008-01-25	CHY	ETF	14.0	14.18	13.89	14.09	185921.0
2008-01-25	CMF	ETF	52.885	53.055	52.845	52.92	7600.0
2008-01-25	CN	ETF	61.92	62.94	60.03	60.29	276238.0
2008-01-25	CNXT	ETF	0.7	0.7099	0.63	0.63	6435575.0
2008-01-25	COW	ETF	45.31	45.31	45.12	45.2	10863.0
2008-01-25	CPI	ETF	21.1	21.1	21.0	21.0601	1300.0
2008-01-25	CPST	ETF	1.55	1.56	1.48	1.53	2182919.0
2008-01-25	CSA	ETF	15.7	16.21	15.7	16.1	93300.0
2008-01-25	CSD	ETF	24.27	24.3	23.76	23.76	10000.0
2008-01-25	CSQ	ETF	13.42	13.5	13.3101	13.48	219532.0
2008-01-25	CUT	ETF	21.5	21.54	21.18	21.25	14800.0
2008-01-25	CVY	ETF	22.8	22.95	22.39	22.55	27400.0
2008-01-25	CWI	ETF	26.1267	26.1333	23.98	25.3	179550.0
2008-01-25	DBA	ETF	36.1	36.43	35.93	36.38	1843100.0

> showing 50 of 563 rows — these rows as CSV

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