PREVIEW / etf_daily / 2018-05-22

all etf daily files

  file:    by_date/etf_daily/2018/2018-05-22.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-22	SPY	ETF	273.96	274.25	272.24	272.61	52966400.0
2018-05-22	QQQ	ETF	169.15	169.45	167.88	168.18	19477721.0
2018-05-22	IWM	ETF	163.26	163.33	161.63	161.76	13212000.0
2018-05-22	DIA	ETF	250.37	250.43	247.92	248.18	2329300.0
2018-05-22	GLD	ETF	122.7	122.74	122.34	122.41	4579600.0
2018-05-22	TLT	ETF	117.29	117.35	116.85	117.09	4700700.0
2018-05-22	AADR	ETF	59.68	59.72	59.29	59.45	14700.0
2018-05-22	AAXJ	ETF	76.82	77.14	76.52	76.63	499700.0
2018-05-22	ACSI	ETF	31.52	31.52	31.4326	31.4326	1107.0
2018-05-22	ACTX	ETF	66.6706	69.0306	60.7705	63.7206	547.0
2018-05-22	ACWF	ETF	31.4961	31.56	31.38	31.42	7556.0
2018-05-22	ACWI	ETF	73.77	73.91	73.46	73.54	1004600.0
2018-05-22	ACWV	ETF	83.98	84.05	83.64	83.72	58700.0
2018-05-22	ACWX	ETF	50.6	50.65	50.4243	50.47	271777.0
2018-05-22	ADRE	ETF	43.86	43.938	43.852	43.9157	2546.0
2018-05-22	AFK	ETF	25.24	25.5	25.2	25.47	5672.0
2018-05-22	AFTY	ETF	17.36	17.36	17.3	17.3	5100.0
2018-05-22	AGG	ETF	105.32	105.37	105.28	105.31	2246400.0
2018-05-22	AGGY	ETF	48.24	48.24	48.181	48.195	36800.0
2018-05-22	AGNG	ETF	20.13	20.13	20.13	20.13	600.0
2018-05-22	AGQ	ETF	31.9	32.0	31.5	31.58	81700.0
2018-05-22	AGZ	ETF	110.7016	110.76	110.58	110.63	12601.0
2018-05-22	AGZD	ETF	23.93	24.015	23.93	24.015	5800.0
2018-05-22	AIA	ETF	67.77	67.97	67.56	67.59	55194.0
2018-05-22	AIEQ	ETF	27.94	27.949	27.73	27.76	30900.0
2018-05-22	AIQ	ETF	15.11	15.11	14.95	14.95	27499.0
2018-05-22	AIRR	ETF	26.91	26.91	26.5	26.5	15100.0
2018-05-22	AIVI	ETF	44.81	44.82	44.66	44.66	4700.0
2018-05-22	ALTY	ETF	14.75	14.85	14.75	14.85	13600.0
2018-05-22	AMJ	ETF	27.43	27.73	27.405	27.43	1955261.0
2018-05-22	AMLP	ETF	52.4	52.9	52.15	52.25	2385800.0
2018-05-22	AMZA	ETF	77.0	77.5	76.5	76.7	99790.0
2018-05-22	ANGL	ETF	28.99	29.03	28.93	28.96	133000.0
2018-05-22	AOA	ETF	54.42	54.5	54.25	54.3	28100.0
2018-05-22	AOK	ETF	34.08	34.1266	34.05	34.06	37536.0
2018-05-22	AOM	ETF	37.69	37.76	37.67	37.7	94519.0
2018-05-22	AOR	ETF	44.97	44.98	44.8005	44.86	82912.0
2018-05-22	ARGT	ETF	31.67	31.72	31.38	31.4	137700.0
2018-05-22	ARKG	ETF	27.99	28.58	27.954	28.45	336800.0
2018-05-22	ARKK	ETF	43.0	43.09	42.7	42.87	242100.0
2018-05-22	ARKQ	ETF	34.37	34.37	34.0	34.0	53500.0
2018-05-22	ARKW	ETF	53.29	53.29	52.536	52.6	96600.0
2018-05-22	ASET	ETF	28.07	28.07	28.07	28.07	244.0
2018-05-22	ASHR	ETF	30.81	30.82	30.65	30.72	479100.0
2018-05-22	ASHS	ETF	35.0	35.1	34.95	34.95	5000.0
2018-05-22	ATMP	ETF	20.8	20.9	20.68	20.7	16800.0
2018-05-22	BAB	ETF	29.33	29.34	29.23	29.3	74970.0
2018-05-22	BAL	ETF	53.35	53.35	52.6102	52.6102	25600.0
2018-05-22	BAR	ETF	12.926	12.927	12.91	12.91	303010.0
2018-05-22	BBC	ETF	33.5	33.65	33.255	33.3431	7914.0

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

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