PREVIEW / etf_daily / 2021-01-15

all etf daily files

  file:    by_date/etf_daily/2021/2021-01-15.parquet
  size:    84 KB
  rows:    2,225

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-15	SPY	ETF	376.72	377.58	373.7	375.7	107160000.0
2021-01-15	QQQ	ETF	314.13	315.12	310.58	311.86	35118718.0
2021-01-15	IWM	ETF	210.81	213.96	208.26	210.75	41043500.0
2021-01-15	DIA	ETF	308.01	309.32	306.03	308.12	4009100.0
2021-01-15	GLD	ETF	172.84	173.07	170.98	171.13	16172500.0
2021-01-15	TLT	ETF	152.19	152.36	151.47	151.82	11624700.0
2021-01-15	AAA	ETF	25.14	25.14	25.125	25.125	2400.0
2021-01-15	AAAU	ETF	18.36	18.37	18.16	18.18	333500.0
2021-01-15	AADR	ETF	62.23	62.46	62.23	62.31	1400.0
2021-01-15	AAXJ	ETF	94.97	95.2	94.46	94.73	1309300.0
2021-01-15	ABEQ	ETF	25.793	25.9	25.793	25.89	1100.0
2021-01-15	ACES	ETF	95.32	95.32	90.86	91.68	216200.0
2021-01-15	ACIO	ETF	27.78	27.78	27.595	27.675	18600.0
2021-01-15	ACSI	ETF	43.8	43.8	43.6145	43.6145	354.0
2021-01-15	ACTV	ETF	33.09	33.1105	32.98	32.99	1229.0
2021-01-15	ACTX	ETF	2.55	2.65	2.55	2.65	1284.0
2021-01-15	ACVF	ETF	30.0	30.0	27.69	27.9	14300.0
2021-01-15	ACWF	ETF	34.99	35.015	34.75	34.8345	15796.0
2021-01-15	ACWI	ETF	92.46	92.68	91.73	92.17	6946900.0
2021-01-15	ACWV	ETF	96.89	97.45	96.78	97.19	384400.0
2021-01-15	ACWX	ETF	54.76	54.845	54.3	54.58	1161527.0
2021-01-15	ADFI	ETF	9.9	9.9	9.886	9.886	14500.0
2021-01-15	ADME	ETF	36.1	36.1	35.6	35.71	16800.0
2021-01-15	ADRE	ETF	60.56	60.56	59.38	59.72	14963.0
2021-01-15	AESR	ETF	11.88	11.97	11.88	11.91	18300.0
2021-01-15	AFIF	ETF	9.76	9.77	9.76	9.76	36375.0
2021-01-15	AFK	ETF	21.35	21.35	21.0	21.0	27100.0
2021-01-15	AFLG	ETF	22.71	22.71	22.58	22.65	6500.0
2021-01-15	AFTY	ETF	24.11	24.125	24.02	24.057	10000.0
2021-01-15	AGG	ETF	117.34	117.36	117.18	117.25	6447700.0
2021-01-15	AGGY	ETF	53.19	53.28	53.164	53.26	74800.0
2021-01-15	AGNG	ETF	28.95	29.03	28.745	29.003	4400.0
2021-01-15	AGQ	ETF	44.61	45.36	43.31	43.88	1463100.0
2021-01-15	AGZ	ETF	119.25	119.35	119.2401	119.27	207581.0
2021-01-15	AGZD	ETF	23.515	23.59	23.515	23.555	55800.0
2021-01-15	AIA	ETF	94.75	94.75	93.84	94.34	205376.0
2021-01-15	AIEQ	ETF	38.92	38.92	37.96	38.085	20200.0
2021-01-15	AIQ	ETF	27.69	27.75	27.37	27.44	40638.0
2021-01-15	AIRR	ETF	37.09	37.09	36.329	36.805	23000.0
2021-01-15	AIVI	ETF	41.59	41.79	41.49	41.7	8800.0
2021-01-15	ALTL	ETF	34.66	34.66	34.23	34.2327	30550.0
2021-01-15	ALTY	ETF	12.01	12.03	11.902	12.018	9400.0
2021-01-15	AMJ	ETF	16.12	16.12	15.59	15.91	1226645.0
2021-01-15	AMLP	ETF	29.69	29.69	28.8	29.51	5805500.0
2021-01-15	AMNA	ETF	27.9581	27.9581	27.9581	27.9581	0.0
2021-01-15	AMND	ETF	29.7997	29.7997	29.7997	29.7997	4.0
2021-01-15	AMOM	ETF	32.11	32.396	32.08	32.246	2900.0
2021-01-15	AMTR	ETF	32.1227	32.1227	32.1227	32.1227	0.0
2021-01-15	AMUB	ETF	10.06	10.06	9.94	10.029	23304.0
2021-01-15	AMZA	ETF	22.82	22.855	21.96	22.53	87100.0

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

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