PREVIEW / etf_daily / 2016-06-13

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-13.parquet
  size:    51 KB
  rows:    1,276

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-06-13	SPY	ETF	209.36	210.37	208.35	208.45	117751200.0
2016-06-13	QQQ	ETF	108.34	108.93	107.89	108.03	25412177.0
2016-06-13	IWM	ETF	115.65	116.18	114.59	114.81	36169500.0
2016-06-13	DIA	ETF	178.0	179.0	177.36	177.36	5111300.0
2016-06-13	GLD	ETF	122.8	122.83	122.03	122.64	12594200.0
2016-06-13	TLT	ETF	135.09	135.39	134.77	135.38	7283300.0
2016-06-13	AADR	ETF	38.49	38.49	38.01	38.01	400.0
2016-06-13	AAXJ	ETF	53.0	53.32	52.84	52.88	816400.0
2016-06-13	ACTX	ETF	3.54	4.72	3.54	3.54	301.0
2016-06-13	ACWI	ETF	56.26	56.64	56.07	56.11	1164200.0
2016-06-13	ACWV	ETF	74.49	74.75	74.26	74.32	115700.0
2016-06-13	ACWX	ETF	39.11	39.4	38.97	39.01	549282.0
2016-06-13	ADRE	ETF	29.98	30.14	29.9101	29.95	2164.0
2016-06-13	AFK	ETF	20.57	20.78	20.28	20.28	9693.0
2016-06-13	AFTY	ETF	12.17	12.24	12.15	12.15	2900.0
2016-06-13	AGG	ETF	111.57	111.67	111.53	111.61	1661400.0
2016-06-13	AGGY	ETF	51.43	51.43	51.21	51.286	3300.0
2016-06-13	AGQ	ETF	40.99	41.39	40.69	41.26	207700.0
2016-06-13	AGZ	ETF	115.27	115.47	115.2201	115.38	18582.0
2016-06-13	AGZD	ETF	23.875	23.875	23.875	23.875	2000.0
2016-06-13	AIA	ETF	43.1	43.23	42.88	42.9	16827.0
2016-06-13	AIQ	ETF	6.54	6.68	6.37	6.39	12632.0
2016-06-13	AIRR	ETF	18.45	18.45	18.41	18.41	300.0
2016-06-13	AIVI	ETF	37.44	37.81	37.36	37.5	17900.0
2016-06-13	ALTY	ETF	14.75	14.8	14.71	14.8	1100.0
2016-06-13	AMJ	ETF	30.71	30.91	30.34	30.61	2091226.0
2016-06-13	AMLP	ETF	62.25	62.8	61.7	62.05	2037500.0
2016-06-13	AMZA	ETF	110.1	111.9	108.1	110.2	9020.0
2016-06-13	ANGL	ETF	27.3	27.36	27.21	27.21	77700.0
2016-06-13	AOA	ETF	45.62	45.69	45.28	45.28	41700.0
2016-06-13	AOK	ETF	32.52	32.94	32.4601	32.52	28016.0
2016-06-13	AOM	ETF	35.0	35.1834	34.96	35.02	68190.0
2016-06-13	AOR	ETF	39.79	39.79	39.53	39.59	49572.0
2016-06-13	ARGT	ETF	21.6	21.74	21.4	21.42	30200.0
2016-06-13	ARKG	ETF	17.384	17.384	17.094	17.13	1400.0
2016-06-13	ARKK	ETF	19.59	19.59	19.3	19.31	7100.0
2016-06-13	ARKQ	ETF	19.514	19.528	19.39	19.39	700.0
2016-06-13	ARKW	ETF	22.38	22.38	22.321	22.355	3000.0
2016-06-13	ASEA	ETF	13.0	13.0	12.93	13.0	3700.0
2016-06-13	ASET	ETF	26.03	26.03	26.03	26.03	100.0
2016-06-13	ASHR	ETF	22.83	22.98	22.8	22.8	1826200.0
2016-06-13	ASHS	ETF	31.77	31.88	31.72	31.77	50300.0
2016-06-13	ATMP	ETF	21.31	21.35	21.09	21.18	8800.0
2016-06-13	BAB	ETF	31.33	31.33	31.1501	31.25	123458.0
2016-06-13	BAL	ETF	43.32	43.32	42.3153	42.38	9011.0
2016-06-13	BBC	ETF	19.59	19.925	19.3734	19.504	23097.0
2016-06-13	BBH	ETF	104.72	106.33	104.24	104.34	67600.0
2016-06-13	BBP	ETF	27.04	27.252	26.83	27.0	25700.0
2016-06-13	BCM	ETF	27.51	27.66	27.51	27.565	655.0
2016-06-13	BFIT	ETF	15.09	15.1	15.09	15.1	1006.0

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

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