PREVIEW / etf_daily / 2021-03-03

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-03.parquet
  size:    86 KB
  rows:    2,279

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-03-03	SPY	ETF	385.79	386.83	381.31	381.42	119940200.0
2021-03-03	QQQ	ETF	317.27	318.24	309.1	309.16	86301073.0
2021-03-03	IWM	ETF	222.42	224.26	219.21	219.32	33407600.0
2021-03-03	DIA	ETF	313.94	315.87	312.83	312.99	5148100.0
2021-03-03	GLD	ETF	160.61	161.69	159.49	160.62	13059900.0
2021-03-03	TLT	ETF	139.38	140.15	138.76	139.54	19763700.0
2021-03-03	AAA	ETF	25.074	25.074	25.07	25.07	301.0
2021-03-03	AAAU	ETF	17.07	17.17	16.94	17.06	1214600.0
2021-03-03	AADR	ETF	63.95	63.95	63.21	63.21	2600.0
2021-03-03	AAXJ	ETF	97.03	97.23	95.59	95.62	2076100.0
2021-03-03	ABEQ	ETF	25.55	25.75	25.51	25.58	39600.0
2021-03-03	ACES	ETF	82.2	82.62	77.63	77.9	121600.0
2021-03-03	ACIO	ETF	27.69	27.69	27.298	27.3	33500.0
2021-03-03	ACSI	ETF	44.87	44.87	44.6612	44.6612	2323.0
2021-03-03	ACTV	ETF	35.215	35.4474	35.0394	35.0394	2043.0
2021-03-03	ACTX	ETF	6.2	6.5	5.25	5.25	1351.0
2021-03-03	ACVF	ETF	28.91	28.91	28.508	28.508	600.0
2021-03-03	ACWF	ETF	35.5	35.5	35.07	35.07	13809.0
2021-03-03	ACWI	ETF	93.95	94.21	93.0	93.0	4099000.0
2021-03-03	ACWV	ETF	94.97	94.99	94.44	94.44	461700.0
2021-03-03	ACWX	ETF	55.35	55.46	55.03	55.08	1652062.0
2021-03-03	ADFI	ETF	9.71	9.72	9.67	9.694	1500.0
2021-03-03	ADME	ETF	35.7	35.89	35.497	35.497	20400.0
2021-03-03	ADRE	ETF	60.77	60.77	59.33	59.605	35454.0
2021-03-03	AESR	ETF	12.24	12.27	12.113	12.113	4700.0
2021-03-03	AFIF	ETF	9.64	9.72	9.64	9.6854	79965.0
2021-03-03	AFK	ETF	21.6	21.6	21.22	21.31	8509.0
2021-03-03	AFLG	ETF	23.24	23.24	22.902	22.902	1600.0
2021-03-03	AFMC	ETF	23.31	23.31	23.31	23.31	900.0
2021-03-03	AFTY	ETF	24.17	24.29	24.17	24.216	2400.0
2021-03-03	AGG	ETF	114.8	114.83	114.6	114.69	10317500.0
2021-03-03	AGGY	ETF	51.96	51.96	51.849	51.9	98500.0
2021-03-03	AGNG	ETF	27.87	27.87	27.35	27.35	10000.0
2021-03-03	AGQ	ETF	47.52	48.74	46.22	47.57	1251200.0
2021-03-03	AGZ	ETF	118.25	118.2895	118.18	118.2603	40873.0
2021-03-03	AGZD	ETF	23.645	23.68	23.615	23.665	73400.0
2021-03-03	AIA	ETF	97.23	97.35	95.525	95.68	213444.0
2021-03-03	AIEQ	ETF	39.21	39.35	38.03	38.07	40500.0
2021-03-03	AIQ	ETF	29.03	29.2	28.295	28.36	32052.0
2021-03-03	AIRR	ETF	39.09	40.0	39.09	39.333	60000.0
2021-03-03	AIVI	ETF	42.0	42.12	41.86	41.9	9400.0
2021-03-03	ALTL	ETF	38.53	39.2593	38.53	38.6	7563.0
2021-03-03	ALTY	ETF	12.43	12.43	12.32	12.39	11100.0
2021-03-03	AMJ	ETF	16.63	16.99	16.58	16.68	998223.0
2021-03-03	AMLP	ETF	30.63	31.38	30.55	30.69	2842400.0
2021-03-03	AMNA	ETF	29.0623	29.0623	29.0623	29.0623	0.0
2021-03-03	AMND	ETF	31.0049	31.0049	31.0049	31.0049	1.0
2021-03-03	AMOM	ETF	32.26	32.26	31.6	31.6	2600.0
2021-03-03	AMPS	ETF	9.97	10.22	9.96	10.0	83393.0
2021-03-03	AMTR	ETF	33.4263	33.4263	33.4263	33.4263	0.0

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

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