PREVIEW / etf_daily / 2017-10-12

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-12.parquet
  size:    57 KB
  rows:    1,444

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-10-12	SPY	ETF	254.66	255.06	254.37	254.64	47065100.0
2017-10-12	QQQ	ETF	147.84	148.355	147.615	147.77	14513477.0
2017-10-12	IWM	ETF	149.46	150.01	149.02	149.64	17185600.0
2017-10-12	DIA	ETF	228.49	228.81	228.15	228.33	1307300.0
2017-10-12	GLD	ETF	122.84	123.04	122.5	122.89	3037600.0
2017-10-12	TLT	ETF	124.55	124.98	124.24	124.95	7141600.0
2017-10-12	AADR	ETF	56.97	57.04	56.81	56.94	28100.0
2017-10-12	AAXJ	ETF	74.7	74.8	74.54	74.56	1086800.0
2017-10-12	ACSI	ETF	29.36	29.43	29.321	29.39	5603.0
2017-10-12	ACTX	ETF	60.1805	60.1805	53.1005	58.4105	166.0
2017-10-12	ACWF	ETF	29.54	29.73	29.54	29.699	2229.0
2017-10-12	ACWI	ETF	69.73	69.89	69.7	69.83	1388600.0
2017-10-12	ACWV	ETF	82.34	82.6	82.34	82.54	193600.0
2017-10-12	ACWX	ETF	49.03	49.17	49.02	49.08	306739.0
2017-10-12	ADRE	ETF	43.48	43.48	42.9901	43.175	22418.0
2017-10-12	AFK	ETF	23.7	23.97	23.57	23.84	8175.0
2017-10-12	AFTY	ETF	17.42	17.439	17.377	17.42	8700.0
2017-10-12	AGG	ETF	109.56	109.61	109.48	109.59	1933400.0
2017-10-12	AGGY	ETF	50.77	50.79	50.72	50.77	15600.0
2017-10-12	AGNG	ETF	19.547	19.58	19.5	19.58	6200.0
2017-10-12	AGQ	ETF	35.24	35.56	35.0	35.41	58400.0
2017-10-12	AGZ	ETF	113.532	113.609	113.4833	113.58	7151.0
2017-10-12	AGZD	ETF	24.055	24.1	24.05	24.1	2600.0
2017-10-12	AIA	ETF	63.73	63.8819	63.73	63.79	28890.0
2017-10-12	AIRR	ETF	26.035	26.185	26.035	26.1	6600.0
2017-10-12	AIVI	ETF	42.89	42.98	42.86	42.98	6600.0
2017-10-12	ALTY	ETF	15.8	15.8	15.705	15.754	3200.0
2017-10-12	AMJ	ETF	28.24	28.59	28.24	28.46	1093906.0
2017-10-12	AMLP	ETF	56.8	56.95	56.4	56.5	1071560.0
2017-10-12	AMZA	ETF	89.8	90.0	89.1	89.6	130950.0
2017-10-12	ANGL	ETF	30.18	30.23	30.18	30.2	225500.0
2017-10-12	AOA	ETF	54.12	54.13	54.01	54.06	39900.0
2017-10-12	AOK	ETF	34.62	34.62	34.57	34.6	41645.0
2017-10-12	AOM	ETF	38.01	38.1	38.01	38.09	90308.0
2017-10-12	AOR	ETF	45.06	45.12	45.0338	45.11	104499.0
2017-10-12	ARGT	ETF	32.25	32.36	31.68	31.76	66100.0
2017-10-12	ARKG	ETF	26.78	26.78	26.4	26.522	36000.0
2017-10-12	ARKK	ETF	34.91	35.05	34.79	34.92	167100.0
2017-10-12	ARKQ	ETF	32.74	32.835	32.562	32.7	54100.0
2017-10-12	ARKW	ETF	41.6	41.84	41.53	41.69	89600.0
2017-10-12	ASEA	ETF	15.89	15.91	15.89	15.9	800.0
2017-10-12	ASET	ETF	28.3691	28.38	28.3683	28.369	1410.0
2017-10-12	ASHR	ETF	30.2	30.28	30.19	30.24	572600.0
2017-10-12	ASHS	ETF	36.9	36.98	36.9	36.97	7500.0
2017-10-12	ATMP	ETF	21.37	21.62	21.37	21.53	10000.0
2017-10-12	BAB	ETF	30.41	30.5	30.41	30.495	118450.0
2017-10-12	BAL	ETF	45.29	45.29	44.7721	44.7792	1748.0
2017-10-12	BBC	ETF	30.0	30.0	29.3816	29.3816	6327.0
2017-10-12	BBH	ETF	135.26	135.83	134.74	135.11	13800.0
2017-10-12	BBP	ETF	41.41	41.638	41.22	41.56	11000.0

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

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