PREVIEW / etf_daily / 2008-09-30

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-30.parquet
  size:    27 KB
  rows:    611

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-30	SPY	ETF	113.51	116.8	110.53	115.99	328154400.0
2008-09-30	QQQ	ETF	37.74	39.3	37.6	38.91	195512753.0
2008-09-30	IWM	ETF	65.87	68.39	65.05	68.0	107271100.0
2008-09-30	DIA	ETF	105.56	108.63	105.22	108.36	24710600.0
2008-09-30	GLD	ETF	87.31	87.36	84.21	85.07	20437900.0
2008-09-30	TLT	ETF	97.04	97.29	94.6	94.88	1358100.0
2008-09-30	AAXJ	ETF	40.89	41.4	40.89	41.4	26200.0
2008-09-30	ACWI	ETF	40.19	41.55	40.19	41.29	114600.0
2008-09-30	ACWX	ETF	39.21	40.3	38.0	39.91	475662.0
2008-09-30	ADRE	ETF	34.96	37.74	34.96	37.66	216841.0
2008-09-30	AFK	ETF	32.3	33.817	32.3	32.8	7566.0
2008-09-30	AGG	ETF	98.25	99.29	97.03	98.59	655400.0
2008-09-30	AIA	ETF	33.01	33.58	32.68	33.4199	6240.0
2008-09-30	AIQ	ETF	52.2	52.2	48.85	51.35	69030.0
2008-09-30	AIS	ETF	0.68	0.74	0.6799	0.73	91455.0
2008-09-30	AIVI	ETF	50.27	50.82	49.54	50.82	34100.0
2008-09-30	ARB	ETF	46.33	46.33	44.12	44.69	480900.0
2008-09-30	BBH	ETF	59.6067	60.9767	59.3433	60.95	494100.0
2008-09-30	BIL	ETF	92.98	92.98	91.92	92.14	140850.0
2008-09-30	BITS	ETF	21.88	21.884	20.64	21.8	1888.0
2008-09-30	BIV	ETF	75.04	75.04	73.0	73.27	72700.0
2008-09-30	BJK	ETF	24.35	24.35	23.35	23.35	3400.0
2008-09-30	BKF	ETF	32.93	34.748	32.93	34.734	40434.0
2008-09-30	BLV	ETF	72.73	72.73	71.38	71.38	9300.0
2008-09-30	BMVP	ETF	13.09	13.53	13.09	13.53	28966.0
2008-09-30	BND	ETF	77.0	77.0	75.38	75.62	240500.0
2008-09-30	BNE	ETF	11.33	11.6	10.86	11.55	127143.0
2008-09-30	BRF	ETF	14.61	14.68	14.52	14.68	24915.0
2008-09-30	BSV	ETF	78.35	78.35	76.76	77.15	204200.0
2008-09-30	BTF	ETF	72.05	73.44999999999999	71.55	72.85	5552.0
2008-09-30	BWX	ETF	26.0	26.46	25.56	25.945	527160.0
2008-09-30	CBON	ETF	6.89	6.89	6.18	6.39	59985.0
2008-09-30	CDL	ETF	0.71	0.82	0.71	0.78	825164.0
2008-09-30	CEF	ETF	11.5	11.5	10.67	10.83	1925900.0
2008-09-30	CGO	ETF	10.96	11.59	10.61	11.4	52006.0
2008-09-30	CGW	ETF	19.76	19.9	18.31	19.7	240102.0
2008-09-30	CHB	ETF	5.575	5.87	5.31	5.55	1307364.0
2008-09-30	CHI	ETF	10.3	10.83	10.1	10.71	243090.0
2008-09-30	CHIC	ETF	10.7	11.23	10.22	10.25	534912.0
2008-09-30	CHW	ETF	7.55	7.9	7.36	7.9	193765.0
2008-09-30	CHY	ETF	9.4	10.05	9.3	10.0	514642.0
2008-09-30	CMF	ETF	50.005	50.335	50.0	50.245	22480.0
2008-09-30	CN	ETF	43.05	45.48	43.05	45.48	279795.0
2008-09-30	CNXT	ETF	3.5	4.11	3.5	4.01	2269615.0
2008-09-30	COW	ETF	39.8	40.35	39.8	39.86	41873.0
2008-09-30	CPST	ETF	1.28	1.31	1.15	1.29	4202460.0
2008-09-30	CSA	ETF	17.68	17.68	16.04	16.04	200617.0
2008-09-30	CSB	ETF	14.0	14.0	11.69	13.86	48580.0
2008-09-30	CSD	ETF	17.5	18.05	17.5	17.97	47500.0
2008-09-30	CSQ	ETF	8.11	8.74	8.11	8.64	437806.0

> showing 50 of 611 rows — these rows as CSV

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