PREVIEW / etf_daily / 2012-04-10

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-10.parquet
  size:    39 KB
  rows:    942

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
2012-04-10	SPY	ETF	137.95	138.34	135.76	135.9	235360300.0
2012-04-10	QQQ	ETF	67.19	67.44	65.92	66.13	69254193.0
2012-04-10	IWM	ETF	79.92	80.16	78.14	78.35	101228600.0
2012-04-10	DIA	ETF	128.87	129.07	126.92	127.01	12912700.0
2012-04-10	GLD	ETF	159.66	161.58	158.47	161.1	14288500.0
2012-04-10	TLT	ETF	115.95	117.29	115.78	116.86	14421300.0
2012-04-10	AADR	ETF	29.86	29.91	29.86	29.91	900.0
2012-04-10	AAXJ	ETF	55.67	55.71	54.54	54.69	299500.0
2012-04-10	ACTV	ETF	16.23	16.37	16.12	16.33	220001.0
2012-04-10	ACWI	ETF	45.8	45.93	45.07	45.1	384900.0
2012-04-10	ACWV	ETF	53.91	53.91	53.2	53.2	2700.0
2012-04-10	ACWX	ETF	39.37	39.47	38.6895	38.72	220364.0
2012-04-10	ADRE	ETF	41.14	41.2	40.4	40.47	48781.0
2012-04-10	AFK	ETF	28.34	28.39	27.82	28.07	29033.0
2012-04-10	AGEM	ETF	22.38	22.38	22.35	22.35	200.0
2012-04-10	AGG	ETF	110.19	110.34	110.07	110.12	1893900.0
2012-04-10	AGQ	ETF	207.8	211.16	201.64	209.32	529200.0
2012-04-10	AGZ	ETF	112.61	112.9	112.45	112.53	48946.0
2012-04-10	AIA	ETF	43.98	43.98	43.22	43.28	25677.0
2012-04-10	AIQ	ETF	7.35	7.45	6.95	7.25	21613.0
2012-04-10	AIS	ETF	3.05	3.13	2.97	2.98	1336433.0
2012-04-10	AIVI	ETF	40.03	40.11	39.22	39.28	122000.0
2012-04-10	AMJ	ETF	38.65	38.91	38.0	38.07	1490650.0
2012-04-10	AMLP	ETF	82.5	82.8	81.4	81.55	390420.0
2012-04-10	AOA	ETF	35.67	35.75	35.14	35.2	17300.0
2012-04-10	AOK	ETF	29.9201	29.9201	29.77	29.77	53530.0
2012-04-10	AOM	ETF	30.96	30.96	30.684	30.73	18841.0
2012-04-10	AOR	ETF	32.86	32.86	32.485	32.54	24145.0
2012-04-10	ARB	ETF	36.13	36.26	35.82	36.0	225832.0
2012-04-10	ARGT	ETF	19.76	19.76	19.72	19.72	150.0
2012-04-10	ASEA	ETF	16.02	16.02	15.75	15.77	3200.0
2012-04-10	AWAY	ETF	23.58	23.85	23.37	23.6	298437.0
2012-04-10	BAB	ETF	29.42	29.65	29.4	29.6	304978.0
2012-04-10	BAL	ETF	54.6	54.88	54.2	54.46	16530.0
2012-04-10	BALT	ETF	4.03	4.09	3.93	4.05	136041.0
2012-04-10	BBH	ETF	43.7	43.7	42.58	42.68	38700.0
2012-04-10	BCM	ETF	44.69	44.76	44.69	44.76	300.0
2012-04-10	BIB	ETF	11.5887	11.5887	10.9289	10.99	82672.0
2012-04-10	BICK	ETF	25.73	25.74	25.09	25.243	149391.0
2012-04-10	BIL	ETF	91.64	91.66	91.64	91.66	520200.0
2012-04-10	BIS	ETF	3811.2	3979.68	3771.2	3961.6	167.0
2012-04-10	BIV	ETF	87.45	87.64	87.31	87.56	1307000.0
2012-04-10	BJK	ETF	35.6	35.67	34.74	34.91	55400.0
2012-04-10	BKF	ETF	40.23	40.33	39.36	39.5	93653.0
2012-04-10	BKLN	ETF	24.54	24.54	24.4	24.41	210100.0
2012-04-10	BLNG	ETF	50.18	50.18	50.18	50.18	8300.0
2012-04-10	BLV	ETF	90.55	91.0	90.34	90.68	61800.0
2012-04-10	BMVP	ETF	15.33	15.34	15.06	15.06	3511.0
2012-04-10	BND	ETF	83.52	83.69	83.48	83.61	1209700.0
2012-04-10	BNO	ETF	42.78	42.98	42.075	42.145	135800.0

> showing 50 of 942 rows — these rows as CSV

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