PREVIEW / etf_daily / 2020-03-12

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-12.parquet
  size:    75 KB
  rows:    1,986

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
2020-03-12	SPY	ETF	256.0	266.66	247.68	248.11	392220700.0
2020-03-12	QQQ	ETF	182.09	190.78	176.94	177.32	137820698.0
2020-03-12	IWM	ETF	116.77	119.9	111.6	111.97	70114300.0
2020-03-12	DIA	ETF	220.5	229.0	211.83	212.11	17322600.0
2020-03-12	GLD	ETF	151.53	151.55	146.85	147.79	32893400.0
2020-03-12	TLT	ETF	163.51	166.36	155.66	157.5	24361800.0
2020-03-12	AAAU	ETF	16.06	16.06	15.56	15.67	394700.0
2020-03-12	AADR	ETF	41.07	42.62	38.17	38.17	323800.0
2020-03-12	AAXJ	ETF	59.48	60.0	57.51	58.83	4046700.0
2020-03-12	ABEQ	ETF	21.83	21.83	20.0	20.153	8000.0
2020-03-12	ACES	ETF	29.99	30.39	28.49	28.52	122700.0
2020-03-12	ACIO	ETF	23.1	25.22	22.78	24.48	45300.0
2020-03-12	ACSI	ETF	28.17	28.17	27.23	27.253	8697.0
2020-03-12	ACTX	ETF	7.0801	7.0801	6.1951	6.4901	137.0
2020-03-12	ACWF	ETF	24.08	24.14	23.1813	23.4795	32361.0
2020-03-12	ACWI	ETF	61.31	63.0	59.5	59.74	10362200.0
2020-03-12	ACWV	ETF	80.91	82.2	78.21	78.37	1402400.0
2020-03-12	ACWX	ETF	37.05	37.25	35.235	35.55	3355326.0
2020-03-12	ADME	ETF	28.01	28.864	25.66	28.32	43800.0
2020-03-12	ADRE	ETF	33.91	34.9	31.5001	32.9	23361.0
2020-03-12	AESR	ETF	8.05	8.195	7.934	7.934	4900.0
2020-03-12	AFIF	ETF	9.87	10.02	9.58	9.64	4119.0
2020-03-12	AFK	ETF	15.0	15.0	14.08	14.08	19444.0
2020-03-12	AFLG	ETF	15.86	15.86	15.649	15.649	700.0
2020-03-12	AFMC	ETF	14.4	14.4	14.365	14.365	1000.0
2020-03-12	AFSM	ETF	13.85	13.85	13.695	13.695	400.0
2020-03-12	AFTY	ETF	15.7	15.7	15.28	15.39	18000.0
2020-03-12	AGG	ETF	113.98	114.75	109.06	110.13	18684800.0
2020-03-12	AGGY	ETF	51.6	52.588	49.77	51.07	903500.0
2020-03-12	AGNG	ETF	19.95	19.95	18.89	19.115	5100.0
2020-03-12	AGQ	ETF	24.82	25.23	23.05	23.54	483700.0
2020-03-12	AGZ	ETF	120.71	121.0138	117.36	119.88	111582.0
2020-03-12	AGZD	ETF	23.1	23.83	22.665	23.205	29000.0
2020-03-12	AIA	ETF	54.91	54.995	52.86	53.4	212818.0
2020-03-12	AIEQ	ETF	22.24	22.97	21.51	21.51	97700.0
2020-03-12	AIQ	ETF	14.99	15.182	14.35	14.45	21358.0
2020-03-12	AIRR	ETF	20.34	20.391	19.364	19.364	24600.0
2020-03-12	AIVI	ETF	30.9	30.9	29.37	29.9	67100.0
2020-03-12	ALTY	ETF	11.84	11.84	10.19	10.213	33200.0
2020-03-12	AMJ	ETF	11.0	11.04	9.81	9.84	6485530.0
2020-03-12	AMLP	ETF	20.5	21.15	19.0	19.2	12080400.0
2020-03-12	AMOM	ETF	21.29	22.92	21.29	21.727	400.0
2020-03-12	AMUB	ETF	7.1	7.1	6.21	6.2419	63827.0
2020-03-12	AMZA	ETF	15.6	15.6	13.8	13.8	170380.0
2020-03-12	ANGL	ETF	26.25	26.85	24.97	25.78	3642800.0
2020-03-12	AOA	ETF	47.07	48.0	45.0	45.6	344600.0
2020-03-12	AOK	ETF	33.85	33.9402	29.0	33.11	476603.0
2020-03-12	AOM	ETF	36.47	36.6372	34.87	35.56	613438.0
2020-03-12	AOR	ETF	41.22	41.3899	39.27	40.23	485437.0
2020-03-12	ARGT	ETF	18.51	18.51	17.57	17.66	57800.0

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

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