PREVIEW / etf_daily / 2016-05-03

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-03.parquet
  size:    51 KB
  rows:    1,270

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-05-03	SPY	ETF	206.52	206.8	205.28	206.16	106422100.0
2016-05-03	QQQ	ETF	105.96	106.4399	105.45	105.73	38569433.0
2016-05-03	IWM	ETF	112.55	112.56	110.93	111.62	37929600.0
2016-05-03	DIA	ETF	177.48	177.83	176.48	177.3	4643200.0
2016-05-03	GLD	ETF	123.73	123.82	122.51	122.96	9063600.0
2016-05-03	TLT	ETF	129.55	130.02	129.35	129.43	10736700.0
2016-05-03	AADR	ETF	38.33	38.33	38.21	38.21	1000.0
2016-05-03	AAXJ	ETF	53.25	53.37	52.8	52.83	768500.0
2016-05-03	ACTX	ETF	4.72	4.72	4.13	4.13	582.0
2016-05-03	ACWI	ETF	56.48	56.64	56.23	56.34	2439400.0
2016-05-03	ACWV	ETF	73.87	73.98	73.57	73.71	139700.0
2016-05-03	ACWX	ETF	40.19	40.24	39.89	39.92	708167.0
2016-05-03	ADRE	ETF	30.65	30.65	30.3494	30.36	5399.0
2016-05-03	AFK	ETF	20.59	20.75	20.21	20.4	9705.0
2016-05-03	AFTY	ETF	12.8	12.83	12.8	12.8	400.0
2016-05-03	AGG	ETF	110.89	110.95	110.75	110.81	3044900.0
2016-05-03	AGGY	ETF	51.014	51.03	50.95	51.0	1900.0
2016-05-03	AGQ	ETF	42.5	42.5	41.02	41.6	226600.0
2016-05-03	AGZ	ETF	114.75	114.76	114.5101	114.6401	25731.0
2016-05-03	AGZD	ETF	23.85	23.85	23.85	23.85	400.0
2016-05-03	AIA	ETF	42.36	42.36	41.96	41.97	9156.0
2016-05-03	AIQ	ETF	7.11	7.1308	6.96	7.02	29925.0
2016-05-03	AIRR	ETF	17.77	17.77	17.72	17.72	1500.0
2016-05-03	AIVI	ETF	39.37	39.37	38.98	38.98	9800.0
2016-05-03	ALTY	ETF	14.4	14.4	14.352	14.352	1000.0
2016-05-03	AMJ	ETF	29.48	29.5	28.69	29.04	3263868.0
2016-05-03	AMLP	ETF	59.9	60.25	58.25	59.1	3329000.0
2016-05-03	AMZA	ETF	101.6	101.6	97.8	100.4	14470.0
2016-05-03	ANGL	ETF	27.14	27.14	26.9	26.94	45900.0
2016-05-03	AOA	ETF	45.65	45.65	45.29	45.39	76400.0
2016-05-03	AOK	ETF	32.4	32.45	32.31	32.39	27683.0
2016-05-03	AOM	ETF	34.88	34.95	34.8	34.86	45380.0
2016-05-03	AOR	ETF	39.68	39.68	39.45	39.5	124707.0
2016-05-03	ARGT	ETF	20.41	20.44	20.02	20.12	209800.0
2016-05-03	ARKG	ETF	17.42	17.42	17.42	17.42	100.0
2016-05-03	ARKK	ETF	18.72	18.72	18.72	18.72	200.0
2016-05-03	ARKQ	ETF	18.67	18.671	18.5	18.59	17700.0
2016-05-03	ARKW	ETF	21.03	21.03	20.75	20.75	1700.0
2016-05-03	ASEA	ETF	13.2	13.2	13.2	13.2	200.0
2016-05-03	ASET	ETF	25.92	25.92	25.92	25.92	200.0
2016-05-03	ASHR	ETF	24.25	24.3	24.06	24.12	1382000.0
2016-05-03	ASHS	ETF	34.36	34.36	33.95	33.99	84600.0
2016-05-03	ASHX	ETF	21.49	21.53	21.49	21.51	745.0
2016-05-03	ATMP	ETF	20.01	20.12	19.69	19.96	264500.0
2016-05-03	BAB	ETF	30.06	30.24	30.05	30.24	91473.0
2016-05-03	BAL	ETF	42.43	42.43	41.172	41.8199	27358.0
2016-05-03	BBC	ETF	19.84	19.84	19.33	19.3371	5780.0
2016-05-03	BBH	ETF	106.16	106.7	105.22	105.37	59200.0
2016-05-03	BBP	ETF	25.89	25.89	25.42	25.42	2700.0
2016-05-03	BCM	ETF	26.15	26.15	25.9	26.0329	4171.0

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

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