PREVIEW / etf_daily / 2016-04-14

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-14.parquet
  size:    51 KB
  rows:    1,271

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-04-14	SPY	ETF	208.07	208.6	207.6	208.01	65212900.0
2016-04-14	QQQ	ETF	110.0	111.33	110.0	110.92	17199671.0
2016-04-14	IWM	ETF	112.26	112.7	111.88	112.17	25538600.0
2016-04-14	DIA	ETF	179.03	179.5	178.75	179.11	3689700.0
2016-04-14	GLD	ETF	118.09	118.19	116.95	117.11	13165800.0
2016-04-14	TLT	ETF	130.91	131.31	130.49	130.76	6967000.0
2016-04-14	AADR	ETF	38.98	38.98	38.98	38.98	1000.0
2016-04-14	AAXJ	ETF	55.5	55.5	55.29	55.41	1755400.0
2016-04-14	ACTX	ETF	5.9001	5.9001	4.13	5.31	1385.0
2016-04-14	ACWF	ETF	23.36	23.3689	23.36	23.3689	4370.0
2016-04-14	ACWI	ETF	56.99	57.11	56.87	56.99	1444300.0
2016-04-14	ACWV	ETF	74.16	74.17	73.96	74.01	84300.0
2016-04-14	ACWX	ETF	40.45	40.46	40.31	40.36	422239.0
2016-04-14	ADRE	ETF	31.93	31.93	31.71	31.79	2760.0
2016-04-14	AFK	ETF	19.34	19.55	19.34	19.46	82482.0
2016-04-14	AFTY	ETF	13.023	13.04	12.99	12.99	35400.0
2016-04-14	AGG	ETF	110.76	110.81	110.64	110.64	3596400.0
2016-04-14	AGGY	ETF	50.63	50.73	50.6	50.699	3500.0
2016-04-14	AGQ	ETF	36.06	36.36	35.65	35.8	152200.0
2016-04-14	AGZ	ETF	114.59	114.93	114.43	114.61	41190.0
2016-04-14	AGZD	ETF	23.84	23.885	23.78	23.78	1400.0
2016-04-14	AIA	ETF	44.03	44.03	43.8689	43.9503	6708.0
2016-04-14	AIQ	ETF	7.11	7.11	6.95	7.0	5345.0
2016-04-14	AIRR	ETF	17.79	17.84	17.79	17.84	2000.0
2016-04-14	AIVI	ETF	38.96	39.04	38.89	39.0	11400.0
2016-04-14	ALTY	ETF	14.48	14.5	14.48	14.497	2000.0
2016-04-14	AMJ	ETF	27.95	28.06	27.46	27.66	1081968.0
2016-04-14	AMLP	ETF	57.1	57.1	55.8	56.3	2172100.0
2016-04-14	AMZA	ETF	93.5	95.0	90.9	91.6	5990.0
2016-04-14	ANGL	ETF	26.15	26.3	26.14	26.26	50100.0
2016-04-14	AOA	ETF	45.87	45.91	45.68	45.7	30500.0
2016-04-14	AOK	ETF	32.49	32.49	32.4074	32.43	34852.0
2016-04-14	AOM	ETF	35.0	35.0199	34.84	34.91	66581.0
2016-04-14	AOR	ETF	39.78	39.83	39.5701	39.66	109559.0
2016-04-14	ARGT	ETF	20.11	20.2	19.98	20.19	41800.0
2016-04-14	ARKG	ETF	18.68	18.68	18.68	18.68	200.0
2016-04-14	ARKK	ETF	20.02	20.02	20.02	20.02	300.0
2016-04-14	ARKQ	ETF	19.67	19.814	19.67	19.7	3000.0
2016-04-14	ARKW	ETF	21.07	21.23	21.07	21.23	2100.0
2016-04-14	ASEA	ETF	13.5	13.58	13.5	13.51	3000.0
2016-04-14	ASHR	ETF	25.19	25.19	24.95	25.04	3091100.0
2016-04-14	ASHS	ETF	35.95	36.31	35.95	36.31	34300.0
2016-04-14	ATMP	ETF	18.98	19.17	18.73	18.87	41300.0
2016-04-14	BAB	ETF	30.26	30.39	30.22	30.33	310886.0
2016-04-14	BAL	ETF	39.97	40.34	39.84	40.3	11486.0
2016-04-14	BBC	ETF	21.11	21.2599	20.9401	21.0815	3906.0
2016-04-14	BBH	ETF	110.31	111.54	110.31	110.94	61700.0
2016-04-14	BBP	ETF	26.679	26.679	26.52	26.63	4800.0
2016-04-14	BFOR	ETF	7.6475	7.6675	7.6375	7.64	30400.0
2016-04-14	BIB	ETF	47.74	47.93	46.663	47.41	607710.0

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

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