PREVIEW / etf_daily / 2019-07-22

all etf daily files

  file:    by_date/etf_daily/2019/2019-07-22.parquet
  size:    69 KB
  rows:    1,819

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-07-22	SPY	ETF	297.61	298.5	297.04	297.9	43638100.0
2019-07-22	QQQ	ETF	191.5	192.94	191.44	192.53	18953596.0
2019-07-22	IWM	ETF	154.24	154.7	153.4	153.68	14474600.0
2019-07-22	DIA	ETF	271.77	272.16	270.8	271.65	1623500.0
2019-07-22	GLD	ETF	134.56	134.82	134.32	134.45	7570400.0
2019-07-22	TLT	ETF	132.47	132.49	131.74	131.94	5204100.0
2019-07-22	AAAU	ETF	14.24	14.27	14.22	14.23	56000.0
2019-07-22	AADR	ETF	51.81	51.87	51.78	51.86	31100.0
2019-07-22	AAXJ	ETF	69.75	69.84	69.62	69.73	953100.0
2019-07-22	ACES	ETF	30.57	30.57	30.43	30.52	5700.0
2019-07-22	ACIO	ETF	25.04	25.11	25.04	25.084	27200.0
2019-07-22	ACSI	ETF	34.13	34.26	34.12	34.12	1113.0
2019-07-22	ACTX	ETF	25.3702	25.3702	24.1902	25.3702	119.0
2019-07-22	ACWF	ETF	29.64	29.64	29.5477	29.5535	4450.0
2019-07-22	ACWI	ETF	74.39	74.48	74.24	74.4	1644700.0
2019-07-22	ACWV	ETF	92.95	93.0	92.65	92.71	250900.0
2019-07-22	ACWX	ETF	46.87	46.9	46.785	46.81	896456.0
2019-07-22	ADRE	ETF	40.7844	40.7844	40.6022	40.6599	2050.0
2019-07-22	AFIF	ETF	9.8738	9.875	9.86	9.875	3884.0
2019-07-22	AFK	ETF	21.86	21.99	21.86	21.9105	4060.0
2019-07-22	AFTY	ETF	17.5	17.51	17.405	17.405	1800.0
2019-07-22	AGG	ETF	111.41	111.41	111.3	111.31	2855100.0
2019-07-22	AGGY	ETF	51.43	51.43	51.36	51.385	67000.0
2019-07-22	AGNG	ETF	21.34	21.52	21.26	21.35	56300.0
2019-07-22	AGQ	ETF	27.97	28.26	27.92	28.2	374800.0
2019-07-22	AGZ	ETF	115.02	115.02	114.88	114.88	14929.0
2019-07-22	AGZD	ETF	23.925	23.955	23.91	23.945	7600.0
2019-07-22	AIA	ETF	61.59	61.695	61.42	61.42	35110.0
2019-07-22	AIEQ	ETF	26.7	26.805	26.68	26.69	27300.0
2019-07-22	AIQ	ETF	16.74	16.8149	16.73	16.805	7121.0
2019-07-22	AIRR	ETF	26.04	26.04	25.83	25.83	5000.0
2019-07-22	AIVI	ETF	40.94	40.98	40.92	40.93	1300.0
2019-07-22	ALTY	ETF	14.92	15.06	14.92	14.98	9600.0
2019-07-22	AMJ	ETF	25.5	25.775	25.49	25.73	843124.0
2019-07-22	AMLP	ETF	50.05	50.7	50.05	50.55	3068500.0
2019-07-22	AMOM	ETF	26.37	26.43	26.333	26.333	200.0
2019-07-22	AMUB	ETF	16.2184	16.2184	16.2184	16.2184	0.0
2019-07-22	AMZA	ETF	55.8	56.5	55.8	56.4	83190.0
2019-07-22	ANGL	ETF	29.15	29.33	29.15	29.33	220800.0
2019-07-22	AOA	ETF	54.91	54.99	54.85	54.89	64100.0
2019-07-22	AOK	ETF	35.33	35.38	35.2908	35.35	62578.0
2019-07-22	AOM	ETF	38.91	38.99	38.8581	38.89	95714.0
2019-07-22	AOR	ETF	45.8	45.86	45.75	45.85	99907.0
2019-07-22	ARGT	ETF	32.43	32.53	32.02	32.04	66200.0
2019-07-22	ARKF	ETF	23.04	23.159	23.04	23.065	10600.0
2019-07-22	ARKG	ETF	33.92	34.44	33.92	34.34	89700.0
2019-07-22	ARKK	ETF	48.51	48.84	48.4	48.74	202000.0
2019-07-22	ARKQ	ETF	33.83	34.227	33.83	34.02	12500.0
2019-07-22	ARKW	ETF	53.68	54.15	53.68	53.81	36800.0
2019-07-22	ASEA	ETF	16.92	16.93	16.65	16.79	3400.0

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

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