PREVIEW / etf_daily / 2017-10-16

all etf daily files

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

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-16	SPY	ETF	255.21	255.51	254.82	255.29	38221700.0
2017-10-16	QQQ	ETF	148.7	148.89	148.3928	148.85	21809410.0
2017-10-16	IWM	ETF	149.61	150.35	149.03	149.24	20653100.0
2017-10-16	DIA	ETF	229.07	229.53	228.81	229.45	2373400.0
2017-10-16	GLD	ETF	123.82	123.97	122.57	122.97	8202000.0
2017-10-16	TLT	ETF	125.53	125.9	125.38	125.76	5737300.0
2017-10-16	AADR	ETF	57.56	57.79	57.19	57.63	34000.0
2017-10-16	AAXJ	ETF	75.3	75.44	75.27	75.39	824800.0
2017-10-16	ACSI	ETF	29.45	29.45	29.33	29.4	1055.0
2017-10-16	ACTX	ETF	60.1805	60.1805	54.2805	56.0505	121.0
2017-10-16	ACWF	ETF	29.71	29.75	29.69	29.69	1020.0
2017-10-16	ACWI	ETF	70.03	70.12	69.98	70.07	2709700.0
2017-10-16	ACWV	ETF	82.65	82.72	82.51	82.58	93500.0
2017-10-16	ACWX	ETF	49.4	49.42	49.31	49.345	453869.0
2017-10-16	ADRE	ETF	43.78	43.78	43.39	43.6185	10696.0
2017-10-16	AFK	ETF	24.09	24.1	24.02	24.03	5405.0
2017-10-16	AFTY	ETF	17.42	17.45	17.42	17.447	6000.0
2017-10-16	AGG	ETF	109.75	109.81	109.66	109.75	3788100.0
2017-10-16	AGGY	ETF	50.88	50.905	50.828	50.89	19200.0
2017-10-16	AGNG	ETF	19.55	19.82	19.55	19.65	24400.0
2017-10-16	AGQ	ETF	36.37	36.39	34.91	35.4	126000.0
2017-10-16	AGZ	ETF	113.67	113.692	113.57	113.65	9322.0
2017-10-16	AGZD	ETF	24.05	24.075	24.045	24.05	12800.0
2017-10-16	AIA	ETF	64.22	64.299	64.08	64.17	26500.0
2017-10-16	AIRR	ETF	26.19	26.35	26.19	26.25	10800.0
2017-10-16	AIVI	ETF	43.03	43.1	42.99	43.03	49300.0
2017-10-16	ALTY	ETF	15.78	15.8	15.68	15.725	36600.0
2017-10-16	AMJ	ETF	28.32	28.36	27.94	27.99	1140517.0
2017-10-16	AMLP	ETF	56.05	56.2	55.4	55.55	1368920.0
2017-10-16	AMZA	ETF	88.7	89.0	87.1	87.5	182190.0
2017-10-16	ANGL	ETF	30.26	30.27	30.21	30.27	164100.0
2017-10-16	AOA	ETF	54.28	54.31	54.16	54.26	44900.0
2017-10-16	AOK	ETF	34.69	34.72	34.621	34.68	58301.0
2017-10-16	AOM	ETF	38.21	38.22	38.1	38.1	133536.0
2017-10-16	AOR	ETF	45.3	45.3	45.176	45.22	86407.0
2017-10-16	ARCM	ETF	100.15	100.15	100.05	100.05	360.0
2017-10-16	ARGT	ETF	32.1	32.15	31.42	31.55	77600.0
2017-10-16	ARKG	ETF	26.39	26.879	26.25	26.44	27100.0
2017-10-16	ARKK	ETF	34.88	35.0	34.59	34.69	79800.0
2017-10-16	ARKQ	ETF	32.84	32.84	32.67	32.68	24100.0
2017-10-16	ARKW	ETF	41.93	41.93	41.476	41.64	76700.0
2017-10-16	ASEA	ETF	16.01	16.01	15.89	15.89	3300.0
2017-10-16	ASET	ETF	28.43	28.43	28.395	28.395	887.0
2017-10-16	ASHR	ETF	30.25	30.26	30.17	30.19	495000.0
2017-10-16	ASHS	ETF	36.9	36.9	36.63	36.66	17500.0
2017-10-16	ATMP	ETF	21.34	21.36	21.23	21.24	21100.0
2017-10-16	BAB	ETF	30.6	30.62	30.561	30.61	50259.0
2017-10-16	BAL	ETF	44.807	44.81	44.58	44.58	1423.0
2017-10-16	BAR	ETF	12.973	12.973	12.923	12.923	29110.0
2017-10-16	BBC	ETF	28.69	29.389	28.561	28.78	36414.0

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

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