PREVIEW / etf_daily / 2012-12-03

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-03.parquet
  size:    39 KB
  rows:    955

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-12-03	SPY	ETF	142.8	142.92	141.34	141.45	124656300.0
2012-12-03	QQQ	ETF	66.32	66.37	65.64	65.67	28239968.0
2012-12-03	IWM	ETF	82.71	82.76	81.75	81.99	24959800.0
2012-12-03	DIA	ETF	130.69	130.8	129.49	129.55	5820800.0
2012-12-03	GLD	ETF	166.11	166.92	166.04	166.13	6363400.0
2012-12-03	TLT	ETF	123.72	124.79	123.62	124.66	5427800.0
2012-12-03	AADR	ETF	30.39	30.55	30.39	30.53	2100.0
2012-12-03	AAXJ	ETF	58.16	58.31	57.91	57.93	484700.0
2012-12-03	ACTV	ETF	5.43	5.44	5.02	5.05	1175557.0
2012-12-03	ACWI	ETF	47.39	47.44	47.09	47.12	1003300.0
2012-12-03	ACWV	ETF	57.14	57.14	56.44	56.44	145700.0
2012-12-03	ACWX	ETF	40.76	40.837	40.56	40.58	726787.0
2012-12-03	ADRE	ETF	38.38	38.4998	38.16	38.16	44918.0
2012-12-03	AFK	ETF	30.1	30.26	30.0	30.01	42143.0
2012-12-03	AGEM	ETF	22.46	22.46	22.3	22.32	800.0
2012-12-03	AGG	ETF	111.45	111.61	111.36	111.6	809900.0
2012-12-03	AGQ	ETF	217.56	221.04	217.4	217.76	274250.0
2012-12-03	AGZ	ETF	113.7	114.42	113.58	113.7	9335.0
2012-12-03	AIA	ETF	46.41	46.41	46.05	46.05	18179.0
2012-12-03	AIQ	ETF	6.25	6.25	6.1	6.1	1813.0
2012-12-03	AIVI	ETF	40.82	40.84	40.57	40.59	27700.0
2012-12-03	ALTL	ETF	25.44	25.44	25.382	25.382	357.0
2012-12-03	AMJ	ETF	39.87	39.87	39.21	39.2627	1486926.0
2012-12-03	AMLP	ETF	81.8	81.8	80.9	81.1	375740.0
2012-12-03	ANGL	ETF	26.89	26.99	26.89	26.95	24500.0
2012-12-03	AOA	ETF	36.97	36.97	36.71	36.71	5600.0
2012-12-03	AOK	ETF	30.63	30.63	30.54	30.548	24851.0
2012-12-03	AOM	ETF	31.76	31.76	31.63	31.68	63001.0
2012-12-03	AOR	ETF	33.89	33.89	33.6875	33.72	23974.0
2012-12-03	ARB	ETF	36.48	37.12	36.48	36.89	158180.0
2012-12-03	ARGT	ETF	16.08	16.08	16.04	16.04	3100.0
2012-12-03	ASEA	ETF	16.7	16.82	16.67	16.67	3000.0
2012-12-03	AWAY	ETF	20.63	20.64	19.95	20.12	500476.0
2012-12-03	BAB	ETF	30.53	30.58	30.488	30.56	290960.0
2012-12-03	BAL	ETF	48.3401	48.5	48.0	48.0	9676.0
2012-12-03	BALT	ETF	2.87	2.93	2.84	2.87	67864.0
2012-12-03	BBH	ETF	54.43	54.66	54.14	54.27	26500.0
2012-12-03	BCM	ETF	45.2	45.2	45.08	45.08	8700.0
2012-12-03	BIB	ETF	15.15	15.15	14.6775	14.7925	32036.0
2012-12-03	BICK	ETF	23.97	23.97	23.8427	23.9	2259.0
2012-12-03	BIL	ETF	91.62	91.64	91.62	91.62	694000.0
2012-12-03	BIS	ETF	2599.6	2632.4	2599.6	2629.6	20.0
2012-12-03	BIV	ETF	90.24	90.38	90.16	90.38	199200.0
2012-12-03	BJK	ETF	35.9	35.9	35.68	35.68	4900.0
2012-12-03	BKF	ETF	38.5	38.5	38.1	38.12	296128.0
2012-12-03	BKLN	ETF	24.75	24.77	24.71	24.77	616700.0
2012-12-03	BLNG	ETF	52.25	52.25	52.25	52.25	200.0
2012-12-03	BLV	ETF	96.11	96.75	96.09	96.63	73000.0
2012-12-03	BMVP	ETF	16.0033	16.0167	15.9467	15.9486	36242.0
2012-12-03	BND	ETF	84.7	84.86	84.65	84.84	2669300.0

> showing 50 of 955 rows — these rows as CSV

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