PREVIEW / etf_daily / 2019-11-15

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-15.parquet
  size:    72 KB
  rows:    1,878

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-11-15	SPY	ETF	311.02	311.84	310.26	311.79	62023600.0
2019-11-15	QQQ	ETF	202.61	202.91	202.0	202.91	18434519.0
2019-11-15	IWM	ETF	159.23	159.29	158.35	158.92	13119200.0
2019-11-15	DIA	ETF	278.87	279.95	278.5	279.94	2363300.0
2019-11-15	GLD	ETF	138.03	138.42	137.97	138.21	10106700.0
2019-11-15	TLT	ETF	137.48	138.16	137.43	137.76	4657600.0
2019-11-15	AAAU	ETF	14.62	14.66	14.61	14.64	18600.0
2019-11-15	AADR	ETF	50.08	50.39	50.08	50.3	4200.0
2019-11-15	AAXJ	ETF	70.09	70.25	70.01	70.1	448500.0
2019-11-15	ACES	ETF	31.94	32.028	31.93	32.022	6000.0
2019-11-15	ACIO	ETF	25.26	25.34	25.26	25.34	57100.0
2019-11-15	ACSI	ETF	34.75	34.917	34.75	34.917	2602.0
2019-11-15	ACTX	ETF	7.8176	9.7056	7.8176	8.8442	596.0
2019-11-15	ACWF	ETF	30.3926	30.5	30.3854	30.4691	6695.0
2019-11-15	ACWI	ETF	77.19	77.39	77.08	77.39	2037800.0
2019-11-15	ACWV	ETF	95.28	95.38	95.09	95.34	233800.0
2019-11-15	ACWX	ETF	48.0	48.2	48.0	48.2	2664860.0
2019-11-15	ADME	ETF	30.28	30.34	30.28	30.3	251900.0
2019-11-15	ADRE	ETF	41.08	41.2978	41.08	41.1795	1158.0
2019-11-15	AFIF	ETF	9.74	9.74	9.74	9.74	105.0
2019-11-15	AFK	ETF	20.5	20.71	20.5	20.6645	5471.0
2019-11-15	AFTY	ETF	17.51	17.58	17.5	17.547	32500.0
2019-11-15	AGG	ETF	112.46	112.46	112.38	112.41	4400400.0
2019-11-15	AGGY	ETF	52.08	52.13	52.07	52.09	420000.0
2019-11-15	AGNG	ETF	23.1	23.1	23.1	23.1	300.0
2019-11-15	AGQ	ETF	28.69	29.01	28.65	28.81	123500.0
2019-11-15	AGZ	ETF	115.79	115.84	115.79	115.8	15537.0
2019-11-15	AGZD	ETF	23.975	24.025	23.95	24.015	9400.0
2019-11-15	AIA	ETF	62.12	62.36	62.12	62.2	20250.0
2019-11-15	AIEQ	ETF	27.17	27.4	27.16	27.32	18800.0
2019-11-15	AIQ	ETF	17.0	17.0254	16.9641	17.0254	8730.0
2019-11-15	AIRR	ETF	28.67	28.76	28.6	28.61	30000.0
2019-11-15	AIVI	ETF	41.96	42.03	41.96	42.03	2600.0
2019-11-15	ALTY	ETF	14.72	14.73	14.69	14.72	5800.0
2019-11-15	AMJ	ETF	20.86	21.05	20.81	21.04	3528108.0
2019-11-15	AMLP	ETF	39.75	40.2	39.7	40.1	7213180.0
2019-11-15	AMOM	ETF	26.53	26.606	26.53	26.606	100.0
2019-11-15	AMUB	ETF	13.2379	13.2379	13.2379	13.2379	0.0
2019-11-15	AMZA	ETF	42.2	42.9	42.2	42.7	84990.0
2019-11-15	ANGL	ETF	29.22	29.29	29.19	29.27	164500.0
2019-11-15	AOA	ETF	56.64	56.81	56.6	56.81	26700.0
2019-11-15	AOK	ETF	35.93	35.9755	35.81	35.97	73752.0
2019-11-15	AOM	ETF	39.7	39.75	39.6544	39.75	192191.0
2019-11-15	AOR	ETF	46.97	47.1	46.96	47.04	82591.0
2019-11-15	ARGT	ETF	22.15	22.3	22.02	22.25	32700.0
2019-11-15	ARKF	ETF	23.12	23.21	23.1	23.21	6400.0
2019-11-15	ARKG	ETF	31.45	31.85	31.317	31.71	129000.0
2019-11-15	ARKK	ETF	46.99	47.48	46.866	47.4	270400.0
2019-11-15	ARKQ	ETF	34.69	34.694	34.46	34.65	13100.0
2019-11-15	ARKW	ETF	54.0	54.35	53.86	54.27	68100.0

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

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