PREVIEW / etf_daily / 2016-02-03

all etf daily files

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

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-02-03	SPY	ETF	191.41	191.78	187.1	191.3	205054900.0
2016-02-03	QQQ	ETF	102.8	102.83	99.88	101.66	61572882.0
2016-02-03	IWM	ETF	101.06	101.07	98.14	100.41	55262500.0
2016-02-03	DIA	ETF	162.42	163.75	159.48	163.2	14249300.0
2016-02-03	GLD	ETF	107.91	109.58	107.9	109.25	15785200.0
2016-02-03	TLT	ETF	128.28	129.94	127.92	127.95	13309000.0
2016-02-03	AADR	ETF	36.0	36.34	35.72	36.25	18000.0
2016-02-03	AAXJ	ETF	48.31	48.89	47.5	48.87	2164300.0
2016-02-03	ACTX	ETF	5.9001	5.9001	4.72	4.779	244.0
2016-02-03	ACWF	ETF	21.7	21.7	21.08	21.17	4396.0
2016-02-03	ACWI	ETF	52.02	52.15	50.9	52.04	3575900.0
2016-02-03	ACWV	ETF	68.54	68.66	67.6	68.55	199300.0
2016-02-03	ACWX	ETF	36.62	36.83	35.96	36.81	2039251.0
2016-02-03	ADRE	ETF	26.43	26.533	25.942	26.49	5598.0
2016-02-03	AFK	ETF	16.12	16.59	16.01	16.54	10833.0
2016-02-03	AFTY	ETF	11.549	11.66	11.53	11.66	5200.0
2016-02-03	AGG	ETF	109.26	109.64	109.2	109.31	3700300.0
2016-02-03	AGGY	ETF	49.729	49.729	49.595	49.635	2800.0
2016-02-03	AGQ	ETF	29.27	30.79	29.2	30.14	356800.0
2016-02-03	AGZ	ETF	114.16	114.37	114.07	114.13	20050.0
2016-02-03	AGZD	ETF	23.655	23.66	23.54	23.545	14200.0
2016-02-03	AIA	ETF	37.86	38.35	37.36	38.28	65778.0
2016-02-03	AIQ	ETF	7.3	7.3407	6.87	6.94	14730.0
2016-02-03	AIRR	ETF	14.781	14.817	14.781	14.817	2500.0
2016-02-03	AIVI	ETF	36.34	36.53	35.77	36.53	26200.0
2016-02-03	AMJ	ETF	25.48	25.48	23.7	24.8	7169346.0
2016-02-03	AMLP	ETF	51.3	51.3	47.7	50.2	3415000.0
2016-02-03	AMZA	ETF	86.4	87.5	77.6	81.9	6420.0
2016-02-03	ANGL	ETF	23.88	23.93	23.68	23.78	89500.0
2016-02-03	AOA	ETF	42.5	42.54	41.96	42.48	61300.0
2016-02-03	AOK	ETF	31.14	31.18	31.025	31.11	35823.0
2016-02-03	AOM	ETF	33.38	33.39	33.08	33.29	44871.0
2016-02-03	AOR	ETF	37.33	37.3734	36.99	37.37	149232.0
2016-02-03	ARGT	ETF	16.86	16.91	16.53	16.62	7200.0
2016-02-03	ARKG	ETF	16.285	16.285	16.285	16.285	200.0
2016-02-03	ARKK	ETF	16.31	16.367	16.31	16.367	300.0
2016-02-03	ARKQ	ETF	15.79	15.79	15.79	15.79	100.0
2016-02-03	ARKW	ETF	18.49	18.635	18.246	18.635	2300.0
2016-02-03	ASEA	ETF	11.57	11.78	11.45	11.77	9500.0
2016-02-03	ASHR	ETF	21.74	22.17	21.67	22.16	1328000.0
2016-02-03	ASHS	ETF	30.28	30.31	29.54	30.31	75000.0
2016-02-03	ASHX	ETF	19.825	19.91	19.75	19.9	9147.0
2016-02-03	ATMP	ETF	16.52	16.52	15.6	16.3	179500.0
2016-02-03	BAB	ETF	30.0	30.144	29.955	29.98	293941.0
2016-02-03	BAL	ETF	41.1619	41.1619	40.94	40.94	2862.0
2016-02-03	BBC	ETF	18.35	18.39	17.58	18.39	12910.0
2016-02-03	BBH	ETF	99.51	100.91	96.57	100.77	311600.0
2016-02-03	BBP	ETF	23.62	23.62	22.785	23.5	6300.0
2016-02-03	BCM	ETF	22.9	23.19	22.9	23.19	18400.0
2016-02-03	BFOR	ETF	6.84	6.8525	6.6925	6.8125	201200.0

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

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