PREVIEW / etf_daily / 2017-03-27

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-27.parquet
  size:    54 KB
  rows:    1,373

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-03-27	SPY	ETF	231.93	233.92	231.61	233.62	87454500.0
2017-03-27	QQQ	ETF	129.73	131.07	129.4	130.84	18472445.0
2017-03-27	IWM	ETF	132.76	135.07	132.4	134.74	35596700.0
2017-03-27	DIA	ETF	204.18	205.51	203.81	205.23	4559600.0
2017-03-27	GLD	ETF	119.93	120.08	119.27	119.53	8519600.0
2017-03-27	TLT	ETF	121.83	121.97	121.19	121.43	6878500.0
2017-03-27	AADR	ETF	45.96	46.32	45.74	46.32	5800.0
2017-03-27	AAXJ	ETF	63.1	63.36	62.9	63.33	948700.0
2017-03-27	ACSI	ETF	27.49	27.59	27.462	27.57	3039.0
2017-03-27	ACTX	ETF	100.5959	103.2509	98.1769	99.7109	1377.0
2017-03-27	ACWF	ETF	25.68	25.68	25.68	25.68	588.0
2017-03-27	ACWI	ETF	62.69	63.17	62.65	63.13	1775400.0
2017-03-27	ACWV	ETF	77.15	77.48	77.12	77.44	129800.0
2017-03-27	ACWX	ETF	43.42	43.73	43.42	43.71	373799.0
2017-03-27	ADRE	ETF	36.27	36.743	36.27	36.743	5722.0
2017-03-27	AFK	ETF	21.37	21.37	20.91	20.91	17541.0
2017-03-27	AFTY	ETF	13.88	13.93	13.88	13.9	4800.0
2017-03-27	AGG	ETF	108.65	108.71	108.53	108.62	1977300.0
2017-03-27	AGGY	ETF	49.82	49.869	49.776	49.776	7400.0
2017-03-27	AGNG	ETF	16.9	16.9	16.9	16.9	27400.0
2017-03-27	AGQ	ETF	40.65	40.9	40.37	40.81	194900.0
2017-03-27	AGZ	ETF	113.22	113.36	112.8201	112.97	47628.0
2017-03-27	AGZD	ETF	24.05	24.055	24.03	24.03	3600.0
2017-03-27	AIA	ETF	52.97	53.1099	52.87	53.1	10355.0
2017-03-27	AIRR	ETF	22.64	23.153	22.574	23.13	183000.0
2017-03-27	AIVI	ETF	39.51	39.64	39.44	39.64	17600.0
2017-03-27	ALTY	ETF	15.292	15.391	15.292	15.391	700.0
2017-03-27	AMJ	ETF	31.3	31.4871	31.235	31.43	1501139.0
2017-03-27	AMLP	ETF	62.5	62.6	62.25	62.45	1885620.0
2017-03-27	AMZA	ETF	109.3	109.3	108.3	108.9	70340.0
2017-03-27	ANGL	ETF	29.05	29.11	29.04	29.08	123000.0
2017-03-27	AOA	ETF	49.57	49.79	49.5	49.73	47800.0
2017-03-27	AOK	ETF	33.25	33.28	33.16	33.2552	72766.0
2017-03-27	AOM	ETF	36.29	36.35	36.18	36.3	154165.0
2017-03-27	AOR	ETF	42.18	42.3	42.0301	42.23	97249.0
2017-03-27	ARGT	ETF	27.27	27.61	27.27	27.6	23500.0
2017-03-27	ARKG	ETF	20.1	20.497	19.9	20.497	2000.0
2017-03-27	ARKK	ETF	23.11	23.43	23.11	23.43	5400.0
2017-03-27	ARKQ	ETF	24.0	24.14	23.7	24.13	9000.0
2017-03-27	ARKW	ETF	27.86	28.45	27.84	28.394	13700.0
2017-03-27	ASEA	ETF	14.1	14.1	14.04	14.07	5500.0
2017-03-27	ASET	ETF	26.3283	26.3752	26.3283	26.3752	512.0
2017-03-27	ASHR	ETF	25.38	25.43	25.29	25.39	268900.0
2017-03-27	ASHS	ETF	34.15	34.5	34.15	34.49	4100.0
2017-03-27	ATMP	ETF	23.31	23.31	23.09	23.22	30900.0
2017-03-27	BAB	ETF	29.49	29.5	29.45	29.45	225061.0
2017-03-27	BAL	ETF	50.45	50.45	50.02	50.02	2301.0
2017-03-27	BBC	ETF	22.8	23.5	22.0551	23.5	30086.0
2017-03-27	BBH	ETF	116.82	118.54	116.61	118.15	191500.0
2017-03-27	BBP	ETF	36.66	38.291	36.66	38.291	21200.0

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

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