PREVIEW / etf_daily / 2016-05-05

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-05.parquet
  size:    50 KB
  rows:    1,258

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-05	SPY	ETF	205.56	205.98	204.47	204.97	67619200.0
2016-05-05	QQQ	ETF	105.43	105.66	104.81	105.02	20788119.0
2016-05-05	IWM	ETF	111.15	111.33	110.1	110.26	26249200.0
2016-05-05	DIA	ETF	176.83	177.22	176.0	176.44	1778800.0
2016-05-05	GLD	ETF	122.63	122.73	121.25	122.07	8846900.0
2016-05-05	TLT	ETF	130.06	131.07	129.7	131.01	7870400.0
2016-05-05	AADR	ETF	38.1	38.1	38.1	38.1	600.0
2016-05-05	AAXJ	ETF	52.6	52.66	52.14	52.29	1051500.0
2016-05-05	ACTX	ETF	4.72	4.72	3.54	4.13	302.0
2016-05-05	ACWI	ETF	55.94	56.06	55.65	55.82	1676500.0
2016-05-05	ACWV	ETF	73.66	73.66	73.2	73.38	277900.0
2016-05-05	ACWX	ETF	39.54	39.6067	39.27	39.41	628911.0
2016-05-05	ADRE	ETF	30.72	30.72	30.31	30.39	10650.0
2016-05-05	AFK	ETF	20.09	20.1	19.87	19.87	2538.0
2016-05-05	AFTY	ETF	12.772	12.772	12.72	12.72	2500.0
2016-05-05	AGG	ETF	110.92	111.16	110.8	111.14	3008100.0
2016-05-05	AGGY	ETF	51.01	51.08	50.95	51.0	18700.0
2016-05-05	AGQ	ETF	42.36	42.42	40.7	41.23	181900.0
2016-05-05	AGZ	ETF	114.71	114.99	114.71	114.99	18524.0
2016-05-05	AGZD	ETF	23.99	24.0	23.975	23.975	1200.0
2016-05-05	AIA	ETF	41.83	41.8783	41.57	41.7	32150.0
2016-05-05	AIQ	ETF	7.11	7.11	6.92	6.93	31896.0
2016-05-05	AIRR	ETF	17.661	17.661	17.551	17.56	5400.0
2016-05-05	AIVI	ETF	38.42	38.52	38.22	38.3	10000.0
2016-05-05	ALTY	ETF	14.51	14.51	14.471	14.49	2700.0
2016-05-05	AMJ	ETF	29.84	30.22	29.46	29.64	2335189.0
2016-05-05	AMLP	ETF	60.55	61.75	60.3	60.5	2714120.0
2016-05-05	AMZA	ETF	104.0	105.8	103.16	104.2	10940.0
2016-05-05	ANGL	ETF	26.9	26.9	26.71	26.77	71000.0
2016-05-05	AOA	ETF	45.19	45.19	44.99	45.07	26900.0
2016-05-05	AOK	ETF	32.3	32.33	32.26	32.33	15677.0
2016-05-05	AOM	ETF	34.79	34.8023	34.6601	34.72	34138.0
2016-05-05	AOR	ETF	39.29	39.4	39.2	39.25	76964.0
2016-05-05	ARGT	ETF	20.04	20.29	20.04	20.26	482900.0
2016-05-05	ARKG	ETF	16.76	16.76	16.76	16.76	100.0
2016-05-05	ARKK	ETF	18.16	18.16	18.16	18.16	100.0
2016-05-05	ARKQ	ETF	18.083	18.083	18.076	18.079	500.0
2016-05-05	ARKW	ETF	20.62	20.62	20.346	20.346	1400.0
2016-05-05	ASEA	ETF	13.07	13.07	12.85	12.85	1500.0
2016-05-05	ASHR	ETF	24.13	24.21	24.05	24.14	1179500.0
2016-05-05	ASHS	ETF	34.43	34.45	34.26	34.27	26800.0
2016-05-05	ATMP	ETF	20.29	20.68	20.29	20.48	45100.0
2016-05-05	BAB	ETF	30.34	30.4399	30.2201	30.41	136687.0
2016-05-05	BAL	ETF	42.12	42.12	40.7901	41.2	2498.0
2016-05-05	BBC	ETF	18.01	18.09	17.821	17.87	13398.0
2016-05-05	BBH	ETF	103.59	103.93	102.62	103.75	81200.0
2016-05-05	BBP	ETF	24.67	24.7	24.67	24.7	1200.0
2016-05-05	BCM	ETF	26.19	26.19	25.766	25.766	1190.0
2016-05-05	BDCZ	ETF	20.17	20.17	20.14	20.14	403.0
2016-05-05	BFOR	ETF	7.4775	7.485	7.4375	7.455	57600.0

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

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