PREVIEW / etf_daily / 2016-06-27

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-27.parquet
  size:    52 KB
  rows:    1,301

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-27	SPY	ETF	201.59	201.6	198.65	199.6	230775800.0
2016-06-27	QQQ	ETF	103.6	103.6	101.75	102.22	50044303.0
2016-06-27	IWM	ETF	111.07	111.07	108.19	108.69	58358800.0
2016-06-27	DIA	ETF	172.48	172.48	170.37	171.2	7683900.0
2016-06-27	GLD	ETF	126.44	127.05	125.83	126.68	21228800.0
2016-06-27	TLT	ETF	138.44	139.59	138.4	139.17	16577100.0
2016-06-27	AADR	ETF	37.55	38.25	37.05	38.25	2000.0
2016-06-27	AAXJ	ETF	52.18	52.18	51.21	51.74	1162400.0
2016-06-27	ACTX	ETF	4.13	4.72	3.54	4.13	1555.0
2016-06-27	ACWI	ETF	53.82	53.82	52.92	53.29	3582300.0
2016-06-27	ACWV	ETF	73.35	73.37	72.72	73.14	365100.0
2016-06-27	ACWX	ETF	37.09	37.09	36.36	36.79	1107814.0
2016-06-27	ADRE	ETF	29.2141	29.2635	29.0801	29.2635	3626.0
2016-06-27	AFK	ETF	19.36	19.73	19.0308	19.23	41710.0
2016-06-27	AFTY	ETF	12.179	12.18	12.12	12.12	1700.0
2016-06-27	AGG	ETF	112.33	112.49	112.31	112.33	3018800.0
2016-06-27	AGGY	ETF	51.62	51.66	51.46	51.658	6100.0
2016-06-27	AGQ	ETF	42.73	42.87	42.08	42.6	205500.0
2016-06-27	AGZ	ETF	115.2	116.0999	115.2	115.73	16443.0
2016-06-27	AGZD	ETF	23.695	23.83	23.69	23.78	4200.0
2016-06-27	AIA	ETF	42.48	42.48	41.83	42.18	27911.0
2016-06-27	AIQ	ETF	6.15	6.8	5.88	6.53	83372.0
2016-06-27	AIRR	ETF	17.4	17.4	17.4	17.4	300.0
2016-06-27	AIVI	ETF	35.26	35.26	34.58	34.92	62900.0
2016-06-27	ALTY	ETF	14.74	14.74	14.61	14.61	4000.0
2016-06-27	AMJ	ETF	30.5	30.98	29.8	30.13	4715009.0
2016-06-27	AMLP	ETF	62.6	62.9	60.25	61.0	3587000.0
2016-06-27	AMZA	ETF	112.0	112.0	106.58	108.2	33340.0
2016-06-27	ANGL	ETF	27.23	27.34	26.95	26.98	120800.0
2016-06-27	AOA	ETF	44.14	44.4	43.77	44.02	70600.0
2016-06-27	AOK	ETF	32.28	32.4899	32.1501	32.29	38460.0
2016-06-27	AOM	ETF	34.61	34.75	34.46	34.58	130191.0
2016-06-27	AOR	ETF	38.95	38.9844	38.5412	38.75	148472.0
2016-06-27	ARGT	ETF	21.15	21.3	20.59	20.73	79500.0
2016-06-27	ARKG	ETF	16.18	16.18	16.147	16.156	800.0
2016-06-27	ARKK	ETF	18.34	18.39	18.25	18.26	10400.0
2016-06-27	ARKQ	ETF	18.31	18.31	18.282	18.282	1200.0
2016-06-27	ARKW	ETF	21.42	21.42	20.91	20.91	1700.0
2016-06-27	ASEA	ETF	12.95	12.95	12.71	12.78	25000.0
2016-06-27	ASET	ETF	25.2899	25.2899	25.2899	25.2899	100.0
2016-06-27	ASHR	ETF	23.17	23.21	23.01	23.11	1416600.0
2016-06-27	ASHS	ETF	33.45	33.45	32.89	33.15	21000.0
2016-06-27	ATMP	ETF	21.34	21.34	20.81	21.02	25500.0
2016-06-27	BAB	ETF	31.61	31.61	31.3201	31.47	431133.0
2016-06-27	BAL	ETF	43.15	43.1869	42.5794	42.64	7768.0
2016-06-27	BBC	ETF	17.63	17.68	16.7527	16.83	10703.0
2016-06-27	BBH	ETF	97.94	98.79	95.77	96.23	148400.0
2016-06-27	BBP	ETF	25.44	25.44	24.761	24.871	5700.0
2016-06-27	BCM	ETF	26.716	26.9395	26.716	26.9395	1138.0
2016-06-27	BFOR	ETF	7.3525	7.3525	7.165	7.1925	141600.0

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

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