PREVIEW / etf_daily / 2017-12-27

all etf daily files

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

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-27	SPY	ETF	267.38	267.73	267.01	267.32	57751000.0
2017-12-27	QQQ	ETF	156.52	156.96	156.39	156.54	22388186.0
2017-12-27	IWM	ETF	153.21	153.95	152.81	153.13	15949900.0
2017-12-27	DIA	ETF	247.15	247.69	247.1	247.48	2930300.0
2017-12-27	GLD	ETF	122.0	122.34	121.88	122.23	6232700.0
2017-12-27	TLT	ETF	125.71	126.98	125.7	126.77	9059700.0
2017-12-27	AADR	ETF	58.85	59.25	58.68	58.83	18200.0
2017-12-27	AAXJ	ETF	75.39	75.52	75.23	75.37	519700.0
2017-12-27	ACSI	ETF	31.35	31.3698	31.295	31.295	1896.0
2017-12-27	ACTX	ETF	114.461	129.8012	106.201	112.455	3364.0
2017-12-27	ACWF	ETF	30.59	30.63	30.4886	30.59	2862.0
2017-12-27	ACWI	ETF	72.04	72.1	71.92	72.0	3342100.0
2017-12-27	ACWV	ETF	83.99	84.21	83.99	84.15	106900.0
2017-12-27	ACWX	ETF	49.78	49.84	49.7	49.77	429113.0
2017-12-27	ADRE	ETF	42.91	42.9468	42.7101	42.7101	6022.0
2017-12-27	AFK	ETF	24.1	24.4305	24.1	24.4	8654.0
2017-12-27	AFTY	ETF	17.4	17.4	17.251	17.32	5600.0
2017-12-27	AGG	ETF	109.02	109.33	109.02	109.3	2046900.0
2017-12-27	AGGY	ETF	50.51	50.69	50.51	50.69	51200.0
2017-12-27	AGNG	ETF	19.595	19.69	19.595	19.656	11000.0
2017-12-27	AGQ	ETF	32.76	33.03	32.57	32.86	125600.0
2017-12-27	AGZ	ETF	112.93	113.05	112.912	113.0298	16999.0
2017-12-27	AGZD	ETF	24.195	24.195	24.07	24.11	12600.0
2017-12-27	AIA	ETF	65.27	65.29	65.0198	65.21	28019.0
2017-12-27	AIEQ	ETF	26.12	26.12	26.0	26.04	62800.0
2017-12-27	AIRR	ETF	27.57	27.7	27.474	27.61	12300.0
2017-12-27	AIVI	ETF	43.23	43.36	43.22	43.27	86800.0
2017-12-27	ALTY	ETF	15.296	15.34	15.296	15.34	2100.0
2017-12-27	AMJ	ETF	27.45	27.54	27.34	27.39	3608512.0
2017-12-27	AMLP	ETF	54.3	54.35	53.9	53.95	4104880.0
2017-12-27	AMUB	ETF	17.3	17.3	17.3	17.3	4421.0
2017-12-27	AMZA	ETF	86.3	87.5	85.6	86.3	155870.0
2017-12-27	ANGL	ETF	29.87	29.94	29.79	29.84	574800.0
2017-12-27	AOA	ETF	55.79	55.9	55.77	55.81	44100.0
2017-12-27	AOK	ETF	34.62	34.6322	34.5401	34.62	90108.0
2017-12-27	AOM	ETF	38.73	38.77	38.68	38.68	187948.0
2017-12-27	AOR	ETF	46.2	46.2412	46.15	46.24	115857.0
2017-12-27	ARGT	ETF	35.69	35.7	35.44	35.63	28600.0
2017-12-27	ARKG	ETF	24.75	24.879	24.58	24.73	25200.0
2017-12-27	ARKK	ETF	37.94	37.97	37.26	37.55	222500.0
2017-12-27	ARKQ	ETF	33.45	33.51	33.13	33.18	30600.0
2017-12-27	ARKW	ETF	46.96	46.98	46.34	46.43	121800.0
2017-12-27	ASEA	ETF	17.16	17.16	17.05	17.05	1100.0
2017-12-27	ASET	ETF	28.58	28.63	28.58	28.599	1273.0
2017-12-27	ASHR	ETF	30.47	30.51	30.4	30.48	1329700.0
2017-12-27	ASHS	ETF	34.02	34.22	34.02	34.18	4000.0
2017-12-27	ASHX	ETF	21.841	21.841	21.841	21.841	158.0
2017-12-27	ATMP	ETF	20.78	20.78	20.63	20.64	714100.0
2017-12-27	BAB	ETF	30.5	30.66	30.44	30.66	115334.0
2017-12-27	BAL	ETF	52.37	52.53	52.15	52.49	2081.0

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

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