PREVIEW / etf_daily / 2011-10-19

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-19.parquet
  size:    36 KB
  rows:    869

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
2011-10-19	SPY	ETF	122.38	123.08	120.71	121.13	226601300.0
2011-10-19	QQQ	ETF	57.71	57.85	56.68	56.87	67639312.0
2011-10-19	IWM	ETF	70.61	71.15	69.07	69.43	71071600.0
2011-10-19	DIA	ETF	115.47	116.25	114.58	114.95	15286300.0
2011-10-19	GLD	ETF	161.09	161.43	159.55	159.87	8528700.0
2011-10-19	TLT	ETF	114.54	115.74	114.16	115.16	6629300.0
2011-10-19	AAXJ	ETF	51.45	51.46	50.89	50.94	9487100.0
2011-10-19	ACTV	ETF	15.39	15.39	14.26	14.43	87936.0
2011-10-19	ACWI	ETF	42.64	42.82	42.0	42.14	1828800.0
2011-10-19	ACWX	ETF	37.99	38.0	37.4	37.45	59548.0
2011-10-19	ADRE	ETF	38.79	38.9895	38.2035	38.3	29352.0
2011-10-19	AFK	ETF	27.43	27.66	27.06	27.15	22675.0
2011-10-19	AGEM	ETF	21.57	21.57	21.18	21.18	1000.0
2011-10-19	AGG	ETF	109.27	109.57	109.16	109.41	780200.0
2011-10-19	AGQ	ETF	233.24	235.6	220.0	221.48	418600.0
2011-10-19	AGZ	ETF	112.107	112.31	112.01	112.3	12373.0
2011-10-19	AIA	ETF	39.64	39.84	39.176	39.24	23038.0
2011-10-19	AIQ	ETF	5.75	5.75	5.65	5.65	11163.0
2011-10-19	AIS	ETF	2.23	2.27	2.18	2.2	806269.0
2011-10-19	AIVI	ETF	41.5	41.59	40.87	40.96	76700.0
2011-10-19	AMJ	ETF	36.11	36.37	35.97	36.08	2069649.0
2011-10-19	AMLP	ETF	79.05	79.2	78.55	78.8	158560.0
2011-10-19	AOA	ETF	32.44	32.54	32.06	32.06	5300.0
2011-10-19	AOK	ETF	29.02	29.059	28.9356	28.95	11007.0
2011-10-19	AOM	ETF	29.6499	29.7	29.52	29.53	13540.0
2011-10-19	AOR	ETF	30.73	30.77	30.47	30.5	98994.0
2011-10-19	ARB	ETF	37.0	38.23	36.39	36.63	91612.0
2011-10-19	ARGT	ETF	21.26	21.26	21.26	21.26	200.0
2011-10-19	ASEA	ETF	14.9	14.9	14.76	14.83	1900.0
2011-10-19	AWAY	ETF	36.22	36.44	35.32	35.93	32713.0
2011-10-19	BAB	ETF	27.92	27.978	27.6	27.63	304994.0
2011-10-19	BAL	ETF	61.84	62.64	61.5352	61.69	38694.0
2011-10-19	BALT	ETF	5.63	5.74	5.44	5.47	86751.0
2011-10-19	BBH	ETF	34.33	34.49	34.14	34.1833	12600.0
2011-10-19	BIB	ETF	7.4125	7.5	7.2825	7.3113	122688.0
2011-10-19	BICK	ETF	24.79	24.83	24.47	24.47	6805.0
2011-10-19	BIL	ETF	91.68	91.7	91.68	91.7	294450.0
2011-10-19	BIS	ETF	6400.0	6560.0	6398.4	6560.0	3.555
2011-10-19	BITS	ETF	22.92	23.08	21.04	22.6	36828.0
2011-10-19	BIV	ETF	86.72	86.98	86.65	86.95	188800.0
2011-10-19	BJK	ETF	31.0	31.27	30.27	30.32	28500.0
2011-10-19	BKF	ETF	37.23	37.36	36.7	36.7	44493.0
2011-10-19	BKLN	ETF	23.5	23.89	23.35	23.47	53300.0
2011-10-19	BLV	ETF	89.59	90.09	89.39	89.89	28000.0
2011-10-19	BMVP	ETF	13.4	13.46	13.15	13.16	3063.0
2011-10-19	BND	ETF	83.08	83.36	83.02	83.27	1940700.0
2011-10-19	BNO	ETF	37.88	38.325	37.12	37.26	231600.0
2011-10-19	BRF	ETF	43.6	43.788	43.1	43.22	162376.0
2011-10-19	BSCE	ETF	20.8399	20.89	20.83	20.89	16428.0
2011-10-19	BSV	ETF	81.2	81.2	81.07	81.13	3941400.0

> showing 50 of 869 rows — these rows as CSV

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