PREVIEW / etf_daily / 2017-10-19

all etf daily files

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

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-19	SPY	ETF	254.83	255.83	254.35	255.79	61903800.0
2017-10-19	QQQ	ETF	148.02	148.33	147.27	148.31	27680285.0
2017-10-19	IWM	ETF	148.77	149.33	148.17	149.29	17164900.0
2017-10-19	DIA	ETF	230.84	231.66	230.52	231.65	2305400.0
2017-10-19	GLD	ETF	122.2	122.55	122.11	122.39	5567300.0
2017-10-19	TLT	ETF	125.74	126.01	125.27	125.31	8966500.0
2017-10-19	AADR	ETF	56.67	56.93	56.18	56.91	23300.0
2017-10-19	AAXJ	ETF	74.47	74.52	74.16	74.5	1219000.0
2017-10-19	ACSI	ETF	29.4099	29.485	29.4	29.485	38424.0
2017-10-19	ACTX	ETF	54.2805	54.2805	50.1505	50.1505	397.0
2017-10-19	ACWF	ETF	29.48	29.66	29.48	29.6515	8354.0
2017-10-19	ACWI	ETF	69.82	70.05	69.69	70.05	1260300.0
2017-10-19	ACWV	ETF	82.46	82.77	82.4	82.73	58500.0
2017-10-19	ACWX	ETF	49.06	49.19	49.02	49.18	1184690.0
2017-10-19	ADRE	ETF	43.14	43.18	42.937	43.1453	14765.0
2017-10-19	AFK	ETF	23.6	23.64	23.5508	23.64	12007.0
2017-10-19	AFTY	ETF	17.56	17.56	17.45	17.48	5500.0
2017-10-19	AGG	ETF	109.71	109.75	109.54	109.62	1877000.0
2017-10-19	AGGY	ETF	50.81	50.9	50.78	50.808	13400.0
2017-10-19	AGNG	ETF	19.72	19.819	19.715	19.819	4300.0
2017-10-19	AGQ	ETF	34.42	35.53	34.42	35.42	99100.0
2017-10-19	AGZ	ETF	113.55	113.67	113.54	113.5664	8607.0
2017-10-19	AGZD	ETF	24.05	24.05	24.05	24.05	4000.0
2017-10-19	AIA	ETF	63.43	63.57	63.2064	63.57	29767.0
2017-10-19	AIEQ	ETF	25.5	25.5	25.01	25.285	198400.0
2017-10-19	AIRR	ETF	25.99	26.01	25.84	25.99	84800.0
2017-10-19	AIVI	ETF	42.84	42.99	42.84	42.93	6700.0
2017-10-19	ALTY	ETF	15.7	15.72	15.7	15.707	2000.0
2017-10-19	AMJ	ETF	27.28	27.49	27.19	27.47	2010880.0
2017-10-19	AMLP	ETF	54.0	54.65	53.85	54.6	4185440.0
2017-10-19	AMZA	ETF	84.8	85.6	84.5	85.6	121520.0
2017-10-19	ANGL	ETF	30.35	30.39	30.3	30.39	183800.0
2017-10-19	AOA	ETF	54.05	54.16	54.0	54.13	47500.0
2017-10-19	AOK	ETF	34.61	34.66	34.6	34.62	50163.0
2017-10-19	AOM	ETF	38.04	38.135	38.01	38.08	65203.0
2017-10-19	AOR	ETF	45.12	45.178	45.047	45.178	136797.0
2017-10-19	ARGT	ETF	31.41	31.47	31.18	31.47	87600.0
2017-10-19	ARKG	ETF	26.26	26.345	26.0	26.3	45800.0
2017-10-19	ARKK	ETF	34.54	34.54	34.131	34.36	95400.0
2017-10-19	ARKQ	ETF	32.8	32.8	32.16	32.34	45400.0
2017-10-19	ARKW	ETF	41.34	41.4	41.04	41.39	52000.0
2017-10-19	ASEA	ETF	15.79	15.79	15.73	15.77	1400.0
2017-10-19	ASET	ETF	28.33	28.42	28.33	28.42	3328.0
2017-10-19	ASHR	ETF	30.0	30.03	29.92	29.97	1622200.0
2017-10-19	ASHS	ETF	35.72	35.79	35.72	35.76	8000.0
2017-10-19	ASHX	ETF	22.1599	22.1599	22.1458	22.1458	1000.0
2017-10-19	ATMP	ETF	20.58	20.84	20.58	20.82	131200.0
2017-10-19	BAB	ETF	30.58	30.61	30.53	30.53	69184.0
2017-10-19	BAL	ETF	44.58	44.59	44.3301	44.3301	21894.0
2017-10-19	BAR	ETF	12.864	12.864	12.864	12.864	16100.0

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

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