PREVIEW / etf_daily / 2016-01-14

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-14.parquet
  size:    50 KB
  rows:    1,246

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-01-14	SPY	ETF	189.55	193.26	187.66	191.93	240795600.0
2016-01-14	QQQ	ETF	102.3	104.98	100.67	104.07	78445735.0
2016-01-14	IWM	ETF	100.86	102.71	99.19	101.77	69373400.0
2016-01-14	DIA	ETF	162.02	164.69	160.61	163.59	14749500.0
2016-01-14	GLD	ETF	103.75	104.18	102.5	103.02	9989100.0
2016-01-14	TLT	ETF	124.47	124.97	123.34	123.82	12873800.0
2016-01-14	AADR	ETF	35.1	35.67	34.92	35.67	86400.0
2016-01-14	AAXJ	ETF	48.78	49.39	48.38	49.25	1585900.0
2016-01-14	ACTX	ETF	7.0801	8.2601	7.0801	7.0801	2025.0
2016-01-14	ACWI	ETF	51.71	52.57	51.23	52.26	5729200.0
2016-01-14	ACWV	ETF	66.28	66.89	66.02	66.56	844800.0
2016-01-14	ACWX	ETF	36.58	37.12	36.341	36.96	2739412.0
2016-01-14	ADRE	ETF	26.32	27.05	26.194	26.9395	9275.0
2016-01-14	AFK	ETF	15.49	15.77	15.27	15.67	53486.0
2016-01-14	AFTY	ETF	12.47	12.76	12.47	12.73	18200.0
2016-01-14	AGG	ETF	108.79	108.89	108.58	108.8	5322700.0
2016-01-14	AGQ	ETF	27.11	27.22	26.74	27.12	196500.0
2016-01-14	AGZ	ETF	113.56	113.7699	113.4401	113.55	45013.0
2016-01-14	AGZD	ETF	23.84	23.85	23.84	23.85	13400.0
2016-01-14	AIA	ETF	38.38	38.97	38.15	38.81	45276.0
2016-01-14	AIQ	ETF	6.93	7.2	6.75	6.99	19166.0
2016-01-14	AIRR	ETF	14.82	14.997	14.72	14.91	1700.0
2016-01-14	AIVI	ETF	35.77	36.18	35.54	36.05	50600.0
2016-01-14	ALTY	ETF	13.01	13.05	12.772	13.032	1600.0
2016-01-14	AMJ	ETF	23.89	25.32	23.65	25.25	7996946.0
2016-01-14	AMLP	ETF	49.1	51.9	48.3	51.8	4410080.0
2016-01-14	AMZA	ETF	77.3	85.5	77.1	85.5	4690.0
2016-01-14	ANGL	ETF	24.05	24.23	24.03	24.16	216600.0
2016-01-14	AOA	ETF	42.3	42.84	42.07	42.63	119000.0
2016-01-14	AOK	ETF	31.07	31.16	30.97	31.1	211667.0
2016-01-14	AOM	ETF	33.2	33.333	33.067	33.28	172009.0
2016-01-14	AOR	ETF	37.22	37.52	37.018	37.42	651308.0
2016-01-14	ARGT	ETF	16.67	16.77	16.3	16.68	49900.0
2016-01-14	ARKG	ETF	17.5	17.68	16.97	17.68	1800.0
2016-01-14	ARKK	ETF	17.75	18.03	17.58	18.03	1200.0
2016-01-14	ARKQ	ETF	16.735	16.735	16.735	16.735	400.0
2016-01-14	ARKW	ETF	20.35	20.497	20.054	20.497	900.0
2016-01-14	ASEA	ETF	11.4	11.52	11.4	11.52	2700.0
2016-01-14	ASET	ETF	23.09	23.2	23.09	23.2	600.0
2016-01-14	ASHR	ETF	23.63	23.97	23.44	23.95	2571200.0
2016-01-14	ASHS	ETF	32.45	32.88	32.0	32.72	61000.0
2016-01-14	ASHX	ETF	21.215	21.5	21.215	21.5	400.0
2016-01-14	ATMP	ETF	15.6	16.65	15.27	16.61	42600.0
2016-01-14	BAB	ETF	29.69	29.73	29.534	29.61	185431.0
2016-01-14	BAL	ETF	41.15	41.15	40.98	41.05	1189.0
2016-01-14	BBC	ETF	20.71	22.06	19.8	21.8	26930.0
2016-01-14	BBH	ETF	108.6	112.96	105.82	111.67	151500.0
2016-01-14	BBP	ETF	24.63	25.91	23.89	25.69	30900.0
2016-01-14	BCM	ETF	22.18	22.32	22.18	22.31	6145.0
2016-01-14	BFOR	ETF	6.7975	6.9225	6.715	6.87	200000.0

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

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