PREVIEW / etf_daily / 2018-05-15

all etf daily files

  file:    by_date/etf_daily/2018/2018-05-15.parquet
  size:    60 KB
  rows:    1,565

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
2018-05-15	SPY	ETF	271.59	271.61	270.03	271.1	87036100.0
2018-05-15	QQQ	ETF	168.4	168.5	166.98	167.87	49361638.0
2018-05-15	IWM	ETF	158.71	159.59	158.17	159.26	17544900.0
2018-05-15	DIA	ETF	248.07	248.18	246.49	247.31	4755900.0
2018-05-15	GLD	ETF	122.82	122.82	122.13	122.48	10911900.0
2018-05-15	TLT	ETF	117.56	117.58	116.7	117.25	12901000.0
2018-05-15	AADR	ETF	58.11	59.18	58.02	59.08	10900.0
2018-05-15	AAXJ	ETF	76.62	76.62	75.99	76.25	872700.0
2018-05-15	ACSI	ETF	31.161	31.23	31.16	31.23	1801.0
2018-05-15	ACTX	ETF	59.5905	61.0655	56.0505	60.1805	653.0
2018-05-15	ACWF	ETF	31.17	31.17	31.035	31.055	3875.0
2018-05-15	ACWI	ETF	73.27	73.31	72.93	73.16	1918900.0
2018-05-15	ACWV	ETF	83.63	83.63	83.24	83.47	119000.0
2018-05-15	ACWX	ETF	50.22	50.38	50.06	50.27	358728.0
2018-05-15	ADRE	ETF	44.4	44.54	44.04	44.4503	8616.0
2018-05-15	AFK	ETF	25.75	25.765	25.2832	25.49	37701.0
2018-05-15	AFTY	ETF	17.42	17.42	17.32	17.34	4100.0
2018-05-15	AGG	ETF	105.49	105.49	105.19	105.29	2166400.0
2018-05-15	AGGY	ETF	48.42	48.42	48.3	48.344	39800.0
2018-05-15	AGNG	ETF	20.02	20.02	19.87	19.87	600.0
2018-05-15	AGQ	ETF	30.56	30.66	30.27	30.56	208400.0
2018-05-15	AGZ	ETF	110.59	110.6724	110.565	110.565	11093.0
2018-05-15	AGZD	ETF	24.035	24.035	24.035	24.035	1000.0
2018-05-15	AIA	ETF	66.84	66.85	66.46	66.68	281892.0
2018-05-15	AIEQ	ETF	27.47	27.48	27.32	27.449	31400.0
2018-05-15	AIRR	ETF	26.02	26.13	25.94	26.04	16100.0
2018-05-15	AIVI	ETF	44.38	44.52	44.36	44.36	1900.0
2018-05-15	ALTY	ETF	14.74	14.76	14.74	14.76	8000.0
2018-05-15	AMJ	ETF	26.91	26.995	26.75	26.85	899818.0
2018-05-15	AMLP	ETF	51.3	51.5	51.0	51.05	3513120.0
2018-05-15	AMZA	ETF	75.8	76.4	75.5	75.6	78570.0
2018-05-15	ANGL	ETF	29.17	29.17	29.03	29.1	241400.0
2018-05-15	AOA	ETF	54.09	54.11	53.87	54.04	36800.0
2018-05-15	AOK	ETF	34.11	34.11	33.9301	33.95	43851.0
2018-05-15	AOM	ETF	37.62	37.63	37.5	37.58	69472.0
2018-05-15	AOR	ETF	44.74	44.74	44.6	44.7	65863.0
2018-05-15	ARCM	ETF	100.23	100.23	100.23	100.23	700.0
2018-05-15	ARGT	ETF	30.6	31.33	30.41	30.95	308100.0
2018-05-15	ARKG	ETF	28.23	28.23	27.751	28.07	91700.0
2018-05-15	ARKK	ETF	42.65	42.81	42.32	42.73	264800.0
2018-05-15	ARKQ	ETF	34.16	34.22	33.88	34.17	17400.0
2018-05-15	ARKW	ETF	52.74	52.74	52.24	52.64	211400.0
2018-05-15	ASEA	ETF	17.08	17.18	17.08	17.12	2900.0
2018-05-15	ASET	ETF	27.93	27.9382	27.93	27.938	984.0
2018-05-15	ASHR	ETF	30.65	30.65	30.44	30.52	1049900.0
2018-05-15	ASHS	ETF	34.28	34.28	34.19	34.2	2900.0
2018-05-15	ASHX	ETF	21.26	21.26	21.26	21.26	210.0
2018-05-15	ATMP	ETF	20.31	20.47	20.31	20.37	63800.0
2018-05-15	BAB	ETF	29.5	29.5	29.38	29.42	71924.0
2018-05-15	BAR	ETF	12.94	12.94	12.889	12.889	90660.0

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

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