PREVIEW / etf_daily / 2018-04-30

all etf daily files

  file:    by_date/etf_daily/2018/2018-04-30.parquet
  size:    60 KB
  rows:    1,552

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-04-30	SPY	ETF	267.26	267.89	264.43	264.51	82182300.0
2018-04-30	QQQ	ETF	162.48	163.48	160.54	160.94	35615273.0
2018-04-30	IWM	ETF	155.02	155.65	153.29	153.32	15624600.0
2018-04-30	DIA	ETF	244.1	244.84	241.51	241.54	3475700.0
2018-04-30	GLD	ETF	124.41	125.2	124.19	124.59	9830600.0
2018-04-30	TLT	ETF	119.08	119.56	118.94	119.1	8321100.0
2018-04-30	AADR	ETF	58.42	58.9	58.36	58.43	12800.0
2018-04-30	AAXJ	ETF	77.04	77.08	76.25	76.25	782700.0
2018-04-30	ACSI	ETF	31.341	31.341	31.06	31.06	1530.0
2018-04-30	ACTX	ETF	61.0655	63.1306	59.0005	59.5905	883.0
2018-04-30	ACWF	ETF	30.9758	30.9758	30.69	30.69	3167.0
2018-04-30	ACWI	ETF	72.52	72.66	71.97	71.99	2476500.0
2018-04-30	ACWV	ETF	84.07	84.22	83.47	83.47	83200.0
2018-04-30	ACWX	ETF	50.2	50.3608	49.9499	49.97	4408663.0
2018-04-30	ADRE	ETF	44.04	44.0892	43.7083	43.8359	2974.0
2018-04-30	AFK	ETF	25.48	25.48	25.19	25.19	3048.0
2018-04-30	AFTY	ETF	16.94	17.07	16.91	16.93	4000.0
2018-04-30	AGG	ETF	106.01	106.12	105.99	106.0	4692600.0
2018-04-30	AGGY	ETF	48.64	48.68	48.62	48.62	41600.0
2018-04-30	AGNG	ETF	19.658	19.658	19.521	19.521	2100.0
2018-04-30	AGQ	ETF	30.56	31.25	30.38	30.87	307700.0
2018-04-30	AGZ	ETF	111.1499	111.18	111.02	111.04	22683.0
2018-04-30	AGZD	ETF	24.005	24.1	23.945	24.025	21600.0
2018-04-30	AIA	ETF	67.92	67.97	67.27	67.27	38747.0
2018-04-30	AIEQ	ETF	26.61	26.725	26.35	26.35	38800.0
2018-04-30	AIRR	ETF	25.45	25.542	25.05	25.05	7700.0
2018-04-30	AIVI	ETF	44.5	44.55	44.37	44.37	7400.0
2018-04-30	ALTY	ETF	14.7	14.7	14.655	14.655	2200.0
2018-04-30	AMJ	ETF	25.88	26.195	25.83	25.96	3142978.0
2018-04-30	AMLP	ETF	50.55	51.1	50.35	50.5	2808980.0
2018-04-30	AMZA	ETF	73.1	74.0	72.81	73.2	139610.0
2018-04-30	ANGL	ETF	29.09	29.18	29.09	29.1	344800.0
2018-04-30	AOA	ETF	53.8	53.86	53.46	53.47	59700.0
2018-04-30	AOK	ETF	34.03	34.14	34.0	34.0	31098.0
2018-04-30	AOM	ETF	37.54	37.6	37.47	37.47	74769.0
2018-04-30	AOR	ETF	44.64	44.64	44.34	44.35	144415.0
2018-04-30	ARGT	ETF	34.91	35.17	34.88	34.97	37700.0
2018-04-30	ARKG	ETF	25.99	26.23	25.38	25.41	39500.0
2018-04-30	ARKK	ETF	39.31	39.88	38.963	39.09	198700.0
2018-04-30	ARKQ	ETF	32.76	32.971	32.53	32.59	22800.0
2018-04-30	ARKW	ETF	49.92	50.2	49.354	49.72	106700.0
2018-04-30	ASHR	ETF	29.96	29.98	29.77	29.8	409200.0
2018-04-30	ASHS	ETF	33.99	34.0	33.87	33.88	7700.0
2018-04-30	ASHX	ETF	20.64	20.64	20.6	20.6	200.0
2018-04-30	ATMP	ETF	19.71	20.16	19.61	20.16	95900.0
2018-04-30	BAB	ETF	29.6	29.66	29.49	29.66	943308.0
2018-04-30	BAL	ETF	50.87	50.87	50.87	50.87	2000.0
2018-04-30	BAR	ETF	13.1165	13.184	13.1165	13.184	16640.0
2018-04-30	BBC	ETF	31.88	31.88	31.02	31.06	6589.0
2018-04-30	BBH	ETF	117.92	117.92	115.53	115.53	13700.0

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

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