PREVIEW / etf_daily / 2016-03-10

all etf daily files

  file:    by_date/etf_daily/2016/2016-03-10.parquet
  size:    50 KB
  rows:    1,245

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
2016-03-10	SPY	ETF	199.96	201.07	197.38	199.54	156838700.0
2016-03-10	QQQ	ETF	105.31	105.86	103.31	104.66	44997649.0
2016-03-10	IWM	ETF	107.1	107.49	104.81	105.93	47051200.0
2016-03-10	DIA	ETF	170.67	171.4	168.3	170.06	4862300.0
2016-03-10	GLD	ETF	120.5	121.76	120.42	121.5	18104900.0
2016-03-10	TLT	ETF	129.5	129.84	127.92	128.66	10091600.0
2016-03-10	AADR	ETF	37.23	37.23	37.1	37.1	700.0
2016-03-10	AAXJ	ETF	52.18	52.3	51.32	51.79	1268100.0
2016-03-10	ACTX	ETF	4.13	4.72	3.54	4.72	341.0
2016-03-10	ACWI	ETF	54.54	54.83	53.74	54.27	1474800.0
2016-03-10	ACWV	ETF	71.2	71.41	70.49	70.95	115700.0
2016-03-10	ACWX	ETF	38.68	38.87	38.005	38.34	1205303.0
2016-03-10	ADRE	ETF	29.46	29.46	29.0	29.37	1385.0
2016-03-10	AFK	ETF	18.61	18.7999	18.48	18.48	12766.0
2016-03-10	AFTY	ETF	12.241	12.241	12.11	12.16	8800.0
2016-03-10	AGG	ETF	109.65	109.74	109.38	109.62	2828700.0
2016-03-10	AGGY	ETF	49.905	49.91	49.77	49.8	9000.0
2016-03-10	AGQ	ETF	33.08	33.93	33.04	33.64	167100.0
2016-03-10	AGZ	ETF	114.15	114.15	113.93	114.04	24867.0
2016-03-10	AGZD	ETF	23.68	23.765	23.68	23.68	3800.0
2016-03-10	AIA	ETF	41.17	41.25	40.64	40.9	37872.0
2016-03-10	AIQ	ETF	8.06	8.08	7.49	8.04	18557.0
2016-03-10	AIRR	ETF	16.61	16.61	16.52	16.576	1700.0
2016-03-10	AIVI	ETF	37.71	37.88	37.17	37.4	20200.0
2016-03-10	ALTY	ETF	13.71	13.72	13.7	13.72	500.0
2016-03-10	AMJ	ETF	25.97	26.11	25.45	25.64	3505464.0
2016-03-10	AMLP	ETF	52.45	52.45	51.4	51.85	2485940.0
2016-03-10	AMZA	ETF	87.0	87.0	83.1	84.9	6910.0
2016-03-10	ANGL	ETF	25.32	25.32	25.11	25.19	23100.0
2016-03-10	AOA	ETF	44.21	44.3	43.6	43.93	39900.0
2016-03-10	AOK	ETF	31.74	31.8	31.52	31.66	65937.0
2016-03-10	AOM	ETF	34.2	34.2	33.86	33.99	51572.0
2016-03-10	AOR	ETF	38.69	38.69	38.15	38.41	160931.0
2016-03-10	ARGT	ETF	19.01	19.01	18.65	18.75	13300.0
2016-03-10	ARKG	ETF	17.34	17.34	17.34	17.34	200.0
2016-03-10	ARKK	ETF	18.34	18.34	17.813	17.813	400.0
2016-03-10	ARKQ	ETF	17.52	17.61	17.52	17.61	1500.0
2016-03-10	ARKW	ETF	19.429	19.488	19.429	19.488	300.0
2016-03-10	ASEA	ETF	12.98	12.98	12.98	12.98	400.0
2016-03-10	ASHR	ETF	22.72	22.79	22.35	22.53	1538400.0
2016-03-10	ASHS	ETF	30.46	30.54	30.04	30.15	11700.0
2016-03-10	ASHX	ETF	20.09	20.1034	20.09	20.1034	1012.0
2016-03-10	ATMP	ETF	17.65	17.65	17.11	17.21	52100.0
2016-03-10	BAB	ETF	29.83	29.9	29.77	29.83	296627.0
2016-03-10	BAL	ETF	36.61	37.15	36.4	37.15	6478.0
2016-03-10	BBC	ETF	18.47	18.7399	17.6	17.8699	7148.0
2016-03-10	BBH	ETF	102.25	102.92	99.64	100.66	94700.0
2016-03-10	BBP	ETF	24.44	24.6	23.7	23.86	2600.0
2016-03-10	BCM	ETF	24.61	24.67	24.61	24.67	1187.0
2016-03-10	BDCZ	ETF	19.28	19.28	19.18	19.18	300.0

> showing 50 of 1,245 rows — these rows as CSV

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