PREVIEW / etf_daily / 2008-09-15

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-15.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-15	SPY	ETF	121.63	125.65	119.89	120.09	483607000.0
2008-09-15	QQQ	ETF	42.4	43.29	42.03	42.08	616795277.0
2008-09-15	IWM	ETF	70.15	71.49	68.79	69.01	168634300.0
2008-09-15	DIA	ETF	111.15	114.44	109.64	109.8	44773800.0
2008-09-15	GLD	ETF	76.64	77.73	76.0	77.56	17004100.0
2008-09-15	TLT	ETF	96.28	98.17	96.07	98.02	5889900.0
2008-09-15	AAXJ	ETF	43.3	43.3	42.35	42.43	6200.0
2008-09-15	ACWI	ETF	43.51	43.72	42.47	42.62	1915000.0
2008-09-15	ACWX	ETF	41.39	41.64	40.832	40.832	11439.0
2008-09-15	ADRE	ETF	38.5	39.32	37.6	37.6	597118.0
2008-09-15	AFK	ETF	34.33	34.99	32.9201	32.9201	2080.0
2008-09-15	AGG	ETF	101.35	101.85	101.25	101.61	386900.0
2008-09-15	AIA	ETF	34.0	35.0999	34.0	34.35	58431.0
2008-09-15	AIQ	ETF	57.05	57.85	56.35	56.35	31774.0
2008-09-15	AIS	ETF	0.58	0.74	0.52	0.69	225249.0
2008-09-15	AIVI	ETF	51.21	51.83	51.11	51.37	26700.0
2008-09-15	ARB	ETF	47.5	47.71	46.55	46.58	437543.0
2008-09-15	BAL	ETF	39.36	39.36	38.85	38.85	600.0
2008-09-15	BBH	ETF	63.26	64.05	63.1	63.4933	470700.0
2008-09-15	BIL	ETF	91.88	92.02	91.78	91.9	195200.0
2008-09-15	BITS	ETF	21.48	21.48	21.2	21.36	1225.0
2008-09-15	BIV	ETF	78.52	78.52	77.21	78.01	57900.0
2008-09-15	BJK	ETF	27.1	27.1	27.1	27.1	200.0
2008-09-15	BKF	ETF	37.02	37.2	35.55	35.8	205980.0
2008-09-15	BLV	ETF	74.78	76.46	74.78	76.08	22100.0
2008-09-15	BMVP	ETF	14.0	14.46	13.54	14.07	58929.0
2008-09-15	BND	ETF	78.05	78.05	76.92	77.42	118600.0
2008-09-15	BNE	ETF	11.94	12.28	11.59	11.77	120693.0
2008-09-15	BRF	ETF	14.75	14.79	14.73	14.79	4900.0
2008-09-15	BSV	ETF	78.06	78.35	77.79	78.25	161800.0
2008-09-15	BTF	ETF	82.5	85.55	81.85	82.44999999999999	8980.2
2008-09-15	BWX	ETF	26.08	26.275	26.05	26.21	169756.0
2008-09-15	CBON	ETF	4.7	4.77	4.53	4.53	53009.0
2008-09-15	CDL	ETF	0.87	0.99	0.83	0.85	682327.0
2008-09-15	CEF	ETF	9.8	9.8	9.44	9.69	1662600.0
2008-09-15	CGO	ETF	12.7	12.9	12.27	12.33	36088.0
2008-09-15	CGW	ETF	20.52	21.43	20.52	21.0	109981.0
2008-09-15	CHB	ETF	5.51	5.55	4.76	4.83	1164835.0
2008-09-15	CHI	ETF	11.53	11.77	11.18	11.27	288208.0
2008-09-15	CHIC	ETF	12.13	12.5	11.8	12.0	330627.0
2008-09-15	CHW	ETF	9.08	9.2	8.48	8.51	543981.0
2008-09-15	CHY	ETF	11.27	11.6	11.12	11.25	325904.0
2008-09-15	CMF	ETF	51.95	52.075	51.945	51.985	8652.0
2008-09-15	CN	ETF	42.39	43.6999	41.51	41.52	282343.0
2008-09-15	CNXT	ETF	4.82	4.95	4.75	4.8	301314.0
2008-09-15	COW	ETF	40.74	41.52	40.28	41.465	236395.0
2008-09-15	CPI	ETF	21.75	21.75	21.75	21.75	500.0
2008-09-15	CPST	ETF	1.78	1.89	1.71	1.75	2519648.0
2008-09-15	CSA	ETF	18.07	18.12	17.43	17.49	168880.0
2008-09-15	CSB	ETF	16.0	16.75	14.2001	15.0	37025.0

> showing 50 of 613 rows — these rows as CSV

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