PREVIEW / etf_daily / 2015-08-27

all etf daily files

  file:    by_date/etf_daily/2015/2015-08-27.parquet
  size:    49 KB
  rows:    1,223

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
2015-08-27	SPY	ETF	197.02	199.42	195.21	199.27	274143900.0
2015-08-27	QQQ	ETF	104.52	105.71	103.2799	105.64	69377690.0
2015-08-27	IWM	ETF	113.3	115.12	112.36	114.49	49533700.0
2015-08-27	DIA	ETF	164.86	166.49	163.04	166.45	15223700.0
2015-08-27	GLD	ETF	107.33	108.04	107.11	107.73	8102100.0
2015-08-27	TLT	ETF	121.82	122.87	121.65	122.0	9127000.0
2015-08-27	AADR	ETF	37.5	37.92	37.15	37.59	5000.0
2015-08-27	AAXJ	ETF	53.35	54.37	53.28	54.27	2496200.0
2015-08-27	ACTX	ETF	1.77	1.77	1.18	1.18	9719.0
2015-08-27	ACWF	ETF	23.21	23.22	23.21	23.22	3000.0
2015-08-27	ACWI	ETF	55.8	56.44	55.49	56.35	3845500.0
2015-08-27	ACWV	ETF	67.42	68.34	67.2	68.17	292300.0
2015-08-27	ACWX	ETF	40.63	41.2737	40.63	41.17	1782254.0
2015-08-27	ADRE	ETF	29.61	30.31	29.61	30.21	194317.0
2015-08-27	AFK	ETF	19.59	19.995	19.59	19.98	8874.0
2015-08-27	AFTY	ETF	14.68	15.36	14.67	15.36	150200.0
2015-08-27	AGG	ETF	108.95	109.2	108.93	109.1	4040500.0
2015-08-27	AGGY	ETF	49.54	49.54	49.53	49.54	8800.0
2015-08-27	AGQ	ETF	29.4	31.05	29.21	30.39	315000.0
2015-08-27	AGZ	ETF	113.1501	113.92	113.1501	113.72	1555233.0
2015-08-27	AGZD	ETF	24.0	24.0	23.925	23.965	5600.0
2015-08-27	AIA	ETF	42.075	42.98	42.075	42.85	46791.0
2015-08-27	AIQ	ETF	13.65	13.69	13.38	13.6	11478.0
2015-08-27	AIRR	ETF	15.89	16.21	15.89	16.09	27400.0
2015-08-27	AIVI	ETF	40.08	40.59	40.08	40.42	45600.0
2015-08-27	ALTY	ETF	14.35	14.388	14.35	14.388	500.0
2015-08-27	AMJ	ETF	34.37	35.64	34.0	35.5	3747205.0
2015-08-27	AMLP	ETF	70.85	72.45	70.4	72.2	2139480.0
2015-08-27	AMZA	ETF	165.0	178.3	165.0	171.9	4680.0
2015-08-27	ANGL	ETF	26.45	26.49	26.17	26.36	16400.0
2015-08-27	AOA	ETF	44.87	45.1	44.61	45.07	86200.0
2015-08-27	AOK	ETF	31.67	31.89	31.6504	31.83	32145.0
2015-08-27	AOM	ETF	34.24	34.37	34.04	34.33	116321.0
2015-08-27	AOR	ETF	38.89	39.066	38.67	39.04	194478.0
2015-08-27	ARGT	ETF	16.89	17.9	16.89	17.67	11600.0
2015-08-27	ARKG	ETF	20.796	20.796	20.77	20.77	2300.0
2015-08-27	ARKK	ETF	19.76	20.15	19.76	20.044	2600.0
2015-08-27	ARKQ	ETF	18.29	18.29	18.26	18.26	700.0
2015-08-27	ARKW	ETF	21.95	22.26	21.95	22.26	6000.0
2015-08-27	ASEA	ETF	12.93	13.08	12.93	13.04	7900.0
2015-08-27	ASHR	ETF	31.7	32.94	31.44	32.94	9840000.0
2015-08-27	ASHS	ETF	36.72	39.25	36.72	38.34	111300.0
2015-08-27	ATMP	ETF	23.31	24.17	23.21	24.09	80600.0
2015-08-27	AWAY	ETF	28.47	29.0	28.04	29.0	1813739.0
2015-08-27	BAB	ETF	28.98	29.18	28.89	28.99	30030.0
2015-08-27	BAL	ETF	41.8224	42.19	41.8224	42.19	1018.0
2015-08-27	BBC	ETF	30.5	31.75	30.5	31.0701	12057.0
2015-08-27	BBH	ETF	127.94	130.57	126.96	129.6	164200.0
2015-08-27	BBP	ETF	33.04	33.04	32.201	32.9	28700.0
2015-08-27	BCHP	ETF	18.1101	18.18	18.026	18.0673	3999.0

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

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