PREVIEW / etf_daily / 2019-01-24

all etf daily files

  file:    by_date/etf_daily/2019/2019-01-24.parquet
  size:    66 KB
  rows:    1,727

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
2019-01-24	SPY	ETF	263.21	264.2	262.08	263.55	59204100.0
2019-01-24	QQQ	ETF	162.66	163.44	162.0626	163.2	32413351.0
2019-01-24	IWM	ETF	144.43	145.76	144.33	145.47	16976300.0
2019-01-24	DIA	ETF	245.47	246.2	244.13	245.47	2840400.0
2019-01-24	GLD	ETF	121.16	121.36	120.92	121.09	5662500.0
2019-01-24	TLT	ETF	120.91	121.26	120.71	121.11	7121900.0
2019-01-24	AAAU	ETF	12.82	12.82	12.79	12.8	25300.0
2019-01-24	AADR	ETF	42.43	42.65	42.43	42.61	15200.0
2019-01-24	AAXJ	ETF	66.29	66.84	66.28	66.82	2027200.0
2019-01-24	ACES	ETF	24.6	24.688	24.557	24.688	700.0
2019-01-24	ACSI	ETF	30.805	30.87	30.7319	30.87	3082.0
2019-01-24	ACTX	ETF	48.9704	50.4455	47.2004	48.9704	570.0
2019-01-24	ACWF	ETF	27.8048	27.82	27.6901	27.82	41504.0
2019-01-24	ACWI	ETF	67.5	67.74	67.31	67.62	4520900.0
2019-01-24	ACWV	ETF	83.8	83.8	83.38	83.75	155700.0
2019-01-24	ACWX	ETF	43.97	44.17	43.93	44.09	2716664.0
2019-01-24	ADRE	ETF	38.7023	38.93	38.6813	38.7976	4760.0
2019-01-24	AFIF	ETF	9.94	9.9897	9.92	9.965	19289.0
2019-01-24	AFK	ETF	20.69	20.95	20.63	20.7839	16378.0
2019-01-24	AFTY	ETF	14.126	14.21	14.126	14.21	700.0
2019-01-24	AGG	ETF	106.72	106.84	106.67	106.73	7308900.0
2019-01-24	AGGY	ETF	48.47	48.535	48.44	48.51	45900.0
2019-01-24	AGNG	ETF	20.4	20.4	20.4	20.4	300.0
2019-01-24	AGQ	ETF	25.74	25.79	25.51	25.64	68800.0
2019-01-24	AGZ	ETF	112.15	112.2344	112.136	112.18	14321.0
2019-01-24	AGZD	ETF	23.615	23.705	23.615	23.68	106000.0
2019-01-24	AIA	ETF	57.8	58.4199	57.8	58.34	33464.0
2019-01-24	AIEQ	ETF	23.7	23.99	23.7	23.87	38700.0
2019-01-24	AIQ	ETF	14.07	14.0941	13.96	14.08	10798.0
2019-01-24	AIRR	ETF	23.18	23.49	23.06	23.48	23000.0
2019-01-24	AIVI	ETF	39.31	39.41	39.22	39.3	4500.0
2019-01-24	ALTY	ETF	14.34	14.38	14.31	14.37	5300.0
2019-01-24	AMJ	ETF	24.36	24.63	24.235	24.53	3153180.0
2019-01-24	AMLP	ETF	48.15	48.55	47.75	48.35	3336460.0
2019-01-24	AMUB	ETF	15.4731	15.4731	15.4731	15.4731	0.0
2019-01-24	AMZA	ETF	56.6	57.45	56.4	57.2	71190.0
2019-01-24	ANGL	ETF	27.84	27.91	27.82	27.85	223100.0
2019-01-24	AOA	ETF	50.61	50.75	50.5	50.69	615700.0
2019-01-24	AOK	ETF	33.31	33.4665	33.31	33.34	325475.0
2019-01-24	AOM	ETF	36.53	36.58	36.47	36.55	790426.0
2019-01-24	AOR	ETF	42.56	42.7	42.5358	42.65	1074714.0
2019-01-24	ARCM	ETF	99.93	100.005	99.93	100.005	600.0
2019-01-24	ARGT	ETF	26.18	26.54	26.18	26.42	41500.0
2019-01-24	ARKG	ETF	27.26	27.68	27.13	27.68	37900.0
2019-01-24	ARKK	ETF	40.77	41.59	40.77	41.58	287200.0
2019-01-24	ARKQ	ETF	31.25	31.6	31.15	31.484	10400.0
2019-01-24	ARKW	ETF	46.89	47.83	46.86	47.83	67500.0
2019-01-24	ASEA	ETF	15.95	16.05	15.86	16.05	400.0
2019-01-24	ASET	ETF	27.05	27.05	26.965	26.965	5281.0
2019-01-24	ASHR	ETF	23.39	23.49	23.38	23.48	856800.0

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

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