PREVIEW / etf_daily / 2017-03-13

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-13.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-13	SPY	ETF	237.62	237.86	237.24	237.81	57256800.0
2017-03-13	QQQ	ETF	131.34	131.64	131.27	131.61	10731575.0
2017-03-13	IWM	ETF	135.65	136.79	135.65	136.28	21295000.0
2017-03-13	DIA	ETF	209.13	209.34	208.59	208.94	2261800.0
2017-03-13	GLD	ETF	114.63	114.91	114.51	114.74	5807400.0
2017-03-13	TLT	ETF	116.83	117.09	116.49	116.51	6993100.0
2017-03-13	AADR	ETF	45.0	45.35	44.95	45.31	9100.0
2017-03-13	AAXJ	ETF	61.2	61.39	61.19	61.31	636400.0
2017-03-13	ACSI	ETF	27.9399	27.9399	27.87	27.91	4168.0
2017-03-13	ACTX	ETF	97.9409	118.2961	97.3509	110.331	5384.0
2017-03-13	ACWI	ETF	62.93	63.04	62.89	63.02	1273700.0
2017-03-13	ACWV	ETF	76.46	76.64	76.44	76.64	159200.0
2017-03-13	ACWX	ETF	42.81	42.91	42.81	42.91	296363.0
2017-03-13	ADRE	ETF	35.75	36.04	35.75	36.0	11577.0
2017-03-13	AFK	ETF	20.4	20.66	20.3611	20.5509	6421.0
2017-03-13	AFTY	ETF	13.93	13.93	13.93	13.93	200.0
2017-03-13	AGG	ETF	107.21	107.28	107.1	107.12	1658500.0
2017-03-13	AGGY	ETF	49.155	49.21	49.08	49.08	16900.0
2017-03-13	AGNG	ETF	16.94	16.95	16.94	16.94	2600.0
2017-03-13	AGQ	ETF	36.01	36.16	35.84	35.95	105500.0
2017-03-13	AGZ	ETF	112.01	112.392	111.9	112.24	30282.0
2017-03-13	AGZD	ETF	24.08	24.135	24.055	24.12	3600.0
2017-03-13	AIA	ETF	51.2	51.279	51.12	51.26	97281.0
2017-03-13	AIQ	ETF	10.1	10.2	9.7773	10.15	10943.0
2017-03-13	AIRR	ETF	23.79	23.92	23.66	23.69	30500.0
2017-03-13	AIVI	ETF	38.88	38.98	38.88	38.97	9500.0
2017-03-13	ALTY	ETF	15.34	15.34	15.13	15.14	5000.0
2017-03-13	AMJ	ETF	31.85	32.2	31.85	32.04	2663839.0
2017-03-13	AMLP	ETF	63.4	63.65	63.35	63.6	1439240.0
2017-03-13	AMZA	ETF	110.5	110.9	110.1	110.5	58390.0
2017-03-13	ANGL	ETF	28.92	28.97	28.82	28.92	231200.0
2017-03-13	AOA	ETF	49.49	49.59	49.49	49.56	64900.0
2017-03-13	AOK	ETF	32.98	32.98	32.8901	32.92	64691.0
2017-03-13	AOM	ETF	35.99	36.05	35.97	36.05	62527.0
2017-03-13	AOR	ETF	42.05	42.05	41.93	41.93	113525.0
2017-03-13	ARGT	ETF	26.54	26.81	26.53	26.8	37300.0
2017-03-13	ARKG	ETF	20.46	20.586	20.38	20.543	5200.0
2017-03-13	ARKK	ETF	23.32	23.43	23.318	23.43	3500.0
2017-03-13	ARKQ	ETF	23.686	23.799	23.686	23.759	5200.0
2017-03-13	ARKW	ETF	28.42	28.623	28.42	28.59	2500.0
2017-03-13	ASEA	ETF	13.64	13.68	13.64	13.68	400.0
2017-03-13	ASET	ETF	25.9059	25.93	25.87	25.919	4036.0
2017-03-13	ASHR	ETF	24.95	25.01	24.85	24.89	485000.0
2017-03-13	ASHS	ETF	34.36	34.36	34.15	34.2	30900.0
2017-03-13	ATMP	ETF	23.68	23.68	23.51	23.66	190400.0
2017-03-13	BAB	ETF	29.05	29.14	29.01	29.01	77354.0
2017-03-13	BAL	ETF	50.35	50.35	49.855	49.99	6072.0
2017-03-13	BBC	ETF	23.53	23.7	23.4692	23.65	27024.0
2017-03-13	BBH	ETF	122.76	122.76	121.48	122.22	34800.0
2017-03-13	BBP	ETF	37.96	38.34	37.933	38.27	4700.0

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

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