PREVIEW / etf_daily / 2018-04-23

all etf daily files

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

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-23	SPY	ETF	267.26	267.89	265.35	266.57	65558000.0
2018-04-23	QQQ	ETF	163.08	163.73	161.02	161.89	33040646.0
2018-04-23	IWM	ETF	155.78	156.29	154.57	155.32	13268200.0
2018-04-23	DIA	ETF	245.06	245.18	243.14	244.35	2491000.0
2018-04-23	GLD	ETF	125.62	125.76	125.34	125.62	6921500.0
2018-04-23	TLT	ETF	118.33	118.62	118.08	118.49	7073200.0
2018-04-23	AADR	ETF	59.48	59.48	58.82	58.86	19800.0
2018-04-23	AAXJ	ETF	76.19	76.38	75.69	75.89	446800.0
2018-04-23	ACSI	ETF	30.911	30.911	30.911	30.911	897.0
2018-04-23	ACTX	ETF	64.3106	64.3106	59.0005	62.5406	904.0
2018-04-23	ACWF	ETF	31.06	31.06	30.83	30.83	49347.0
2018-04-23	ACWI	ETF	72.47	72.62	72.1	72.36	1485700.0
2018-04-23	ACWV	ETF	83.79	83.84	83.43	83.7	70800.0
2018-04-23	ACWX	ETF	50.17	50.238	49.99	50.11	956927.0
2018-04-23	ADRE	ETF	43.84	43.84	43.44	43.57	3358.0
2018-04-23	AFK	ETF	25.45	25.65	25.4	25.4008	5340.0
2018-04-23	AFTY	ETF	17.005	17.04	16.98	17.0	13300.0
2018-04-23	AGG	ETF	105.98	106.01	105.9	105.95	2620800.0
2018-04-23	AGGY	ETF	48.79	48.79	48.72	48.76	57400.0
2018-04-23	AGNG	ETF	19.4	19.46	19.28	19.411	6200.0
2018-04-23	AGQ	ETF	32.54	32.62	31.93	31.97	294300.0
2018-04-23	AGZ	ETF	110.92	111.02	110.9	110.9	22720.0
2018-04-23	AGZD	ETF	24.1	24.1	24.005	24.005	8400.0
2018-04-23	AIA	ETF	66.95	67.17	66.62	66.76	63821.0
2018-04-23	AIEQ	ETF	26.74	26.781	26.521	26.58	33100.0
2018-04-23	AIRR	ETF	25.98	26.191	25.98	26.05	13500.0
2018-04-23	AIVI	ETF	44.31	44.37	44.19	44.19	5600.0
2018-04-23	ALTY	ETF	14.47	14.523	14.47	14.523	800.0
2018-04-23	AMJ	ETF	25.87	26.335	25.76	26.22	2415672.0
2018-04-23	AMLP	ETF	50.15	51.55	50.15	51.25	2925700.0
2018-04-23	AMZA	ETF	72.7	74.8	72.5	74.2	142320.0
2018-04-23	ANGL	ETF	29.3	29.34	29.15	29.18	575700.0
2018-04-23	AOA	ETF	53.8	53.88	53.54	53.74	30800.0
2018-04-23	AOK	ETF	34.11	34.12	33.99	34.02	105662.0
2018-04-23	AOM	ETF	37.61	37.61	37.4599	37.55	71709.0
2018-04-23	AOR	ETF	44.57	44.622	44.4221	44.48	34315.0
2018-04-23	ARCM	ETF	100.27	100.29	100.27	100.29	2000.0
2018-04-23	ARGT	ETF	35.14	35.47	35.14	35.27	52100.0
2018-04-23	ARKG	ETF	26.73	26.73	25.785	26.06	286600.0
2018-04-23	ARKK	ETF	41.1	41.12	39.791	40.2	241400.0
2018-04-23	ARKQ	ETF	33.91	33.91	33.208	33.33	12000.0
2018-04-23	ARKW	ETF	51.29	51.29	50.261	50.47	96200.0
2018-04-23	ASEA	ETF	18.1	18.1	17.83	18.0	2100.0
2018-04-23	ASET	ETF	27.7852	27.7852	27.72	27.7275	1293.0
2018-04-23	ASHR	ETF	29.8	29.82	29.64	29.7	406600.0
2018-04-23	ASHS	ETF	33.61	33.61	33.35	33.37	3200.0
2018-04-23	ASHX	ETF	20.56	20.56	20.56	20.56	5001.0
2018-04-23	ATMP	ETF	19.94	19.94	19.75	19.89	45100.0
2018-04-23	BAB	ETF	29.63	29.638	29.54	29.6	115277.0
2018-04-23	BAL	ETF	51.56	51.56	51.56	51.56	1448.0

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

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