PREVIEW / etf_daily / 2020-04-03

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-03.parquet
  size:    74 KB
  rows:    1,934

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-04-03	SPY	ETF	250.76	253.32	245.22	248.19	135561200.0
2020-04-03	QQQ	ETF	185.5	187.0716	181.29	183.37	47487621.0
2020-04-03	IWM	ETF	106.59	108.0	102.6	104.62	42189200.0
2020-04-03	DIA	ETF	212.73	214.55	208.69	210.6	6664500.0
2020-04-03	GLD	ETF	152.23	153.09	151.66	152.65	8469100.0
2020-04-03	TLT	ETF	168.55	170.33	168.14	168.5	6570800.0
2020-04-03	AAAU	ETF	16.15	16.23	16.08	16.18	160300.0
2020-04-03	AADR	ETF	39.37	39.37	38.8	39.03	8200.0
2020-04-03	AAXJ	ETF	58.88	59.08	57.79	58.09	1397800.0
2020-04-03	ABEQ	ETF	19.83	19.89	19.79	19.815	6400.0
2020-04-03	ACES	ETF	27.46	27.46	26.38	26.651	37600.0
2020-04-03	ACIO	ETF	22.405	22.463	22.405	22.463	3400.0
2020-04-03	ACSI	ETF	26.4313	26.4313	26.4313	26.4313	213.0
2020-04-03	ACTX	ETF	3.835	4.189	3.835	4.13	823.0
2020-04-03	ACWF	ETF	23.46	23.57	22.95	23.07	30007.0
2020-04-03	ACWI	ETF	60.59	60.97	59.36	59.99	3180200.0
2020-04-03	ACWV	ETF	79.38	79.59	77.91	78.42	592800.0
2020-04-03	ACWX	ETF	36.37	36.47	35.78	35.95	2892262.0
2020-04-03	ADME	ETF	28.8	28.8	27.17	27.373	9600.0
2020-04-03	ADRE	ETF	32.981	32.981	32.21	32.4463	4623.0
2020-04-03	AESR	ETF	8.06	8.085	7.89	7.94	7000.0
2020-04-03	AFIF	ETF	9.75	9.77	9.615	9.72	104017.0
2020-04-03	AFK	ETF	12.69	12.76	11.76	12.21	30706.0
2020-04-03	AFTY	ETF	15.014	15.036	14.995	15.036	800.0
2020-04-03	AGG	ETF	114.95	115.13	114.28	114.98	9786700.0
2020-04-03	AGGY	ETF	51.64	51.81	51.59	51.61	182200.0
2020-04-03	AGNG	ETF	19.674	19.674	19.29	19.383	1800.0
2020-04-03	AGQ	ETF	19.53	19.72	19.1	19.28	186300.0
2020-04-03	AGZ	ETF	120.6924	121.0	120.55	120.58	39434.0
2020-04-03	AGZD	ETF	23.12	23.14	23.005	23.115	5800.0
2020-04-03	AIA	ETF	55.61	55.75	54.6101	54.86	34757.0
2020-04-03	AIEQ	ETF	21.95	22.06	21.55	21.82	20000.0
2020-04-03	AIQ	ETF	15.04	15.6694	14.6403	14.94	29023.0
2020-04-03	AIRR	ETF	18.98	19.18	18.264	18.38	16100.0
2020-04-03	AIVI	ETF	30.43	30.61	30.11	30.28	17500.0
2020-04-03	ALTY	ETF	8.14	8.14	7.61	7.74	8900.0
2020-04-03	AMJ	ETF	9.6	9.97	8.67	9.35	4123602.0
2020-04-03	AMLP	ETF	18.35	18.55	16.4	17.85	11178700.0
2020-04-03	AMUB	ETF	5.7	5.8638	5.7	5.8638	840.0
2020-04-03	AMZA	ETF	11.75	11.775	10.312	11.2	87200.0
2020-04-03	ANGL	ETF	25.61	25.7	24.66	25.7	1004200.0
2020-04-03	AOA	ETF	46.22	46.59	45.6	46.1	116200.0
2020-04-03	AOK	ETF	33.62	33.7024	33.3001	33.39	80503.0
2020-04-03	AOM	ETF	36.06	36.21	35.8	35.99	240839.0
2020-04-03	AOR	ETF	40.62	40.75	40.13	40.37	131277.0
2020-04-03	ARGT	ETF	15.37	15.89	15.34	15.78	13500.0
2020-04-03	ARKF	ETF	19.2	19.25	18.66	18.82	31000.0
2020-04-03	ARKG	ETF	30.24	30.5	29.54	29.79	81100.0
2020-04-03	ARKK	ETF	40.95	41.5	39.8	40.2	493700.0
2020-04-03	ARKQ	ETF	31.23	31.79	30.48	30.76	30500.0

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

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