PREVIEW / etf_daily / 2016-03-16

all etf daily files

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

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-03-16	SPY	ETF	201.6	203.82	201.55	203.34	129303200.0
2016-03-16	QQQ	ETF	106.37	107.86	106.34	107.58	31693050.0
2016-03-16	IWM	ETF	105.73	107.33	105.73	106.99	37952200.0
2016-03-16	DIA	ETF	172.21	173.94	172.17	173.47	3556200.0
2016-03-16	GLD	ETF	117.42	120.76	117.34	120.59	17334000.0
2016-03-16	TLT	ETF	127.75	128.52	127.37	128.26	9728900.0
2016-03-16	AADR	ETF	36.85	37.5	36.85	37.49	7400.0
2016-03-16	AAXJ	ETF	52.19	53.44	52.09	53.34	2482000.0
2016-03-16	ACTX	ETF	4.13	5.9001	4.13	5.9001	2719.0
2016-03-16	ACWI	ETF	54.61	55.47	54.61	55.4	1425700.0
2016-03-16	ACWV	ETF	71.53	72.38	71.39	72.29	213100.0
2016-03-16	ACWX	ETF	38.45	39.24	38.45	39.21	481931.0
2016-03-16	ADRE	ETF	29.0815	29.88	29.08	29.8799	6674.0
2016-03-16	AFK	ETF	18.41	18.98	18.4	18.98	11453.0
2016-03-16	AFTY	ETF	12.57	12.78	12.54	12.78	35300.0
2016-03-16	AGG	ETF	109.39	109.86	109.29	109.85	1888200.0
2016-03-16	AGGY	ETF	49.841	49.92	49.795	49.92	4200.0
2016-03-16	AGQ	ETF	32.15	34.0	32.05	33.87	175800.0
2016-03-16	AGZ	ETF	113.78	114.14	113.7101	114.14	31327.0
2016-03-16	AIA	ETF	41.49	42.4255	41.49	42.38	30461.0
2016-03-16	AIQ	ETF	6.88	7.24	6.8	7.0	17209.0
2016-03-16	AIRR	ETF	16.58	16.94	16.58	16.94	500.0
2016-03-16	AIVI	ETF	37.5	38.17	37.43	38.16	16000.0
2016-03-16	AMJ	ETF	26.02	27.13	25.97	27.03	2743353.0
2016-03-16	AMLP	ETF	52.45	54.95	52.25	54.6	2498520.0
2016-03-16	AMUB	ETF	16.71	16.74	16.71	16.74	300.0
2016-03-16	AMZA	ETF	85.6	92.8	85.6	91.4	4910.0
2016-03-16	ANGL	ETF	25.43	25.71	25.38	25.67	60500.0
2016-03-16	AOA	ETF	44.22	44.76	44.22	44.7	40000.0
2016-03-16	AOK	ETF	31.72	31.95	31.72	31.94	19873.0
2016-03-16	AOM	ETF	34.13	34.39	34.084	34.39	21938.0
2016-03-16	AOR	ETF	38.5	38.976	38.5	38.93	87612.0
2016-03-16	ARGT	ETF	18.66	19.05	18.62	19.05	40300.0
2016-03-16	ARKG	ETF	16.486	16.486	16.486	16.486	100.0
2016-03-16	ARKK	ETF	17.84	17.99	17.84	17.99	2200.0
2016-03-16	ARKQ	ETF	17.805	18.02	17.805	18.02	400.0
2016-03-16	ARKW	ETF	19.7	19.959	19.7	19.954	700.0
2016-03-16	ASHR	ETF	23.16	23.81	23.14	23.79	2028000.0
2016-03-16	ASHS	ETF	30.79	31.24	30.7	31.1	40300.0
2016-03-16	ASHX	ETF	21.08	21.08	21.08	21.08	100.0
2016-03-16	ATMP	ETF	17.74	18.21	17.72	18.18	58700.0
2016-03-16	BAB	ETF	29.81	29.81	29.69	29.8	283779.0
2016-03-16	BAL	ETF	37.94	38.249	37.82	38.2399	9818.0
2016-03-16	BBC	ETF	17.525	17.776	17.0	17.2672	16369.0
2016-03-16	BBH	ETF	99.5	101.04	98.25	99.45	92500.0
2016-03-16	BBP	ETF	23.2	23.516	22.68	23.017	9200.0
2016-03-16	BCM	ETF	24.506	24.8156	24.505	24.7848	4494.0
2016-03-16	BFOR	ETF	7.3125	7.3725	7.3	7.3575	17600.0
2016-03-16	BIB	ETF	38.11	39.36	36.75	37.81	1070283.0
2016-03-16	BIL	ETF	91.36	91.38	91.36	91.38	306250.0

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

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