PREVIEW / etf_daily / 2019-06-13

all etf daily files

  file:    by_date/etf_daily/2019/2019-06-13.parquet
  size:    69 KB
  rows:    1,801

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-06-13	SPY	ETF	289.4	289.98	288.62	289.58	48945200.0
2019-06-13	QQQ	ETF	183.12	183.87	182.74	183.42	23715829.0
2019-06-13	IWM	ETF	152.31	153.18	151.87	153.07	14839400.0
2019-06-13	DIA	ETF	261.34	261.88	260.37	261.56	1882700.0
2019-06-13	GLD	ETF	126.03	126.77	125.96	126.6	5374800.0
2019-06-13	TLT	ETF	130.8	131.25	130.79	131.13	5560400.0
2019-06-13	AAAU	ETF	13.43	13.5	13.37	13.44	9600.0
2019-06-13	AADR	ETF	48.34	48.51	48.25	48.42	4700.0
2019-06-13	AAXJ	ETF	67.31	67.4	66.92	67.12	962100.0
2019-06-13	ACES	ETF	28.598	28.695	28.52	28.65	2400.0
2019-06-13	ACSI	ETF	33.4399	33.45	33.4244	33.4244	851.0
2019-06-13	ACTX	ETF	26.5502	26.5502	16.5201	18.8802	2643.0
2019-06-13	ACWF	ETF	28.8655	28.91	28.8655	28.89	4307.0
2019-06-13	ACWI	ETF	73.12	73.22	72.88	73.1	1056200.0
2019-06-13	ACWV	ETF	92.39	92.43	91.94	92.09	757200.0
2019-06-13	ACWX	ETF	46.4	46.42	46.21	46.28	511584.0
2019-06-13	ADRE	ETF	39.11	39.1556	38.82	38.869	3128.0
2019-06-13	AFIF	ETF	9.99	9.99	9.91	9.93	29927.0
2019-06-13	AFK	ETF	21.07	21.1382	21.07	21.07	1273.0
2019-06-13	AFTY	ETF	16.49	16.5	16.479	16.479	600.0
2019-06-13	AGG	ETF	110.43	110.62	110.4	110.6	2293200.0
2019-06-13	AGGY	ETF	50.74	50.81	50.73	50.8	147100.0
2019-06-13	AGNG	ETF	21.04	21.04	20.93	20.93	15000.0
2019-06-13	AGQ	ETF	23.13	23.54	23.13	23.41	262100.0
2019-06-13	AGZ	ETF	114.84	114.86	114.8088	114.85	29170.0
2019-06-13	AGZD	ETF	23.77	23.8	23.77	23.785	4200.0
2019-06-13	AIA	ETF	58.22	58.2822	57.94	58.01	24336.0
2019-06-13	AIEQ	ETF	25.88	26.029	25.84	25.89	17400.0
2019-06-13	AIQ	ETF	15.8265	15.8328	15.8	15.8228	4191.0
2019-06-13	AIRR	ETF	25.01	25.26	25.01	25.26	9000.0
2019-06-13	AIVI	ETF	41.16	41.16	41.01	41.02	2100.0
2019-06-13	ALTY	ETF	14.813	14.85	14.8	14.85	1600.0
2019-06-13	AMJ	ETF	24.98	25.06	24.89	24.93	1063567.0
2019-06-13	AMLP	ETF	49.15	49.35	49.0	49.1	2320980.0
2019-06-13	AMOM	ETF	26.27	26.43	25.75	25.76	13700.0
2019-06-13	AMUB	ETF	15.7012	15.7012	15.7012	15.7012	8.0
2019-06-13	AMZA	ETF	55.0	55.3	54.8	55.3	70120.0
2019-06-13	ANGL	ETF	28.84	28.89	28.81	28.85	199600.0
2019-06-13	AOA	ETF	54.12	54.2	54.0	54.1	24800.0
2019-06-13	AOK	ETF	34.89	34.97	34.8679	34.95	99265.0
2019-06-13	AOM	ETF	38.48	38.57	38.4708	38.51	57410.0
2019-06-13	AOR	ETF	45.29	45.29	45.1701	45.28	62943.0
2019-06-13	ARGT	ETF	31.93	32.03	31.29	32.0	304300.0
2019-06-13	ARKF	ETF	22.06	22.1	22.036	22.09	5900.0
2019-06-13	ARKG	ETF	30.74	30.96	30.4	30.96	425300.0
2019-06-13	ARKK	ETF	43.31	43.68	43.14	43.68	197600.0
2019-06-13	ARKQ	ETF	30.79	31.01	30.79	31.01	9200.0
2019-06-13	ARKW	ETF	49.81	50.07	49.69	50.05	42000.0
2019-06-13	ASEA	ETF	16.17	16.18	15.97	16.07	4500.0
2019-06-13	ASET	ETF	29.39	29.42	29.36	29.3701	7010.0

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

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