PREVIEW / etf_daily / 2012-10-17

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-17.parquet
  size:    39 KB
  rows:    950

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-10-17	SPY	ETF	145.64	146.32	145.42	146.2	128834100.0
2012-10-17	QQQ	ETF	67.75	68.3	67.68	68.08	33439368.0
2012-10-17	IWM	ETF	83.42	84.15	83.25	84.0	35466500.0
2012-10-17	DIA	ETF	134.95	135.46	134.85	135.43	3815400.0
2012-10-17	GLD	ETF	169.21	169.95	168.92	169.54	5203400.0
2012-10-17	TLT	ETF	121.17	121.26	120.57	120.85	6932500.0
2012-10-17	AAXJ	ETF	56.94	57.51	56.79	57.39	264000.0
2012-10-17	ACTV	ETF	10.33	10.33	9.58	9.92	1580703.0
2012-10-17	ACWI	ETF	47.77	47.92	47.57	47.88	593000.0
2012-10-17	ACWV	ETF	57.27	57.41	57.07	57.33	116100.0
2012-10-17	ACWX	ETF	40.34	40.64	40.305	40.62	136203.0
2012-10-17	ADRE	ETF	39.57	39.89	39.54	39.77	32292.0
2012-10-17	AFK	ETF	31.9199	31.9999	31.81	31.999	6486.0
2012-10-17	AGG	ETF	112.04	112.05	111.82	111.85	1199200.0
2012-10-17	AGQ	ETF	211.76	215.8	210.56	214.4	240325.0
2012-10-17	AGZ	ETF	113.72	113.72	113.59	113.59	12855.0
2012-10-17	AIA	ETF	45.11	45.4	44.82	45.3965	22573.0
2012-10-17	AIQ	ETF	6.9	7.0	6.85	6.85	2069.0
2012-10-17	AIVI	ETF	41.28	41.41	41.11	41.36	27700.0
2012-10-17	AMJ	ETF	41.26	41.47	41.18	41.38	745197.0
2012-10-17	AMLP	ETF	83.95	84.4	83.95	84.3	349640.0
2012-10-17	ANGL	ETF	26.88	26.97	26.88	26.97	700.0
2012-10-17	AOA	ETF	37.12	37.26	37.12	37.25	2800.0
2012-10-17	AOK	ETF	30.64	30.64	30.6	30.6	27157.0
2012-10-17	AOM	ETF	31.78	31.84	31.76	31.81	20092.0
2012-10-17	AOR	ETF	33.92	34.066	33.92	34.06	1812.0
2012-10-17	ARB	ETF	37.99	38.17	37.28	37.74	99202.0
2012-10-17	ARGT	ETF	17.88	17.88	17.88	17.88	100.0
2012-10-17	ASEA	ETF	17.03	17.04	16.98	17.04	3600.0
2012-10-17	AWAY	ETF	26.63	26.6387	25.8602	26.17	183041.0
2012-10-17	BAB	ETF	29.72	29.74	29.61	29.61	168016.0
2012-10-17	BAL	ETF	49.55	51.82	49.44	51.62	27214.0
2012-10-17	BALT	ETF	3.28	3.35	3.25	3.33	40866.0
2012-10-17	BBH	ETF	54.93	55.88	54.93	55.7	30900.0
2012-10-17	BCM	ETF	45.62	45.702	45.62	45.702	342.0
2012-10-17	BIB	ETF	16.2425	17.035	16.15	16.498	90360.0
2012-10-17	BICK	ETF	23.83	24.16	23.83	24.07	4398.0
2012-10-17	BIL	ETF	91.62	91.64	91.62	91.64	48650.0
2012-10-17	BIS	ETF	2511.6	2511.6	2408.0	2427.2	125.0
2012-10-17	BIV	ETF	90.13	90.14	89.87	89.93	273000.0
2012-10-17	BJK	ETF	34.63	34.85	34.63	34.71	1200.0
2012-10-17	BKF	ETF	38.8	39.12	38.71	39.06	38894.0
2012-10-17	BKLN	ETF	24.96	24.96	24.93	24.95	1714200.0
2012-10-17	BLNG	ETF	52.65	52.65	52.65	52.65	1900.0
2012-10-17	BLV	ETF	96.11	96.11	95.64	95.77	106300.0
2012-10-17	BMVP	ETF	16.1833	16.26	16.1833	16.26	1168.0
2012-10-17	BND	ETF	84.75	84.76	84.5	84.59	5638300.0
2012-10-17	BNO	ETF	41.355	41.375	41.045	41.105	36600.0
2012-10-17	BOIL	ETF	1115400.0	1141400.0	1113400.0	1129600.0	8.6
2012-10-17	BOND	ETF	109.17	109.18	108.92	108.97	421483.0

> showing 50 of 950 rows — these rows as CSV

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