PREVIEW / etf_daily / 2019-06-18

all etf daily files

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

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-18	SPY	ETF	291.39	293.57	290.99	292.4	85434800.0
2019-06-18	QQQ	ETF	185.88	187.72	185.4291	186.41	48177301.0
2019-06-18	IWM	ETF	153.27	155.15	152.26	154.01	22100800.0
2019-06-18	DIA	ETF	263.23	265.8	262.94	265.33	6147700.0
2019-06-18	GLD	ETF	127.58	127.75	126.39	127.12	10309600.0
2019-06-18	TLT	ETF	132.74	132.86	131.95	132.35	10320700.0
2019-06-18	AAAU	ETF	13.51	13.52	13.4	13.45	33000.0
2019-06-18	AADR	ETF	48.61	48.8	48.61	48.73	1200.0
2019-06-18	AAXJ	ETF	67.05	68.17	67.05	67.97	734100.0
2019-06-18	ACES	ETF	28.63	29.41	28.63	29.246	7300.0
2019-06-18	ACSI	ETF	33.6301	33.82	33.6301	33.6909	925.0
2019-06-18	ACTX	ETF	11.8591	12.9801	10.626	12.9742	1617.0
2019-06-18	ACWF	ETF	28.8303	28.8303	28.76	28.76	8072.0
2019-06-18	ACWI	ETF	72.44	73.03	72.44	72.87	7473400.0
2019-06-18	ACWV	ETF	91.71	91.82	91.56	91.68	562700.0
2019-06-18	ACWX	ETF	45.59	46.02	45.59	45.99	4442911.0
2019-06-18	ADRE	ETF	38.94	39.5844	38.94	39.44	2880.0
2019-06-18	AFIF	ETF	9.872	9.9	9.872	9.8815	4477.0
2019-06-18	AFK	ETF	21.24	21.77	21.24	21.7	7038.0
2019-06-18	AFTY	ETF	16.46	16.91	16.46	16.89	4000.0
2019-06-18	AGG	ETF	110.94	110.97	110.71	110.84	3640300.0
2019-06-18	AGGY	ETF	50.95	51.019	50.9	50.96	65800.0
2019-06-18	AGNG	ETF	21.27	21.462	21.27	21.45	2600.0
2019-06-18	AGQ	ETF	23.66	24.0	23.39	23.77	327700.0
2019-06-18	AGZ	ETF	115.14	115.14	114.9267	114.96	25223.0
2019-06-18	AGZD	ETF	23.8	23.8	23.71	23.79	65800.0
2019-06-18	AIA	ETF	58.33	59.2786	58.33	59.2	33529.0
2019-06-18	AIEQ	ETF	25.88	26.27	25.88	26.11	66600.0
2019-06-18	AIQ	ETF	15.88	16.175	15.88	16.1	4490.0
2019-06-18	AIRR	ETF	25.226	25.564	25.226	25.42	10900.0
2019-06-18	AIVI	ETF	40.99	41.17	40.99	41.14	2200.0
2019-06-18	ALTY	ETF	14.89	14.9	14.87	14.9	4300.0
2019-06-18	AMJ	ETF	24.63	24.76	24.57	24.65	1568538.0
2019-06-18	AMLP	ETF	48.6	48.8	48.4	48.4	2695680.0
2019-06-18	AMOM	ETF	25.911	25.911	25.911	25.911	300.0
2019-06-18	AMUB	ETF	15.5137	15.5137	15.5137	15.5137	1.0
2019-06-18	AMZA	ETF	54.8	55.1	54.4	54.4	62810.0
2019-06-18	ANGL	ETF	28.97	28.99	28.84	28.98	125600.0
2019-06-18	AOA	ETF	54.1	54.59	54.1	54.54	49500.0
2019-06-18	AOK	ETF	35.06	35.1407	35.06	35.11	55116.0
2019-06-18	AOM	ETF	38.59	38.79	38.58	38.78	101607.0
2019-06-18	AOR	ETF	45.39	45.6451	45.372	45.58	60981.0
2019-06-18	ARGT	ETF	31.78	32.07	31.75	31.79	67700.0
2019-06-18	ARKF	ETF	22.32	22.55	22.16	22.36	32500.0
2019-06-18	ARKG	ETF	32.01	32.28	31.86	32.1	104600.0
2019-06-18	ARKK	ETF	44.98	45.54	44.85	45.11	467700.0
2019-06-18	ARKQ	ETF	31.58	32.13	31.46	31.8	10700.0
2019-06-18	ARKW	ETF	51.0	51.732	51.0	51.04	71900.0
2019-06-18	ASEA	ETF	16.3	16.5	16.12	16.32	4300.0
2019-06-18	ASET	ETF	29.6146	29.6146	29.61	29.61	1421.0

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

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