PREVIEW / etf_daily / 2017-08-18

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-18.parquet
  size:    56 KB
  rows:    1,433

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-08-18	SPY	ETF	242.9	244.19	242.2	242.71	136748000.0
2017-08-18	QQQ	ETF	141.43	142.2	140.65	141.23	60751940.0
2017-08-18	IWM	ETF	134.47	135.46	134.12	134.92	42401900.0
2017-08-18	DIA	ETF	216.99	217.66	216.15	216.53	4468500.0
2017-08-18	GLD	ETF	123.37	123.54	122.0	122.3	13654200.0
2017-08-18	TLT	ETF	126.98	127.15	126.26	126.62	8382500.0
2017-08-18	AADR	ETF	50.71	51.28	50.68	51.1	6700.0
2017-08-18	AAXJ	ETF	70.15	70.5	69.84	70.16	777100.0
2017-08-18	ACSI	ETF	28.6	28.6491	28.57	28.57	6411.0
2017-08-18	ACTX	ETF	82.6007	83.1908	74.3407	82.6007	236.0
2017-08-18	ACWF	ETF	27.6	27.729	27.6	27.71	507.0
2017-08-18	ACWI	ETF	66.27	66.62	66.15	66.34	1434600.0
2017-08-18	ACWV	ETF	80.42	80.61	80.28	80.37	119300.0
2017-08-18	ACWX	ETF	46.67	46.81	46.529	46.67	753449.0
2017-08-18	ADRE	ETF	41.27	41.57	41.07	41.53	5400.0
2017-08-18	AFK	ETF	23.0	23.0	22.53	23.0	4568.0
2017-08-18	AFTY	ETF	16.16	16.2	16.16	16.2	1000.0
2017-08-18	AGG	ETF	110.05	110.14	109.89	109.95	1564800.0
2017-08-18	AGGY	ETF	50.88	50.88	50.789	50.815	11800.0
2017-08-18	AGNG	ETF	18.39	18.521	18.39	18.521	1600.0
2017-08-18	AGQ	ETF	35.41	35.6	34.79	34.92	179900.0
2017-08-18	AGZ	ETF	114.152	114.21	114.0801	114.15	9553.0
2017-08-18	AGZD	ETF	23.995	24.0	23.95	24.0	1400.0
2017-08-18	AIA	ETF	59.43	59.8662	59.3488	59.49	32321.0
2017-08-18	AIQ	ETF	13.15	13.15	12.9	13.0	35627.0
2017-08-18	AIRR	ETF	22.48	22.72	22.475	22.62	72000.0
2017-08-18	AIVI	ETF	41.4	41.6	41.38	41.52	4000.0
2017-08-18	ALTY	ETF	15.5	15.51	15.46	15.46	1300.0
2017-08-18	AMJ	ETF	27.48	27.55	27.23	27.43	1773416.0
2017-08-18	AMLP	ETF	53.6	53.75	53.1	53.5	2373020.0
2017-08-18	AMZA	ETF	87.6	87.8	86.7	87.4	122690.0
2017-08-18	ANGL	ETF	29.71	29.71	29.58	29.68	359700.0
2017-08-18	AOA	ETF	51.92	52.08	51.82	51.95	71200.0
2017-08-18	AOK	ETF	34.15	34.15	34.0501	34.1	75496.0
2017-08-18	AOM	ETF	37.36	37.4094	37.32	37.36	136412.0
2017-08-18	AOR	ETF	43.78	43.845	43.69	43.77	67011.0
2017-08-18	ARCM	ETF	100.0	100.0	100.0	100.0	20.0
2017-08-18	ARGT	ETF	28.88	29.16	28.84	29.01	39700.0
2017-08-18	ARKG	ETF	22.0	22.03	21.76	21.86	6800.0
2017-08-18	ARKK	ETF	31.07	31.07	30.691	30.75	34600.0
2017-08-18	ARKQ	ETF	28.94	28.94	28.53	28.67	41400.0
2017-08-18	ARKW	ETF	38.33	38.65	38.16	38.34	83700.0
2017-08-18	ASEA	ETF	15.23	15.28	15.21	15.22	1800.0
2017-08-18	ASET	ETF	27.7404	27.7798	27.7404	27.7798	2025.0
2017-08-18	ASHR	ETF	28.08	28.2	28.06	28.15	558500.0
2017-08-18	ASHS	ETF	34.48	34.59	34.48	34.59	7600.0
2017-08-18	ASHX	ETF	21.08	21.08	21.08	21.08	400.0
2017-08-18	ATMP	ETF	20.59	20.78	20.55	20.71	50900.0
2017-08-18	BAB	ETF	30.42	30.49	30.3201	30.36	112997.0
2017-08-18	BAL	ETF	43.86	44.37	43.86	44.2222	634.0

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

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