PREVIEW / etf_daily / 2018-04-27

all etf daily files

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

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-27	SPY	ETF	267.0	267.34	265.5	266.56	57053600.0
2018-04-27	QQQ	ETF	164.35	164.41	161.17	162.09	51043406.0
2018-04-27	IWM	ETF	154.88	155.37	153.78	154.69	17734300.0
2018-04-27	DIA	ETF	242.97	243.44	241.77	242.95	3209800.0
2018-04-27	GLD	ETF	125.2	125.62	125.17	125.5	5654000.0
2018-04-27	TLT	ETF	118.47	118.95	118.44	118.89	5401800.0
2018-04-27	AADR	ETF	58.07	58.47	58.07	58.45	22800.0
2018-04-27	AAXJ	ETF	76.44	76.56	75.99	76.51	407400.0
2018-04-27	ACSI	ETF	30.88	31.3	30.88	31.3	2655.0
2018-04-27	ACTX	ETF	59.0005	63.7206	59.0005	59.5905	227.0
2018-04-27	ACWF	ETF	30.84	30.93	30.7898	30.8648	3011.0
2018-04-27	ACWI	ETF	72.45	72.51	72.12	72.41	715700.0
2018-04-27	ACWV	ETF	83.69	83.99	83.69	83.86	70400.0
2018-04-27	ACWX	ETF	50.2	50.28	50.02	50.25	691331.0
2018-04-27	ADRE	ETF	43.82	43.82	43.615	43.6891	2640.0
2018-04-27	AFK	ETF	25.45	25.58	25.3002	25.3157	1679.0
2018-04-27	AFTY	ETF	16.78	16.838	16.76	16.838	1200.0
2018-04-27	AGG	ETF	105.96	106.04	105.94	105.98	3806400.0
2018-04-27	AGGY	ETF	48.6	48.64	48.595	48.64	20000.0
2018-04-27	AGNG	ETF	19.69	19.69	19.69	19.69	200.0
2018-04-27	AGQ	ETF	31.6	31.64	31.3	31.61	85000.0
2018-04-27	AGZ	ETF	110.94	111.1288	110.94	111.0	15462.0
2018-04-27	AGZD	ETF	24.045	24.07	24.045	24.055	4000.0
2018-04-27	AIA	ETF	67.37	67.52	67.09	67.44	48552.0
2018-04-27	AIEQ	ETF	26.49	26.64	26.47	26.55	34900.0
2018-04-27	AIRR	ETF	25.67	25.67	25.355	25.398	21900.0
2018-04-27	AIVI	ETF	44.41	44.59	44.31	44.57	5000.0
2018-04-27	ALTY	ETF	14.52	14.53	14.52	14.53	1100.0
2018-04-27	AMJ	ETF	25.68	26.08	25.64	25.92	3745505.0
2018-04-27	AMLP	ETF	50.3	50.7	50.05	50.45	2207740.0
2018-04-27	AMZA	ETF	73.1	73.35	72.5	73.0	44540.0
2018-04-27	ANGL	ETF	29.1	29.14	29.07	29.11	163000.0
2018-04-27	AOA	ETF	53.75	53.76	53.6	53.7	87600.0
2018-04-27	AOK	ETF	34.13	34.13	34.03	34.09	36305.0
2018-04-27	AOM	ETF	37.57	37.705	37.5101	37.54	517276.0
2018-04-27	AOR	ETF	44.52	44.56	44.451	44.53	794571.0
2018-04-27	ARGT	ETF	34.5	34.82	34.23	34.7	56500.0
2018-04-27	ARKG	ETF	26.16	26.16	25.61	25.93	167300.0
2018-04-27	ARKK	ETF	39.89	40.0	38.93	39.38	126100.0
2018-04-27	ARKQ	ETF	33.0	33.0	32.497	32.735	12300.0
2018-04-27	ARKW	ETF	50.3	50.33	49.19	49.74	150400.0
2018-04-27	ASEA	ETF	17.81	17.84	17.76	17.84	2500.0
2018-04-27	ASET	ETF	28.04	28.04	28.04	28.04	1805.0
2018-04-27	ASHR	ETF	29.73	29.77	29.53	29.71	283100.0
2018-04-27	ASHS	ETF	33.55	33.65	33.55	33.65	5300.0
2018-04-27	ASHX	ETF	20.49	20.58	20.49	20.58	300.0
2018-04-27	ATMP	ETF	19.46	19.65	19.42	19.65	38700.0
2018-04-27	BAB	ETF	29.61	29.61	29.5	29.51	136640.0
2018-04-27	BAR	ETF	13.201	13.201	13.201	13.201	1130.0
2018-04-27	BBC	ETF	31.63	31.7	31.34	31.54	9468.0

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

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