PREVIEW / etf_daily / 2017-12-28

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-28.parquet
  size:    60 KB
  rows:    1,530

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-28	SPY	ETF	267.89	267.92	267.45	267.87	45116100.0
2017-12-28	QQQ	ETF	157.05	157.0653	156.54	156.73	25393825.0
2017-12-28	IWM	ETF	153.24	153.75	153.01	153.73	10167300.0
2017-12-28	DIA	ETF	247.94	248.19	247.77	248.13	2743300.0
2017-12-28	GLD	ETF	122.82	122.92	122.56	122.85	5732700.0
2017-12-28	TLT	ETF	126.53	126.83	126.37	126.66	5297100.0
2017-12-28	AADR	ETF	59.07	59.07	58.63	58.75	24200.0
2017-12-28	AAXJ	ETF	76.15	76.22	75.85	76.0	569500.0
2017-12-28	ACSI	ETF	31.13	31.13	30.9	31.01	5857.0
2017-12-28	ACTX	ETF	112.101	122.1311	106.201	115.051	2510.0
2017-12-28	ACWF	ETF	30.75	30.75	30.66	30.7134	81522.0
2017-12-28	ACWI	ETF	72.3	72.3	72.1	72.16	1402700.0
2017-12-28	ACWV	ETF	84.3	84.35	84.19	84.29	87800.0
2017-12-28	ACWX	ETF	50.02	50.03	49.8732	49.89	584821.0
2017-12-28	ADRE	ETF	43.08	43.08	42.77	42.898	12989.0
2017-12-28	AFK	ETF	24.44	24.7	24.44	24.6	11969.0
2017-12-28	AFTY	ETF	17.565	17.565	17.55	17.55	2400.0
2017-12-28	AGG	ETF	109.22	109.26	109.14	109.22	2895400.0
2017-12-28	AGGY	ETF	50.68	50.68	50.59	50.63	55100.0
2017-12-28	AGNG	ETF	19.68	19.68	19.44	19.44	3900.0
2017-12-28	AGQ	ETF	33.3	33.6	33.24	33.46	185400.0
2017-12-28	AGZ	ETF	112.96	113.07	112.94	113.0299	14814.0
2017-12-28	AGZD	ETF	24.115	24.19	24.085	24.15	10800.0
2017-12-28	AIA	ETF	65.98	66.0	65.79	65.85	37915.0
2017-12-28	AIEQ	ETF	26.05	26.11	26.02	26.08	60100.0
2017-12-28	AIRR	ETF	27.59	27.67	27.505	27.65	27900.0
2017-12-28	AIVI	ETF	43.41	43.41	43.25	43.27	12500.0
2017-12-28	ALTY	ETF	15.27	15.318	15.21	15.251	4800.0
2017-12-28	AMJ	ETF	27.38	27.58	27.32	27.51	4917483.0
2017-12-28	AMLP	ETF	53.95	54.35	53.75	54.2	2994100.0
2017-12-28	AMZA	ETF	86.2	86.3	85.6	86.1	122120.0
2017-12-28	ANGL	ETF	29.89	29.92	29.84	29.89	637200.0
2017-12-28	AOA	ETF	53.95	53.98	53.83	53.91	84600.0
2017-12-28	AOK	ETF	34.6	34.631	34.55	34.61	67745.0
2017-12-28	AOM	ETF	38.12	38.12	37.96	38.06	243193.0
2017-12-28	AOR	ETF	44.97	44.97	44.791	44.91	152938.0
2017-12-28	ARCM	ETF	100.1	100.1	100.1	100.1	100000.0
2017-12-28	ARGT	ETF	35.74	35.74	35.31	35.44	71500.0
2017-12-28	ARKG	ETF	24.86	24.86	24.499	24.851	25000.0
2017-12-28	ARKK	ETF	37.37	37.52	37.27	37.44	219400.0
2017-12-28	ARKQ	ETF	33.02	33.233	33.02	33.09	55900.0
2017-12-28	ARKW	ETF	46.37	46.4	46.061	46.16	144100.0
2017-12-28	ASEA	ETF	16.77	16.9	16.77	16.78	1600.0
2017-12-28	ASET	ETF	28.67	28.73	28.67	28.73	2301.0
2017-12-28	ASHR	ETF	30.79	30.9	30.79	30.88	475700.0
2017-12-28	ASHS	ETF	34.45	34.56	34.42	34.56	32800.0
2017-12-28	ASHX	ETF	22.0	22.0	22.0	22.0	152.0
2017-12-28	ATMP	ETF	20.69	20.8	20.67	20.78	82600.0
2017-12-28	BAB	ETF	30.66	30.66	30.57	30.6	38049.0
2017-12-28	BAL	ETF	52.72	52.72	52.5	52.51	2334.0

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

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