PREVIEW / etf_daily / 2017-10-04

all etf daily files

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

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-04	SPY	ETF	252.69	253.44	252.56	253.16	55953600.0
2017-10-04	QQQ	ETF	145.6	146.34	145.47	146.03	26381099.0
2017-10-04	IWM	ETF	150.09	150.61	149.39	149.85	22024700.0
2017-10-04	DIA	ETF	226.39	226.68	226.18	226.41	1746900.0
2017-10-04	GLD	ETF	121.21	121.27	120.71	121.17	6475200.0
2017-10-04	TLT	ETF	124.53	124.59	123.88	124.41	7447000.0
2017-10-04	AADR	ETF	56.57	56.59	56.3	56.57	32400.0
2017-10-04	AAXJ	ETF	73.38	73.48	73.25	73.35	516200.0
2017-10-04	ACSI	ETF	29.42	29.4299	29.36	29.37	3473.0
2017-10-04	ACTX	ETF	59.0005	63.7206	53.1005	58.4105	675.0
2017-10-04	ACWF	ETF	29.24	29.41	29.24	29.35	2456.0
2017-10-04	ACWI	ETF	69.17	69.3	69.12	69.22	1151000.0
2017-10-04	ACWV	ETF	81.64	81.85	81.57	81.84	53200.0
2017-10-04	ACWX	ETF	48.57	48.6193	48.54	48.57	138886.0
2017-10-04	ADRE	ETF	42.8045	42.8636	42.75	42.75	2063.0
2017-10-04	AFK	ETF	23.32	23.3299	23.2399	23.32	5118.0
2017-10-04	AFTY	ETF	17.35	17.376	17.35	17.376	1200.0
2017-10-04	AGG	ETF	109.56	109.57	109.41	109.49	2673200.0
2017-10-04	AGGY	ETF	50.77	50.81	50.72	50.81	13400.0
2017-10-04	AGNG	ETF	19.48	19.62	19.48	19.594	7000.0
2017-10-04	AGQ	ETF	33.11	33.24	32.7	32.99	103600.0
2017-10-04	AGZ	ETF	113.52	113.52	113.369	113.42	8267.0
2017-10-04	AGZD	ETF	24.04	24.06	24.005	24.02	3000.0
2017-10-04	AIA	ETF	62.18	62.425	62.18	62.346	17731.0
2017-10-04	AIRR	ETF	26.46	26.46	26.174	26.218	12000.0
2017-10-04	AIVI	ETF	42.36	42.36	42.26	42.28	7600.0
2017-10-04	ALTY	ETF	15.726	15.74	15.726	15.74	3200.0
2017-10-04	AMJ	ETF	28.33	28.48	28.29	28.44	4729233.0
2017-10-04	AMLP	ETF	56.6	56.75	56.25	56.65	1288480.0
2017-10-04	AMZA	ETF	89.0	89.3	88.3	88.8	173370.0
2017-10-04	ANGL	ETF	30.2	30.23	30.18	30.19	128100.0
2017-10-04	AOA	ETF	53.7	53.73	53.57	53.61	53900.0
2017-10-04	AOK	ETF	34.42	34.5	34.42	34.5	41614.0
2017-10-04	AOM	ETF	38.01	38.01	37.87	37.87	173541.0
2017-10-04	AOR	ETF	44.77	44.86	44.77	44.78	163746.0
2017-10-04	ARCM	ETF	99.3	99.3	99.3	99.3	80.0
2017-10-04	ARGT	ETF	32.34	32.48	32.04	32.29	63700.0
2017-10-04	ARKG	ETF	26.7	26.85	26.458	26.49	37500.0
2017-10-04	ARKK	ETF	34.91	35.0	34.641	34.66	98300.0
2017-10-04	ARKQ	ETF	32.47	32.519	32.25	32.37	29700.0
2017-10-04	ARKW	ETF	41.05	41.21	40.93	41.04	40900.0
2017-10-04	ASEA	ETF	15.74	15.76	15.74	15.75	2700.0
2017-10-04	ASET	ETF	28.0113	28.1	28.0	28.1	3234.0
2017-10-04	ASHR	ETF	30.0	30.05	29.95	30.03	597600.0
2017-10-04	ASHS	ETF	37.31	37.32	37.23	37.31	3700.0
2017-10-04	ASHX	ETF	22.2352	22.2352	22.2177	22.2177	350.0
2017-10-04	ATMP	ETF	21.6	21.6	21.38	21.42	18000.0
2017-10-04	BAB	ETF	30.43	30.43	30.3111	30.35	54909.0
2017-10-04	BAL	ETF	44.6416	46.074	44.6416	45.39	6322.0
2017-10-04	BAR	ETF	12.732	12.738	12.728	12.738	77650.0

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

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