PREVIEW / etf_daily / 2021-07-15

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-15.parquet
  size:    91 KB
  rows:    2,422

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-07-15	SPY	ETF	434.81	435.53	432.72	434.75	55126400.0
2021-07-15	QQQ	ETF	362.98	363.19	358.46	360.52	53391557.0
2021-07-15	IWM	ETF	217.83	219.06	214.94	217.63	45477000.0
2021-07-15	DIA	ETF	347.9	350.0	347.64	349.94	5082600.0
2021-07-15	GLD	ETF	170.89	171.3	170.34	171.07	6520100.0
2021-07-15	TLT	ETF	147.95	148.6	147.03	148.49	18462400.0
2021-07-15	AAA	ETF	25.01	25.01	25.01	25.01	23.0
2021-07-15	AAAU	ETF	18.17	18.2	18.11	18.2	265400.0
2021-07-15	AADR	ETF	65.2	65.22	65.03	65.22	31400.0
2021-07-15	AAXJ	ETF	92.53	92.85	92.26	92.44	422100.0
2021-07-15	ABEQ	ETF	27.65	27.65	27.44	27.55	7700.0
2021-07-15	ACES	ETF	69.38	70.249	67.88	68.64	54100.0
2021-07-15	ACIO	ETF	30.77	30.77	30.66	30.725	47800.0
2021-07-15	ACSI	ETF	50.8272	50.8272	50.8272	50.8272	212.0
2021-07-15	ACTV	ETF	37.83	37.89	37.5101	37.8	4372.0
2021-07-15	ACTX	ETF	2.6	2.61	2.38	2.38	2672.0
2021-07-15	ACVF	ETF	31.91	32.13	31.74	32.129	3800.0
2021-07-15	ACWF	ETF	38.02	38.09	37.861	37.9901	8062.0
2021-07-15	ACWI	ETF	101.83	102.06	101.32	101.74	9559900.0
2021-07-15	ACWV	ETF	104.01	104.51	104.01	104.47	140000.0
2021-07-15	ACWX	ETF	57.14	57.285	56.9	57.11	1612376.0
2021-07-15	ADFI	ETF	9.77	9.77	9.75	9.75	1500.0
2021-07-15	ADIV	ETF	18.38	18.38	18.38	18.38	200.0
2021-07-15	ADME	ETF	40.42	40.44	40.246	40.43	132200.0
2021-07-15	ADRE	ETF	56.19	56.19	55.44	55.7334	4573.0
2021-07-15	AESR	ETF	13.73	13.78	13.72	13.763	12300.0
2021-07-15	AFIF	ETF	9.71	9.73	9.7	9.715	11637.0
2021-07-15	AFK	ETF	21.55	21.82	21.55	21.69	6888.0
2021-07-15	AFLG	ETF	25.58	25.583	25.57	25.583	600.0
2021-07-15	AFMC	ETF	24.94	24.94	24.847	24.847	600.0
2021-07-15	AFSM	ETF	25.38	25.52	25.353	25.353	400.0
2021-07-15	AFTY	ETF	22.57	22.593	22.56	22.584	5600.0
2021-07-15	AGG	ETF	115.94	116.02	115.72	116.0	4480900.0
2021-07-15	AGGY	ETF	52.63	52.692	52.548	52.68	66500.0
2021-07-15	AGNG	ETF	30.6	30.6	30.205	30.265	5700.0
2021-07-15	AGOX	ETF	26.15	26.15	25.69	25.76	23800.0
2021-07-15	AGQ	ETF	46.61	46.8	46.22	46.63	544700.0
2021-07-15	AGZ	ETF	118.81	118.9	118.7376	118.85	17206.0
2021-07-15	AGZD	ETF	23.55	23.56	23.485	23.52	95600.0
2021-07-15	AIA	ETF	89.92	90.18	89.4	89.76	236664.0
2021-07-15	AIEQ	ETF	40.0	40.39	39.491	39.75	19800.0
2021-07-15	AIQ	ETF	30.69	30.69	30.25	30.3773	19886.0
2021-07-15	AIRR	ETF	39.77	40.02	39.54	39.85	84100.0
2021-07-15	AIVI	ETF	43.54	43.54	43.4	43.53	3100.0
2021-07-15	ALTL	ETF	42.09	42.36	41.99	42.33	19283.0
2021-07-15	ALTY	ETF	13.49	13.54	13.46	13.46	16100.0
2021-07-15	AMJ	ETF	18.71	18.71	18.37	18.45	442190.0
2021-07-15	AMLP	ETF	34.5	34.63	33.96	34.15	3767600.0
2021-07-15	AMNA	ETF	32.5106	32.5106	32.5106	32.5106	85.0
2021-07-15	AMND	ETF	34.2678	34.2678	34.2678	34.2678	28.0

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

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