PREVIEW / etf_daily / 2008-07-17

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-17.parquet
  size:    27 KB
  rows:    609

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-07-17	SPY	ETF	125.14	126.26	124.09	125.2	375490600.0
2008-07-17	QQQ	ETF	45.56	45.82	44.9799	45.64	197555054.0
2008-07-17	IWM	ETF	68.72	69.54	68.08	68.4	115518700.0
2008-07-17	DIA	ETF	113.16	114.61	112.17	114.14	36225700.0
2008-07-17	GLD	ETF	94.7	96.51	94.07	94.22	25185100.0
2008-07-17	TLT	ETF	91.26	91.61	90.56	90.79	5899900.0
2008-07-17	ACWI	ETF	48.03	48.13	47.68	47.9	123400.0
2008-07-17	ACWX	ETF	48.84	48.8436	48.506	48.79	8097.0
2008-07-17	ADRE	ETF	48.05	48.74	47.53	47.89	1189829.0
2008-07-17	AFK	ETF	41.49	42.27	41.49	41.88	7044.0
2008-07-17	AGG	ETF	100.0	100.1	99.39	99.56	503300.0
2008-07-17	AIA	ETF	40.95	40.95	39.819	40.255	10369.0
2008-07-17	AIQ	ETF	42.95	44.15	42.65	43.25	37008.0
2008-07-17	AIS	ETF	0.71	0.74	0.69	0.7	350596.0
2008-07-17	AIVI	ETF	59.15	59.17	58.54	58.96	25800.0
2008-07-17	ARB	ETF	45.68	47.14	45.44	46.7	306946.0
2008-07-17	BAL	ETF	45.14	45.44	45.14	45.44	1100.0
2008-07-17	BBH	ETF	59.67	60.7533	59.0333	60.71	462900.0
2008-07-17	BIL	ETF	91.84	91.88	91.7	91.72	134700.0
2008-07-17	BITS	ETF	24.2	24.36	23.84	24.12	3975.0
2008-07-17	BIV	ETF	76.05	76.15	75.69	75.78	36000.0
2008-07-17	BJK	ETF	29.56	29.6	29.49	29.6	1300.0
2008-07-17	BKF	ETF	50.24	50.53	49.42	49.68	38800.0
2008-07-17	BLV	ETF	73.06	73.58	72.98	73.07	20000.0
2008-07-17	BMVP	ETF	14.873	14.873	14.673	14.76	83331.0
2008-07-17	BND	ETF	75.73	75.82	75.29	75.41	101400.0
2008-07-17	BNE	ETF	11.87	12.1	11.79	11.93	180218.0
2008-07-17	BRF	ETF	14.74	14.74	14.72	14.72	6200.0
2008-07-17	BSV	ETF	77.18	77.29	76.98	77.05	119000.0
2008-07-17	BTF	ETF	81.99999999999999	83.2	81.6	82.44999999999999	7948.0
2008-07-17	BWX	ETF	28.06	28.135	27.85	27.875	181534.0
2008-07-17	CBON	ETF	3.25	3.82	3.04	3.79	195209.0
2008-07-17	CDL	ETF	0.8	0.96	0.8	0.86	1400148.0
2008-07-17	CEF	ETF	13.58	13.62	13.25	13.39	1235400.0
2008-07-17	CGO	ETF	15.11	15.11	14.65	14.94	20739.0
2008-07-17	CGW	ETF	22.11	22.75	22.11	22.75	41905.0
2008-07-17	CHB	ETF	4.83	5.34	2.91	3.15	8655169.0
2008-07-17	CHI	ETF	13.02	13.65	13.02	13.38	254503.0
2008-07-17	CHIC	ETF	17.13	17.705	16.58	17.57	413324.0
2008-07-17	CHW	ETF	10.58	10.77	10.38	10.77	202472.0
2008-07-17	CHY	ETF	12.2	12.67	12.2	12.4399	253400.0
2008-07-17	CMF	ETF	51.695	51.725	51.44	51.44	2418.0
2008-07-17	CN	ETF	60.37	62.08	60.37	61.85	438339.0
2008-07-17	COW	ETF	43.72	43.76	42.74	43.14	261567.0
2008-07-17	CPST	ETF	3.78	3.86	3.64	3.68	3728542.0
2008-07-17	CSA	ETF	17.9	18.31	17.89	18.16	78795.0
2008-07-17	CSB	ETF	15.74	17.74	15.74	17.31	55178.0
2008-07-17	CSD	ETF	20.91	20.98	20.79	20.98	5400.0
2008-07-17	CSQ	ETF	10.47	10.71	10.37	10.7	466556.0
2008-07-17	CUT	ETF	17.85	18.59	17.85	18.31	11400.0

> showing 50 of 609 rows — these rows as CSV

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