PREVIEW / etf_daily / 2019-07-11

all etf daily files

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

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-11	SPY	ETF	299.32	299.58	298.2	299.31	50826100.0
2019-07-11	QQQ	ETF	192.88	193.34	191.81	192.42	23736122.0
2019-07-11	IWM	ETF	155.89	155.94	154.22	154.91	14260800.0
2019-07-11	DIA	ETF	269.66	270.92	269.23	270.92	2238500.0
2019-07-11	GLD	ETF	133.58	133.7	132.41	132.7	7535100.0
2019-07-11	TLT	ETF	131.31	131.41	129.76	130.07	14126800.0
2019-07-11	AAAU	ETF	14.13	14.13	14.03	14.05	16400.0
2019-07-11	AADR	ETF	50.6	50.63	50.35	50.61	9700.0
2019-07-11	AAXJ	ETF	69.51	69.53	69.13	69.29	2085800.0
2019-07-11	ACES	ETF	30.31	30.33	30.18	30.18	4700.0
2019-07-11	ACIO	ETF	25.05	25.11	24.99	25.11	385700.0
2019-07-11	ACSI	ETF	34.24	34.35	34.24	34.3468	1490.0
2019-07-11	ACTX	ETF	28.9103	32.4503	27.7361	27.7361	353.0
2019-07-11	ACWF	ETF	29.53	29.53	29.4174	29.4967	4870.0
2019-07-11	ACWI	ETF	74.71	74.73	74.39	74.63	2890000.0
2019-07-11	ACWV	ETF	93.52	93.56	92.91	93.18	134800.0
2019-07-11	ACWX	ETF	46.94	47.03	46.73	46.84	1388742.0
2019-07-11	ADRE	ETF	40.2863	40.2863	40.07	40.17	4826.0
2019-07-11	AFIF	ETF	9.8951	9.91	9.868	9.868	5268.0
2019-07-11	AFK	ETF	22.19	22.19	22.1	22.1	6573.0
2019-07-11	AFTY	ETF	17.31	17.327	17.31	17.324	1200.0
2019-07-11	AGG	ETF	111.06	111.06	110.67	110.67	3303700.0
2019-07-11	AGGY	ETF	51.22	51.24	51.03	51.04	58200.0
2019-07-11	AGNG	ETF	21.61	21.61	21.37	21.45	2900.0
2019-07-11	AGQ	ETF	24.23	24.37	23.93	24.03	209300.0
2019-07-11	AGZ	ETF	114.83	114.83	114.59	114.6452	20127.0
2019-07-11	AGZD	ETF	23.915	23.93	23.895	23.92	14800.0
2019-07-11	AIA	ETF	60.97	61.0	60.6977	60.8	18011.0
2019-07-11	AIEQ	ETF	26.9	26.9	26.781	26.88	16100.0
2019-07-11	AIQ	ETF	16.81	16.85	16.72	16.8	38444.0
2019-07-11	AIRR	ETF	25.92	25.92	25.69	25.86	7100.0
2019-07-11	AIVI	ETF	41.16	41.16	40.97	41.05	4600.0
2019-07-11	ALTY	ETF	15.07	15.12	15.069	15.069	10800.0
2019-07-11	AMJ	ETF	25.71	25.83	25.67	25.74	1368744.0
2019-07-11	AMLP	ETF	50.55	50.8	50.45	50.7	2220160.0
2019-07-11	AMOM	ETF	26.421	26.481	26.421	26.481	500.0
2019-07-11	AMUB	ETF	16.2201	16.2201	16.2201	16.2201	0.0
2019-07-11	AMZA	ETF	57.7	57.8	57.3	57.4	47830.0
2019-07-11	ANGL	ETF	29.16	29.23	29.1	29.23	251200.0
2019-07-11	AOA	ETF	55.08	55.09	54.9	55.04	47300.0
2019-07-11	AOK	ETF	35.3	35.3	35.19	35.24	124785.0
2019-07-11	AOM	ETF	38.84	38.9	38.76	38.77	83422.0
2019-07-11	AOR	ETF	45.85	45.87	45.6685	45.79	56417.0
2019-07-11	ARGT	ETF	33.64	33.86	33.54	33.72	348300.0
2019-07-11	ARKF	ETF	23.22	23.27	23.15	23.213	14300.0
2019-07-11	ARKG	ETF	34.64	34.64	33.954	34.32	138600.0
2019-07-11	ARKK	ETF	48.64	48.84	48.161	48.61	153600.0
2019-07-11	ARKQ	ETF	33.38	33.82	33.38	33.69	31400.0
2019-07-11	ARKW	ETF	53.74	54.051	53.585	53.76	41900.0
2019-07-11	ASEA	ETF	16.85	16.85	16.6	16.66	11700.0

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

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