PREVIEW / etf_daily / 2019-07-02

all etf daily files

  file:    by_date/etf_daily/2019/2019-07-02.parquet
  size:    70 KB
  rows:    1,825

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-02	SPY	ETF	295.61	296.49	294.68	296.43	61504500.0
2019-07-02	QQQ	ETF	189.19	190.03	188.66	190.01	18035768.0
2019-07-02	IWM	ETF	156.02	156.12	154.26	155.15	19024600.0
2019-07-02	DIA	ETF	266.84	267.73	266.14	267.66	2775300.0
2019-07-02	GLD	ETF	131.27	133.63	131.16	133.41	13282100.0
2019-07-02	TLT	ETF	132.57	133.39	132.46	133.26	10494300.0
2019-07-02	AAAU	ETF	13.9	14.12	13.89	14.12	20200.0
2019-07-02	AADR	ETF	49.88	49.97	49.84	49.92	7000.0
2019-07-02	AAXJ	ETF	70.81	70.9	70.54	70.77	720500.0
2019-07-02	ACES	ETF	29.71	29.93	29.71	29.93	17700.0
2019-07-02	ACSI	ETF	33.8299	33.8434	33.79	33.8434	1494.0
2019-07-02	ACTX	ETF	31.2703	33.0403	28.9103	31.2703	371.0
2019-07-02	ACWF	ETF	29.4712	29.51	29.41	29.4613	6194.0
2019-07-02	ACWI	ETF	74.29	74.47	74.15	74.47	3807100.0
2019-07-02	ACWV	ETF	92.5	92.86	92.47	92.85	1367900.0
2019-07-02	ACWX	ETF	47.11	47.19	47.07	47.15	1199507.0
2019-07-02	ADRE	ETF	40.79	40.79	40.5	40.54	3838.0
2019-07-02	AFIF	ETF	9.935	9.94	9.9	9.9257	7308.0
2019-07-02	AFK	ETF	22.0833	22.0833	22.0	22.0	582.0
2019-07-02	AFTY	ETF	17.93	17.95	17.785	17.846	25300.0
2019-07-02	AGG	ETF	111.2	111.41	111.14	111.38	5765400.0
2019-07-02	AGGY	ETF	51.28	51.43	51.28	51.42	111300.0
2019-07-02	AGNG	ETF	21.39	21.62	21.39	21.58	4200.0
2019-07-02	AGQ	ETF	23.95	24.59	23.91	24.52	397400.0
2019-07-02	AGZ	ETF	115.06	115.1399	114.97	115.12	166787.0
2019-07-02	AGZD	ETF	23.865	23.89	23.83	23.89	11000.0
2019-07-02	AIA	ETF	61.98	62.02	61.7	61.82	199300.0
2019-07-02	AIEQ	ETF	26.55	26.64	26.5	26.64	62600.0
2019-07-02	AIQ	ETF	16.37	16.5069	16.37	16.48	8367.0
2019-07-02	AIRR	ETF	26.42	26.42	26.196	26.278	12800.0
2019-07-02	AIVI	ETF	41.42	41.52	41.42	41.47	3600.0
2019-07-02	ALTY	ETF	14.991	15.05	14.972	14.99	4700.0
2019-07-02	AMJ	ETF	25.08	25.24	24.9032	25.24	800562.0
2019-07-02	AMLP	ETF	49.35	49.55	49.05	49.45	1898920.0
2019-07-02	AMOM	ETF	26.104	26.104	26.104	26.104	100.0
2019-07-02	AMUB	ETF	15.7851	15.7851	15.7851	15.7851	140.0
2019-07-02	AMZA	ETF	56.0	56.0	55.1	55.8	51510.0
2019-07-02	ANGL	ETF	29.24	29.26	29.14	29.26	228900.0
2019-07-02	AOA	ETF	54.94	54.96	54.85	54.95	105800.0
2019-07-02	AOK	ETF	35.31	35.36	35.23	35.3	82948.0
2019-07-02	AOM	ETF	38.87	38.93	38.762	38.86	164068.0
2019-07-02	AOR	ETF	45.82	45.87	45.7182	45.87	87874.0
2019-07-02	ARCM	ETF	100.11	100.165	99.951	100.165	600.0
2019-07-02	ARGT	ETF	32.42	32.71	32.15	32.71	67300.0
2019-07-02	ARKF	ETF	22.82	22.89	22.777	22.89	13100.0
2019-07-02	ARKG	ETF	34.61	34.61	33.89	34.05	100300.0
2019-07-02	ARKK	ETF	47.97	48.0	47.112	47.44	228300.0
2019-07-02	ARKQ	ETF	34.05	34.05	33.13	33.28	18800.0
2019-07-02	ARKW	ETF	52.35	52.48	52.14	52.42	52300.0
2019-07-02	ASEA	ETF	16.84	16.98	16.84	16.88	1100.0

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

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