PREVIEW / etf_daily / 2017-09-19

all etf daily files

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

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-19	SPY	ETF	250.0	250.07	249.6	249.97	47108100.0
2017-09-19	QQQ	ETF	145.81	146.01	145.31	145.8	20871237.0
2017-09-19	IWM	ETF	143.57	143.69	143.09	143.38	16346300.0
2017-09-19	DIA	ETF	223.37	223.67	223.23	223.58	2042800.0
2017-09-19	GLD	ETF	124.49	124.65	124.03	124.62	5826500.0
2017-09-19	TLT	ETF	126.28	126.31	125.73	125.82	5554900.0
2017-09-19	AADR	ETF	55.02	55.66	54.92	55.56	54200.0
2017-09-19	AAXJ	ETF	73.64	73.84	73.52	73.84	618200.0
2017-09-19	ACSI	ETF	29.06	29.1	29.02	29.02	3177.0
2017-09-19	ACTX	ETF	73.1607	74.9307	70.8006	72.5707	267.0
2017-09-19	ACWF	ETF	28.94	29.0	28.94	29.0	1056.0
2017-09-19	ACWI	ETF	68.81	68.9	68.75	68.84	1515800.0
2017-09-19	ACWV	ETF	81.72	81.77	81.56	81.63	81800.0
2017-09-19	ACWX	ETF	48.48	48.57	48.45	48.55	709577.0
2017-09-19	ADRE	ETF	43.27	43.34	43.05	43.32	9356.0
2017-09-19	AFK	ETF	23.32	23.95	23.25	23.255	7389.0
2017-09-19	AFTY	ETF	17.0	17.0	16.871	16.94	2500.0
2017-09-19	AGG	ETF	109.91	109.96	109.79	109.8	1407200.0
2017-09-19	AGGY	ETF	50.89	50.89	50.8	50.86	19600.0
2017-09-19	AGNG	ETF	19.522	19.53	19.51	19.53	6800.0
2017-09-19	AGQ	ETF	35.49	36.0	35.43	35.85	58600.0
2017-09-19	AGZ	ETF	113.855	113.92	113.83	113.9	4888.0
2017-09-19	AGZD	ETF	24.085	24.085	24.05	24.05	2600.0
2017-09-19	AIA	ETF	62.19	62.24	62.08	62.22	17517.0
2017-09-19	AIRR	ETF	24.73	24.867	24.73	24.83	38500.0
2017-09-19	AIVI	ETF	43.23	43.23	43.13	43.23	4400.0
2017-09-19	ALTY	ETF	15.45	15.69	15.45	15.67	10600.0
2017-09-19	AMJ	ETF	28.33	28.4	28.125	28.17	2204984.0
2017-09-19	AMLP	ETF	56.5	56.55	56.05	56.1	855420.0
2017-09-19	AMZA	ETF	92.9	93.2	92.3	92.4	66730.0
2017-09-19	ANGL	ETF	30.11	30.2	30.02	30.18	678800.0
2017-09-19	AOA	ETF	53.5	53.53	53.42	53.53	45500.0
2017-09-19	AOK	ETF	34.48	34.48	34.43	34.48	42810.0
2017-09-19	AOM	ETF	37.97	38.0075	37.92	37.98	56692.0
2017-09-19	AOR	ETF	44.8	44.8	44.735	44.8	57090.0
2017-09-19	ARCM	ETF	100.0	100.0	100.0	100.0	60000.0
2017-09-19	ARGT	ETF	31.47	31.55	30.91	31.54	32900.0
2017-09-19	ARKG	ETF	25.71	25.71	25.29	25.41	30800.0
2017-09-19	ARKK	ETF	34.48	34.48	34.07	34.21	113500.0
2017-09-19	ARKQ	ETF	31.8	31.8	31.51	31.65	26600.0
2017-09-19	ARKW	ETF	41.3	41.41	40.95	41.06	35900.0
2017-09-19	ASEA	ETF	15.78	15.8	15.68	15.8	1300.0
2017-09-19	ASET	ETF	28.35	28.38	28.32	28.38	1389.0
2017-09-19	ASHR	ETF	29.47	29.55	29.45	29.47	694900.0
2017-09-19	ASHS	ETF	36.81	36.89	36.81	36.86	10000.0
2017-09-19	ASHX	ETF	21.77	21.77	21.737	21.7392	385.0
2017-09-19	ATMP	ETF	21.45	21.56	21.41	21.45	190800.0
2017-09-19	BAB	ETF	30.49	30.5192	30.43	30.47	54212.0
2017-09-19	BAL	ETF	45.68	46.03	45.47	46.03	5821.0
2017-09-19	BAR	ETF	13.266	13.266	13.061	13.061	8610.0

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

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