PREVIEW / etf_daily / 2008-09-25

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-25.parquet
  size:    27 KB
  rows:    613

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-09-25	SPY	ETF	119.4	121.91	118.44	120.79	328253000.0
2008-09-25	QQQ	ETF	41.2112	42.02	41.03	41.5	148586974.0
2008-09-25	IWM	ETF	69.92	71.26	69.89	70.3	115328200.0
2008-09-25	DIA	ETF	109.01	111.21	108.78	110.27	27647400.0
2008-09-25	GLD	ETF	87.12	87.8	85.01	86.45	20692000.0
2008-09-25	TLT	ETF	94.59	94.59	93.15	93.82	1881200.0
2008-09-25	AAXJ	ETF	43.82	44.85	43.82	44.85	11300.0
2008-09-25	ACWI	ETF	43.51	44.26	43.51	44.17	27700.0
2008-09-25	ACWX	ETF	42.71	43.27	42.56	43.07	48396.0
2008-09-25	ADRE	ETF	38.56	40.629	38.56	39.95	274871.0
2008-09-25	AFK	ETF	34.75	35.22	33.742	34.29	22400.0
2008-09-25	AGG	ETF	99.5	99.5	98.6	99.21	633200.0
2008-09-25	AIA	ETF	35.82	36.12	35.16	36.12	12432.0
2008-09-25	AIQ	ETF	54.55	55.35	53.75	54.85	27751.0
2008-09-25	AIS	ETF	0.69	0.72	0.63	0.71	22800.0
2008-09-25	AIVI	ETF	54.74	55.62	54.7	55.36	29300.0
2008-09-25	ARB	ETF	47.33	47.8	47.04	47.48	300919.0
2008-09-25	BAL	ETF	38.52	38.52	38.27	38.31	6428.0
2008-09-25	BBH	ETF	61.2867	62.8333	61.2867	62.4	352800.0
2008-09-25	BIL	ETF	91.82	92.04	91.82	91.92	132050.0
2008-09-25	BITS	ETF	22.84	23.12	22.04	22.04	2950.0
2008-09-25	BIV	ETF	74.67	75.47	74.29	74.87	56200.0
2008-09-25	BJK	ETF	25.32	26.22	24.72	24.75	1900.0
2008-09-25	BKF	ETF	37.72	38.74	37.02	38.13	63531.0
2008-09-25	BLV	ETF	73.1	73.1	71.81	72.06	13400.0
2008-09-25	BMVP	ETF	13.53	14.39	13.53	14.05	44532.0
2008-09-25	BND	ETF	77.0	77.46	76.11	76.89	200100.0
2008-09-25	BNE	ETF	11.27	12.08	11.25	11.79	145360.0
2008-09-25	BRF	ETF	14.67	14.74	14.67	14.73	18600.0
2008-09-25	BSV	ETF	78.63	78.63	77.2	77.84	104000.0
2008-09-25	BTF	ETF	79.3	84.49999999999999	79.25	80.64999999999999	13155.0
2008-09-25	BWX	ETF	26.735	27.2	26.5	26.935	806324.0
2008-09-25	CBON	ETF	6.82	7.25	6.8	6.97	65140.0
2008-09-25	CDL	ETF	0.74	0.86	0.73	0.86	1908749.0
2008-09-25	CEF	ETF	11.19	11.19	10.88	10.98	1169900.0
2008-09-25	CGO	ETF	11.8	12.22	11.8	12.13	36597.0
2008-09-25	CGW	ETF	21.01	21.47	21.0	21.36	50957.0
2008-09-25	CHB	ETF	5.64	6.3	5.57	6.19	1697456.0
2008-09-25	CHI	ETF	10.33	11.01	10.2725	10.94	138674.0
2008-09-25	CHIC	ETF	11.0	11.67	10.96	11.42	336473.0
2008-09-25	CHW	ETF	8.32	8.7	8.32	8.69	233827.0
2008-09-25	CHY	ETF	10.28	10.6254	10.03	10.62	185747.0
2008-09-25	CMF	ETF	50.33	50.455	50.2675	50.455	29762.0
2008-09-25	CN	ETF	44.4	45.49	44.0	45.1	211174.0
2008-09-25	CNXT	ETF	3.25	3.43	3.21	3.38	959337.0
2008-09-25	COW	ETF	41.1	41.26	40.85	40.87	297932.0
2008-09-25	CPI	ETF	23.5101	23.5101	23.51	23.51	526.0
2008-09-25	CPST	ETF	1.3	1.35	1.25	1.31	2702318.0
2008-09-25	CSA	ETF	17.08	17.51	17.0	17.4	187283.0
2008-09-25	CSB	ETF	15.8	16.25	15.0	16.25	35857.0

> showing 50 of 613 rows — these rows as CSV

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