PREVIEW / etf_daily / 2021-05-04

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-04.parquet
  size:    88 KB
  rows:    2,336

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
2021-05-04	SPY	ETF	416.07	416.6	411.67	415.62	101591200.0
2021-05-04	QQQ	ETF	333.56	333.89	326.21	330.14	65146972.0
2021-05-04	IWM	ETF	224.6	226.14	220.96	223.29	26892700.0
2021-05-04	DIA	ETF	339.99	341.53	337.62	341.49	4478300.0
2021-05-04	GLD	ETF	167.69	168.55	165.5	166.58	10267400.0
2021-05-04	TLT	ETF	139.49	140.16	139.16	139.46	18639700.0
2021-05-04	AAA	ETF	25.03	25.03	25.02	25.02	2010.0
2021-05-04	AAAU	ETF	17.82	17.9	17.63	17.69	594000.0
2021-05-04	AADR	ETF	65.41	65.41	64.51	64.62	2700.0
2021-05-04	AAXJ	ETF	92.87	93.04	91.74	92.49	1182700.0
2021-05-04	ABEQ	ETF	27.71	27.71	27.71	27.71	600.0
2021-05-04	ACES	ETF	70.0	70.03	67.902	68.46	114100.0
2021-05-04	ACIO	ETF	29.605	29.627	29.52	29.627	10200.0
2021-05-04	ACSI	ETF	48.5378	48.7772	48.5378	48.7772	638.0
2021-05-04	ACTV	ETF	37.54	37.54	36.97	37.2665	8717.0
2021-05-04	ACVF	ETF	31.02	31.02	30.73	30.861	9600.0
2021-05-04	ACWF	ETF	37.52	37.55	37.2	37.4473	21569.0
2021-05-04	ACWI	ETF	98.94	99.0	97.8	98.64	2401100.0
2021-05-04	ACWV	ETF	101.24	101.61	100.99	101.38	138300.0
2021-05-04	ACWX	ETF	56.41	56.56	55.9	56.25	2302364.0
2021-05-04	ADFI	ETF	9.71	9.79	9.69	9.69	6000.0
2021-05-04	ADIV	ETF	18.5	18.504	18.47	18.494	500.0
2021-05-04	ADME	ETF	38.53	38.544	38.38	38.544	13700.0
2021-05-04	ADRE	ETF	56.12	56.41	55.5	56.04	30787.0
2021-05-04	AESR	ETF	13.145	13.164	13.06	13.164	41600.0
2021-05-04	AFIF	ETF	9.76	9.76	9.72	9.73	34291.0
2021-05-04	AFK	ETF	21.75	21.77	21.5727	21.6175	11000.0
2021-05-04	AFLG	ETF	24.865	24.865	24.865	24.865	1600.0
2021-05-04	AFSM	ETF	25.77	25.77	25.77	25.77	1600.0
2021-05-04	AFTY	ETF	22.55	22.55	22.441	22.441	100.0
2021-05-04	AGG	ETF	114.55	114.7	114.41	114.53	6291300.0
2021-05-04	AGGY	ETF	51.77	51.853	51.755	51.81	70300.0
2021-05-04	AGNG	ETF	28.83	28.83	28.62	28.635	8000.0
2021-05-04	AGQ	ETF	49.81	50.48	46.53	47.98	2158100.0
2021-05-04	AGZ	ETF	118.09	118.2399	118.05	118.16	36184.0
2021-05-04	AGZD	ETF	23.62	23.62	23.535	23.56	56400.0
2021-05-04	AIA	ETF	91.62	91.62	90.45	91.05	348084.0
2021-05-04	AIEQ	ETF	38.21	38.296	37.37	37.79	31800.0
2021-05-04	AIQ	ETF	29.0	29.0	28.205	28.58	45524.0
2021-05-04	AIRR	ETF	42.12	42.12	41.605	42.05	78700.0
2021-05-04	AIVI	ETF	43.09	43.11	42.99	43.1	4400.0
2021-05-04	ALTL	ETF	41.26	41.26	41.05	41.22	33108.0
2021-05-04	ALTY	ETF	13.45	13.47	13.31	13.41	28200.0
2021-05-04	AMJ	ETF	17.76	18.07	17.76	18.02	872948.0
2021-05-04	AMLP	ETF	33.1	33.37	32.8	33.11	2743000.0
2021-05-04	AMNA	ETF	31.5421	31.5421	31.5421	31.5421	1.0
2021-05-04	AMND	ETF	33.5078	33.5078	33.5078	33.5078	0.0
2021-05-04	AMOM	ETF	35.0	35.005	34.56	34.98	170200.0
2021-05-04	AMPS	ETF	9.945	9.95	9.94	9.95	98462.0
2021-05-04	AMTR	ETF	36.8856	36.8856	36.8856	36.8856	30.0

> showing 50 of 2,336 rows — these rows as CSV

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