PREVIEW / etf_daily / 2017-09-27

all etf daily files

  file:    by_date/etf_daily/2017/2017-09-27.parquet
  size:    57 KB
  rows:    1,463

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
2017-09-27	SPY	ETF	249.88	250.49	248.87	250.05	81001400.0
2017-09-27	QQQ	ETF	143.93	145.0	143.57	144.46	33249403.0
2017-09-27	IWM	ETF	145.63	147.86	145.16	147.44	66351700.0
2017-09-27	DIA	ETF	223.4	223.52	222.35	223.12	2381500.0
2017-09-27	GLD	ETF	122.04	122.51	121.88	121.98	6903900.0
2017-09-27	TLT	ETF	124.87	125.3	124.61	124.85	12145700.0
2017-09-27	AADR	ETF	54.44	54.76	54.3	54.71	38800.0
2017-09-27	AAXJ	ETF	71.38	71.65	71.17	71.52	1050300.0
2017-09-27	ACSI	ETF	29.195	29.195	29.01	29.16	2427.0
2017-09-27	ACTX	ETF	64.9006	69.0306	59.0005	66.0806	357.0
2017-09-27	ACWF	ETF	28.78	28.78	28.72	28.7438	5576.0
2017-09-27	ACWI	ETF	68.33	68.48	68.16	68.36	801000.0
2017-09-27	ACWV	ETF	81.08	81.08	80.77	81.01	51500.0
2017-09-27	ACWX	ETF	47.88	47.9985	47.815	47.95	939043.0
2017-09-27	ADRE	ETF	41.82	41.9299	41.558	41.9299	2877.0
2017-09-27	AFK	ETF	23.3036	23.44	23.3036	23.44	796.0
2017-09-27	AFTY	ETF	17.17	17.17	16.756	16.791	600.0
2017-09-27	AGG	ETF	109.67	109.75	109.6	109.67	3042800.0
2017-09-27	AGGY	ETF	50.68	50.7	50.611	50.69	12400.0
2017-09-27	AGNG	ETF	19.16	19.23	19.137	19.16	6800.0
2017-09-27	AGQ	ETF	33.58	34.2	33.55	33.58	84800.0
2017-09-27	AGZ	ETF	113.68	113.84	113.6338	113.7	26265.0
2017-09-27	AGZD	ETF	24.06	24.07	24.06	24.07	1000.0
2017-09-27	AIA	ETF	60.99	61.05	60.6664	60.89	23424.0
2017-09-27	AIRR	ETF	25.67	26.076	25.52	26.03	28800.0
2017-09-27	AIVI	ETF	42.44	42.57	42.38	42.53	9300.0
2017-09-27	ALTY	ETF	15.97	15.97	15.645	15.67	5900.0
2017-09-27	AMJ	ETF	28.54	28.55	28.16	28.32	830476.0
2017-09-27	AMLP	ETF	56.7	57.0	55.9	56.2	1140640.0
2017-09-27	AMZA	ETF	93.9	94.1	92.3	93.2	115240.0
2017-09-27	ANGL	ETF	30.22	30.31	30.22	30.28	1085400.0
2017-09-27	AOA	ETF	53.16	53.33	53.06	53.21	48200.0
2017-09-27	AOK	ETF	34.4	34.4	34.35	34.35	54342.0
2017-09-27	AOM	ETF	37.9	37.9	37.75	37.87	93228.0
2017-09-27	AOR	ETF	44.63	44.65	44.4901	44.61	39201.0
2017-09-27	ARCM	ETF	100.8	100.8	100.8	100.8	20.0
2017-09-27	ARGT	ETF	31.16	31.34	30.89	31.03	76800.0
2017-09-27	ARKG	ETF	25.35	25.6	25.19	25.54	29800.0
2017-09-27	ARKK	ETF	33.49	33.95	33.44	33.83	106700.0
2017-09-27	ARKQ	ETF	31.22	31.63	31.2	31.54	25200.0
2017-09-27	ARKW	ETF	39.97	40.52	39.97	40.38	39800.0
2017-09-27	ASEA	ETF	15.68	15.68	15.58	15.68	2500.0
2017-09-27	ASET	ETF	27.9662	28.03	27.9143	28.03	3944.0
2017-09-27	ASHR	ETF	29.04	29.05	28.91	28.99	970200.0
2017-09-27	ASHS	ETF	35.95	36.28	35.95	36.25	9600.0
2017-09-27	ATMP	ETF	21.57	21.57	21.27	21.31	23700.0
2017-09-27	BAB	ETF	30.43	30.45	30.38	30.41	90402.0
2017-09-27	BAL	ETF	45.1	45.442	45.1	45.345	3001.0
2017-09-27	BAR	ETF	12.842	12.8553	12.838	12.84	47340.0
2017-09-27	BBC	ETF	28.04	28.69	28.04	28.51	11339.0

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

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