PREVIEW / etf_daily / 2017-12-08

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-08.parquet
  size:    59 KB
  rows:    1,520

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-12-08	SPY	ETF	265.16	265.52	264.03	265.51	76563900.0
2017-12-08	QQQ	ETF	155.1	155.53	154.46	154.7	28081666.0
2017-12-08	IWM	ETF	152.15	152.28	151.28	151.41	20832400.0
2017-12-08	DIA	ETF	243.19	243.63	242.58	243.62	2704300.0
2017-12-08	GLD	ETF	118.49	118.92	118.33	118.48	5231300.0
2017-12-08	TLT	ETF	126.59	126.74	126.24	126.69	4786100.0
2017-12-08	AADR	ETF	57.24	57.24	56.61	56.81	27100.0
2017-12-08	AAXJ	ETF	75.29	75.38	75.03	75.32	1132500.0
2017-12-08	ACSI	ETF	30.96	31.045	30.96	31.045	1342.0
2017-12-08	ACTX	ETF	62.5406	69.6206	62.5406	67.8506	208.0
2017-12-08	ACWF	ETF	30.49	30.53	30.489	30.49	4479.0
2017-12-08	ACWI	ETF	71.58	71.62	71.41	71.61	1167700.0
2017-12-08	ACWV	ETF	84.32	84.49	84.15	84.49	92800.0
2017-12-08	ACWX	ETF	49.31	49.35	49.1914	49.32	506304.0
2017-12-08	ADRE	ETF	42.03	42.12	41.9512	42.04	9640.0
2017-12-08	AFK	ETF	24.0	24.28	23.98	24.1	6382.0
2017-12-08	AFTY	ETF	18.36	18.37	18.33	18.366	4000.0
2017-12-08	AGG	ETF	109.21	109.29	109.15	109.19	1685000.0
2017-12-08	AGGY	ETF	50.73	50.74	50.67	50.71	54000.0
2017-12-08	AGNG	ETF	19.56	19.66	19.56	19.66	1800.0
2017-12-08	AGQ	ETF	29.57	29.9	29.45	29.76	122700.0
2017-12-08	AGZ	ETF	113.29	113.36	113.2445	113.2801	8777.0
2017-12-08	AGZD	ETF	24.14	24.15	24.105	24.125	2800.0
2017-12-08	AIA	ETF	64.66	64.89	64.6447	64.84	60156.0
2017-12-08	AIEQ	ETF	25.5	25.58	25.44	25.54	99900.0
2017-12-08	AIRR	ETF	27.06	27.06	26.89	26.89	22000.0
2017-12-08	AIVI	ETF	42.96	43.11	42.96	43.06	5500.0
2017-12-08	ALTY	ETF	15.379	15.379	15.3	15.35	7500.0
2017-12-08	AMJ	ETF	26.54	26.66	26.37	26.42	5294996.0
2017-12-08	AMLP	ETF	52.2	52.55	51.95	52.0	2913400.0
2017-12-08	AMZA	ETF	82.2	82.95	81.9	82.3	121750.0
2017-12-08	ANGL	ETF	30.0	30.02	29.95	29.96	254300.0
2017-12-08	AOA	ETF	55.15	55.2	55.05	55.17	86800.0
2017-12-08	AOK	ETF	34.49	34.56	34.43	34.53	79555.0
2017-12-08	AOM	ETF	38.54	38.54	38.4321	38.45	435280.0
2017-12-08	AOR	ETF	45.74	45.89	45.68	45.89	154815.0
2017-12-08	ARGT	ETF	32.93	33.34	32.86	33.3	56500.0
2017-12-08	ARKG	ETF	25.37	25.37	25.0	25.16	49000.0
2017-12-08	ARKK	ETF	37.27	37.35	36.71	36.74	284400.0
2017-12-08	ARKQ	ETF	33.89	33.89	33.39	33.44	55300.0
2017-12-08	ARKW	ETF	45.69	45.859	44.97	45.05	200900.0
2017-12-08	ASEA	ETF	16.61	16.61	16.53	16.6	3500.0
2017-12-08	ASET	ETF	28.62	28.68	28.62	28.67	2951.0
2017-12-08	ASHR	ETF	30.41	30.5	30.39	30.49	2509500.0
2017-12-08	ASHS	ETF	34.07	34.07	34.02	34.05	3200.0
2017-12-08	ASHX	ETF	22.49	22.49	22.49	22.49	201.0
2017-12-08	ATMP	ETF	20.18	20.26	19.89	19.91	243600.0
2017-12-08	BAB	ETF	30.68	30.72	30.56	30.63	87636.0
2017-12-08	BAL	ETF	49.0	49.1458	48.71	48.7744	4155.0
2017-12-08	BAR	ETF	12.475	12.475	12.4703	12.4703	5000.0

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

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