PREVIEW / etf_daily / 2021-01-21

all etf daily files

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

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-21	SPY	ETF	384.49	384.95	383.25	384.24	47840100.0
2021-01-21	QQQ	ETF	325.15	327.13	323.73	326.36	25316935.0
2021-01-21	IWM	ETF	214.97	215.16	211.95	212.53	21180500.0
2021-01-21	DIA	ETF	312.01	312.71	311.2	311.87	1930000.0
2021-01-21	GLD	ETF	175.11	175.51	174.51	175.28	7246800.0
2021-01-21	TLT	ETF	151.44	151.75	151.1	151.39	8162700.0
2021-01-21	AAA	ETF	25.1537	25.1537	25.14	25.15	3658.0
2021-01-21	AAAU	ETF	18.6	18.63	18.53	18.62	222000.0
2021-01-21	AADR	ETF	64.29	64.42	63.94	64.29	2800.0
2021-01-21	AAXJ	ETF	99.01	99.09	98.36	99.0	1507300.0
2021-01-21	ABEQ	ETF	25.87	25.87	25.75	25.754	18300.0
2021-01-21	ACES	ETF	94.75	97.78	93.788	97.46	128400.0
2021-01-21	ACIO	ETF	28.09	28.13	27.93	28.0	40500.0
2021-01-21	ACSI	ETF	44.698	44.698	44.698	44.698	520.0
2021-01-21	ACTV	ETF	33.599	33.599	33.05	33.1797	7253.0
2021-01-21	ACTX	ETF	3.3	3.7475	3.225	3.74	1624.0
2021-01-21	ACVF	ETF	28.73	28.73	28.431	28.52	7000.0
2021-01-21	ACWF	ETF	35.54	35.655	35.4959	35.65	3399.0
2021-01-21	ACWI	ETF	94.33	94.38	93.93	94.21	4978200.0
2021-01-21	ACWV	ETF	97.82	97.92	97.52	97.67	287100.0
2021-01-21	ACWX	ETF	55.82	55.82	55.455	55.77	1313506.0
2021-01-21	ADFI	ETF	9.91	9.91	9.875	9.883	3600.0
2021-01-21	ADME	ETF	36.75	36.75	36.48	36.61	24000.0
2021-01-21	ADRE	ETF	62.73	62.73	62.0101	62.57	46132.0
2021-01-21	AESR	ETF	12.2	12.22	12.18	12.205	39800.0
2021-01-21	AFIF	ETF	9.71	9.76	9.71	9.745	12742.0
2021-01-21	AFK	ETF	21.52	21.6	21.4001	21.42	18737.0
2021-01-21	AFLG	ETF	23.12	23.132	23.12	23.132	600.0
2021-01-21	AFMC	ETF	22.858	22.858	22.828	22.828	500.0
2021-01-21	AFSM	ETF	24.18	24.18	24.15	24.15	600.0
2021-01-21	AFTY	ETF	24.27	24.405	24.27	24.405	8800.0
2021-01-21	AGG	ETF	117.22	117.3	117.14	117.25	8301000.0
2021-01-21	AGGY	ETF	53.26	53.26	53.15	53.24	158100.0
2021-01-21	AGNG	ETF	29.42	29.42	29.153	29.247	5400.0
2021-01-21	AGQ	ETF	47.9	48.67	47.3	48.48	836800.0
2021-01-21	AGZ	ETF	119.29	119.3666	119.28	119.31	33169.0
2021-01-21	AGZD	ETF	23.67	23.675	23.615	23.625	14000.0
2021-01-21	AIA	ETF	99.49	99.89	99.06	99.79	248523.0
2021-01-21	AIEQ	ETF	39.4	39.47	39.0	39.43	30700.0
2021-01-21	AIQ	ETF	28.73	28.86	28.58	28.83	45447.0
2021-01-21	AIRR	ETF	37.56	37.56	36.976	37.142	14200.0
2021-01-21	AIVI	ETF	42.28	42.35	42.19	42.35	3900.0
2021-01-21	ALTL	ETF	34.6082	34.6082	34.105	34.1828	5285.0
2021-01-21	ALTY	ETF	12.05	12.09	12.01	12.028	26900.0
2021-01-21	AMJ	ETF	15.71	15.71	15.01	15.12	969461.0
2021-01-21	AMLP	ETF	28.97	29.04	27.71	27.95	3826500.0
2021-01-21	AMNA	ETF	27.4458	27.4458	27.4458	27.4458	3.0
2021-01-21	AMND	ETF	28.9985	28.9985	28.9985	28.9985	6.0
2021-01-21	AMOM	ETF	33.12	33.223	33.075	33.223	1300.0
2021-01-21	AMTR	ETF	31.58	31.66	31.26	31.529	3389.0

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

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