PREVIEW / etf_daily / 2019-08-14

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-14.parquet
  size:    71 KB
  rows:    1,856

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-08-14	SPY	ETF	288.07	288.74	283.76	283.9	135622100.0
2019-08-14	QQQ	ETF	185.31	185.95	182.42	182.76	51000548.0
2019-08-14	IWM	ETF	147.95	147.98	145.72	146.07	28235800.0
2019-08-14	DIA	ETF	259.18	259.73	255.06	255.08	6148000.0
2019-08-14	GLD	ETF	142.9	143.75	142.05	142.75	20672900.0
2019-08-14	TLT	ETF	145.16	145.73	144.71	145.69	15068900.0
2019-08-14	AAAU	ETF	15.12	15.92	15.1	15.12	218300.0
2019-08-14	AADR	ETF	48.51	49.05	48.27	48.53	10000.0
2019-08-14	AAXJ	ETF	63.23	63.41	62.74	62.74	1570700.0
2019-08-14	ACES	ETF	30.72	30.72	30.09	30.165	13600.0
2019-08-14	ACIO	ETF	24.152	24.17	24.02	24.11	21800.0
2019-08-14	ACSI	ETF	33.15	33.16	32.66	32.66	2122.0
2019-08-14	ACTX	ETF	23.6061	26.5502	22.4202	23.6002	455.0
2019-08-14	ACWF	ETF	27.78	27.78	27.38	27.3878	13492.0
2019-08-14	ACWI	ETF	70.97	71.07	70.04	70.15	4146700.0
2019-08-14	ACWV	ETF	91.82	92.05	91.0	91.0	365700.0
2019-08-14	ACWX	ETF	43.85	43.92	43.46	43.46	1535155.0
2019-08-14	ADRE	ETF	37.03	37.03	36.7	36.7	3795.0
2019-08-14	AFIF	ETF	9.94	9.94	9.69	9.7098	46730.0
2019-08-14	AFK	ETF	19.6	19.78	19.1281	19.55	14096.0
2019-08-14	AFTY	ETF	16.38	16.38	16.3	16.3	10300.0
2019-08-14	AGG	ETF	113.28	113.38	113.21	113.24	2829900.0
2019-08-14	AGGY	ETF	52.4	52.44	52.36	52.42	167200.0
2019-08-14	AGNG	ETF	21.3	21.3	20.92	20.92	1900.0
2019-08-14	AGQ	ETF	30.76	31.18	30.31	30.73	684100.0
2019-08-14	AGZ	ETF	116.68	116.7999	116.68	116.79	18917.0
2019-08-14	AGZD	ETF	23.855	23.855	23.775	23.845	22600.0
2019-08-14	AIA	ETF	55.11	55.17	54.6601	54.7	171329.0
2019-08-14	AIEQ	ETF	25.62	25.7	25.202	25.307	51500.0
2019-08-14	AIQ	ETF	15.6712	15.78	15.45	15.5045	6487.0
2019-08-14	AIRR	ETF	24.95	24.95	24.52	24.57	3000.0
2019-08-14	AIVI	ETF	38.83	38.83	38.51	38.52	3800.0
2019-08-14	ALTY	ETF	14.82	14.82	14.48	14.48	15800.0
2019-08-14	AMJ	ETF	23.2	23.29	22.82	23.02	2972637.0
2019-08-14	AMLP	ETF	44.55	44.55	43.9	44.5	4819360.0
2019-08-14	AMOM	ETF	26.1	26.1	25.66	25.811	2600.0
2019-08-14	AMUB	ETF	14.5032	14.5032	14.5032	14.5032	0.0
2019-08-14	AMZA	ETF	48.0	48.5	46.8	47.5	391450.0
2019-08-14	ANGL	ETF	28.78	28.78	28.56	28.62	298000.0
2019-08-14	AOA	ETF	53.61	53.61	52.61	52.61	51200.0
2019-08-14	AOK	ETF	35.26	35.26	35.12	35.13	80084.0
2019-08-14	AOM	ETF	38.59	38.61	38.4	38.4	142636.0
2019-08-14	AOR	ETF	44.89	44.95	44.55	44.63	60143.0
2019-08-14	ARCM	ETF	100.21	100.21	100.21	100.21	7500.0
2019-08-14	ARGT	ETF	25.21	25.21	24.3	24.3	288700.0
2019-08-14	ARKF	ETF	21.053	21.08	20.74	20.852	17700.0
2019-08-14	ARKG	ETF	32.0	32.14	31.322	31.43	127100.0
2019-08-14	ARKK	ETF	44.32	44.53	43.33	43.64	366100.0
2019-08-14	ARKQ	ETF	30.22	30.34	29.79	29.91	17800.0
2019-08-14	ARKW	ETF	48.85	48.85	47.59	47.89	93800.0

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

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