PREVIEW / etf_daily / 2021-03-09

all etf daily files

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

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-09	SPY	ETF	385.85	389.91	385.31	387.17	113633600.0
2021-03-09	QQQ	ETF	307.47	313.73	306.92	311.77	80391114.0
2021-03-09	IWM	ETF	222.41	224.99	220.92	223.34	32247300.0
2021-03-09	DIA	ETF	319.47	321.77	318.44	318.61	5829900.0
2021-03-09	GLD	ETF	160.75	161.25	160.42	160.84	10382600.0
2021-03-09	TLT	ETF	139.27	139.82	138.97	139.74	14463400.0
2021-03-09	AAA	ETF	25.06	25.07	25.05	25.07	12502.0
2021-03-09	AAAU	ETF	17.06	17.12	17.04	17.08	387400.0
2021-03-09	AADR	ETF	61.62	62.9	61.62	62.87	4100.0
2021-03-09	AAXJ	ETF	92.88	94.26	92.88	93.78	743700.0
2021-03-09	ABEQ	ETF	26.1	26.1	25.91	25.91	900.0
2021-03-09	ACES	ETF	72.86	77.41	72.86	76.36	367100.0
2021-03-09	ACIO	ETF	27.595	27.66	27.56	27.57	9700.0
2021-03-09	ACSI	ETF	45.06	45.06	45.06	45.06	315.0
2021-03-09	ACTV	ETF	36.285	36.285	35.9912	35.9912	4404.0
2021-03-09	ACTX	ETF	3.99	3.99	3.8	3.8	569.0
2021-03-09	ACVF	ETF	28.85	29.06	28.85	28.9	1200.0
2021-03-09	ACWF	ETF	35.285	35.51	35.285	35.34	2873.0
2021-03-09	ACWI	ETF	93.26	94.21	93.22	93.71	4650400.0
2021-03-09	ACWV	ETF	95.88	96.37	95.76	95.87	274500.0
2021-03-09	ACWX	ETF	54.78	55.2	54.74	55.03	1077240.0
2021-03-09	ADFI	ETF	9.66	9.72	9.66	9.664	900.0
2021-03-09	ADME	ETF	35.491	35.8	35.491	35.61	18700.0
2021-03-09	ADRE	ETF	57.41	58.68	57.38	58.6	23202.0
2021-03-09	AESR	ETF	12.24	12.35	12.24	12.28	7500.0
2021-03-09	AFIF	ETF	9.735	9.75	9.71	9.735	28114.0
2021-03-09	AFK	ETF	20.89	21.0	20.89	20.99	8094.0
2021-03-09	AFLG	ETF	23.32	23.32	23.216	23.216	3600.0
2021-03-09	AFSM	ETF	24.976	24.976	24.976	24.976	1000.0
2021-03-09	AFTY	ETF	22.6	22.73	22.57	22.623	8300.0
2021-03-09	AGG	ETF	114.2	114.31	114.0	114.26	5676800.0
2021-03-09	AGGY	ETF	51.47	51.58	51.47	51.52	118100.0
2021-03-09	AGNG	ETF	27.2	27.47	27.2	27.36	3300.0
2021-03-09	AGQ	ETF	46.58	47.4	46.46	46.57	935100.0
2021-03-09	AGZ	ETF	118.03	118.1042	118.021	118.08	26224.0
2021-03-09	AGZD	ETF	23.655	23.68	23.59	23.63	43400.0
2021-03-09	AIA	ETF	93.31	94.7684	93.18	94.4	387626.0
2021-03-09	AIEQ	ETF	37.56	38.29	37.31	38.075	28800.0
2021-03-09	AIQ	ETF	27.72	28.518	27.72	28.41	74908.0
2021-03-09	AIRR	ETF	40.63	40.83	40.18	40.359	167200.0
2021-03-09	AIVI	ETF	42.36	42.47	42.34	42.42	5600.0
2021-03-09	ALTL	ETF	39.61	39.61	38.8871	39.03	16597.0
2021-03-09	ALTY	ETF	12.5	12.541	12.465	12.49	15700.0
2021-03-09	AMJ	ETF	17.27	17.27	16.77	16.82	581134.0
2021-03-09	AMLP	ETF	31.64	31.72	30.9	30.98	2045500.0
2021-03-09	AMNA	ETF	29.6185	29.6185	29.6185	29.6185	0.0
2021-03-09	AMND	ETF	31.5302	31.5302	31.5302	31.5302	0.0
2021-03-09	AMOM	ETF	31.51	31.8	31.51	31.607	1100.0
2021-03-09	AMPS	ETF	9.99	10.06	9.9728	10.015	39349.0
2021-03-09	AMTR	ETF	34.0756	34.0756	34.0756	34.0756	0.0

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

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