PREVIEW / etf_daily / 2021-01-14

all etf daily files

  file:    by_date/etf_daily/2021/2021-01-14.parquet
  size:    85 KB
  rows:    2,235

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-01-14	SPY	ETF	380.59	381.13	378.1	378.46	49989100.0
2021-01-14	QQQ	ETF	316.5	317.53	313.8616	314.35	23500129.0
2021-01-14	IWM	ETF	211.24	215.0	211.13	213.94	33913700.0
2021-01-14	DIA	ETF	311.59	312.27	309.89	310.05	3232400.0
2021-01-14	GLD	ETF	173.44	174.22	172.66	173.28	13522700.0
2021-01-14	TLT	ETF	152.58	152.64	150.79	151.22	14835500.0
2021-01-14	AAA	ETF	25.105	25.105	25.105	25.105	174.0
2021-01-14	AAAU	ETF	18.41	18.5	18.34	18.4	682400.0
2021-01-14	AADR	ETF	63.3	63.53	63.29	63.4	2800.0
2021-01-14	AAXJ	ETF	96.08	96.42	95.69	95.83	1037800.0
2021-01-14	ABEQ	ETF	25.98	26.08	25.98	26.05	28400.0
2021-01-14	ACES	ETF	96.98	97.255	95.565	96.31	183700.0
2021-01-14	ACIO	ETF	27.925	27.925	27.68	27.68	23100.0
2021-01-14	ACSI	ETF	44.44	44.44	44.0423	44.0423	416.0
2021-01-14	ACTV	ETF	33.13	33.4865	33.11	33.3248	2135.0
2021-01-14	ACTX	ETF	2.46	2.94	2.46	2.94	702.0
2021-01-14	ACVF	ETF	28.2	28.35	28.01	28.015	8000.0
2021-01-14	ACWF	ETF	35.2752	35.37	35.241	35.243	8762.0
2021-01-14	ACWI	ETF	93.4	93.63	93.07	93.15	4452800.0
2021-01-14	ACWV	ETF	97.94	97.94	97.32	97.41	445200.0
2021-01-14	ACWX	ETF	55.24	55.55	55.21	55.37	1418188.0
2021-01-14	ADFI	ETF	9.88	9.88	9.88	9.88	100.0
2021-01-14	ADME	ETF	36.4	36.4	35.905	35.905	40600.0
2021-01-14	ADRE	ETF	60.375	61.93	60.22	60.89	29986.0
2021-01-14	AESR	ETF	12.04	12.08	11.988	11.988	7500.0
2021-01-14	AFIF	ETF	9.76	9.78	9.7401	9.744	77494.0
2021-01-14	AFK	ETF	21.17	21.41	21.1241	21.34	13242.0
2021-01-14	AFLG	ETF	22.759	22.759	22.759	22.759	100.0
2021-01-14	AFMC	ETF	22.727	22.727	22.727	22.727	100.0
2021-01-14	AFSM	ETF	24.036	24.036	24.036	24.036	100.0
2021-01-14	AFTY	ETF	24.17	24.28	24.16	24.16	25200.0
2021-01-14	AGG	ETF	117.37	117.45	117.08	117.13	6610500.0
2021-01-14	AGGY	ETF	53.3	53.33	53.15	53.16	79500.0
2021-01-14	AGNG	ETF	28.94	29.17	28.94	29.16	4200.0
2021-01-14	AGQ	ETF	46.51	48.35	46.47	47.0	1104100.0
2021-01-14	AGZ	ETF	119.3	119.3892	119.18	119.18	85349.0
2021-01-14	AGZD	ETF	23.545	23.615	23.545	23.59	15800.0
2021-01-14	AIA	ETF	95.25	95.98	94.93	95.1	346587.0
2021-01-14	AIEQ	ETF	38.79	39.16	38.755	38.98	27300.0
2021-01-14	AIQ	ETF	27.97	27.99	27.74	27.82	49627.0
2021-01-14	AIRR	ETF	37.03	37.6	36.95	37.33	24700.0
2021-01-14	AIVI	ETF	42.12	42.31	42.12	42.18	33000.0
2021-01-14	ALTL	ETF	35.1	35.2	35.0	35.09	3878.0
2021-01-14	ALTY	ETF	11.945	12.03	11.945	11.993	33400.0
2021-01-14	AMJ	ETF	16.1	16.26	16.015	16.13	2116681.0
2021-01-14	AMLP	ETF	29.6	30.12	29.57	29.9	2902900.0
2021-01-14	AMNA	ETF	28.2527	28.2527	28.2527	28.2527	0.0
2021-01-14	AMND	ETF	30.22	30.22	30.1574	30.1574	4001.0
2021-01-14	AMOM	ETF	32.8	32.8	32.448	32.448	900.0
2021-01-14	AMTR	ETF	32.17	32.58	32.17	32.4621	29500.0

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

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