PREVIEW / etf_daily / 2011-10-12

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-12.parquet
  size:    37 KB
  rows:    881

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-12	SPY	ETF	120.6	122.14	120.33	120.75	281544900.0
2011-10-12	QQQ	ETF	56.87	57.23	56.56	56.6	85627554.0
2011-10-12	IWM	ETF	69.37	70.53	68.82	69.82	88580000.0
2011-10-12	DIA	ETF	114.77	116.12	114.41	114.99	7855800.0
2011-10-12	GLD	ETF	163.7	164.0	162.5	163.26	10867900.0
2011-10-12	TLT	ETF	114.7	115.12	113.48	114.49	14033400.0
2011-10-12	AADR	ETF	27.9	28.16	27.9	28.16	11400.0
2011-10-12	AAXJ	ETF	51.15	52.24	51.15	51.66	236200.0
2011-10-12	ACTV	ETF	14.55	14.55	14.12	14.27	170900.0
2011-10-12	ACWI	ETF	42.19	42.71	42.11	42.23	435400.0
2011-10-12	ACWX	ETF	37.96	38.4	37.91	38.05	80616.0
2011-10-12	ADRE	ETF	38.46	39.402	38.46	38.99	47802.0
2011-10-12	AFK	ETF	27.31	27.5535	27.31	27.32	9519.0
2011-10-12	AGEM	ETF	21.82	21.95	21.6	21.6	3712.0
2011-10-12	AGG	ETF	108.89	109.16	108.82	109.06	1120800.0
2011-10-12	AGQ	ETF	246.72	249.64	240.0	246.32	3501950.0
2011-10-12	AGZ	ETF	112.06	112.06	111.68	111.81	17456.0
2011-10-12	AIA	ETF	39.64	40.42	39.64	40.13	19418.0
2011-10-12	AIQ	ETF	6.25	6.75	6.0505	6.65	53458.0
2011-10-12	AIS	ETF	2.3	2.33	2.26	2.31	583129.0
2011-10-12	AIVI	ETF	41.59	41.97	41.42	41.58	134000.0
2011-10-12	AMJ	ETF	34.98	35.2671	34.9	35.05	805355.0
2011-10-12	AMLP	ETF	77.4	77.7	77.25	77.45	203340.0
2011-10-12	AOA	ETF	32.02	32.42	32.02	32.35	4500.0
2011-10-12	AOK	ETF	28.8452	28.96	28.8424	28.9499	13816.0
2011-10-12	AOM	ETF	29.4292	29.61	29.4292	29.53	125917.0
2011-10-12	AOR	ETF	30.37	30.6799	30.37	30.54	15279.0
2011-10-12	ARB	ETF	37.41	39.01	37.41	38.69	168537.0
2011-10-12	ARGT	ETF	21.4	21.68	21.4	21.68	200.0
2011-10-12	ASEA	ETF	14.75	15.04	14.75	14.87	11000.0
2011-10-12	AWAY	ETF	36.37	36.6	34.97	35.12	129158.0
2011-10-12	BAB	ETF	28.1	28.2	27.97	28.16	177878.0
2011-10-12	BAL	ETF	62.9	63.11	61.64	62.15	77033.0
2011-10-12	BALT	ETF	5.42	5.8	5.4	5.54	190787.0
2011-10-12	BBH	ETF	33.7533	33.8667	33.5	33.5733	25500.0
2011-10-12	BCM	ETF	43.3	43.7	43.3	43.409	4630.0
2011-10-12	BIB	ETF	7.6238	7.6238	7.4025	7.4287	19160.0
2011-10-12	BICK	ETF	24.28	25.01	24.28	24.78	10701.0
2011-10-12	BIL	ETF	91.7	91.7	91.68	91.68	383000.0
2011-10-12	BITS	ETF	23.16	23.8	22.0	23.08	9181.0
2011-10-12	BIV	ETF	86.27	86.43	86.08	86.32	386500.0
2011-10-12	BJK	ETF	31.25	31.71	31.25	31.44	43200.0
2011-10-12	BKF	ETF	37.19	38.2	37.16	37.65	240206.0
2011-10-12	BKLN	ETF	23.2	23.32	23.14	23.31	61000.0
2011-10-12	BLNG	ETF	51.55	51.59	51.49	51.59	6600.0
2011-10-12	BLV	ETF	88.95	89.19	88.25	89.02	67600.0
2011-10-12	BMVP	ETF	13.2167	13.3367	13.2167	13.2367	14522.0
2011-10-12	BND	ETF	82.74	82.96	82.72	82.9	2032400.0
2011-10-12	BNO	ETF	37.45	37.71	37.2	37.2	57600.0
2011-10-12	BOIL	ETF	3765000.0	3765000.0	3681000.0	3681000.0	0.2

> showing 50 of 881 rows — these rows as CSV

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