PREVIEW / etf_daily / 2021-02-22

all etf daily files

  file:    by_date/etf_daily/2021/2021-02-22.parquet
  size:    85 KB
  rows:    2,266

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-02-22	SPY	ETF	387.06	389.62	386.74	387.03	67414200.0
2021-02-22	QQQ	ETF	326.5	327.8	322.23	322.44	47256944.0
2021-02-22	IWM	ETF	223.51	226.39	222.98	223.73	23272100.0
2021-02-22	DIA	ETF	312.9	316.49	312.77	315.21	2978000.0
2021-02-22	GLD	ETF	168.54	169.89	168.3	169.51	10072000.0
2021-02-22	TLT	ETF	143.03	143.74	141.72	142.18	13203900.0
2021-02-22	AAA	ETF	25.09	25.09	25.09	25.09	616.0
2021-02-22	AAAU	ETF	17.91	18.04	17.88	18.0	572200.0
2021-02-22	AADR	ETF	65.41	65.71	65.0	65.0	1500.0
2021-02-22	AAXJ	ETF	98.82	99.28	98.26	98.3	1634600.0
2021-02-22	ABEQ	ETF	25.563	25.82	25.535	25.82	5200.0
2021-02-22	ACES	ETF	90.15	90.15	85.375	85.41	214200.0
2021-02-22	ACIO	ETF	27.789	27.79	27.685	27.75	26600.0
2021-02-22	ACSI	ETF	45.1399	45.1399	44.9534	44.9534	693.0
2021-02-22	ACTV	ETF	35.1	35.14	34.909	34.909	58725.0
2021-02-22	ACTX	ETF	4.42	5.0	4.04	4.65	884.0
2021-02-22	ACVF	ETF	29.04	29.04	28.827	28.827	1600.0
2021-02-22	ACWF	ETF	35.8	35.88	35.68	35.68	6618.0
2021-02-22	ACWI	ETF	94.91	95.47	94.8	94.84	1454900.0
2021-02-22	ACWV	ETF	95.88	96.31	95.88	96.08	297600.0
2021-02-22	ACWX	ETF	56.03	56.39	55.99	56.02	1099877.0
2021-02-22	ADFI	ETF	9.79	9.79	9.74	9.753	29300.0
2021-02-22	ADME	ETF	36.25	36.36	36.13	36.18	74100.0
2021-02-22	ADRE	ETF	63.51	63.7602	62.88	63.04	53426.0
2021-02-22	AESR	ETF	12.31	12.38	12.281	12.281	144800.0
2021-02-22	AFIF	ETF	9.7	9.74	9.7	9.71	316702.0
2021-02-22	AFK	ETF	22.0	22.2032	22.0	22.13	20349.0
2021-02-22	AFLG	ETF	23.284	23.284	23.284	23.284	200.0
2021-02-22	AFSM	ETF	25.46	25.46	25.271	25.271	400.0
2021-02-22	AFTY	ETF	25.2	25.25	25.082	25.152	7300.0
2021-02-22	AGG	ETF	115.76	115.87	115.48	115.48	4894200.0
2021-02-22	AGGY	ETF	52.24	52.305	52.16	52.168	194700.0
2021-02-22	AGNG	ETF	28.61	28.75	28.495	28.53	208000.0
2021-02-22	AGQ	ETF	52.65	55.96	52.45	55.9	2871800.0
2021-02-22	AGZ	ETF	118.84	118.84	118.68	118.79	35799.0
2021-02-22	AGZD	ETF	23.63	23.67	23.58	23.615	33000.0
2021-02-22	AIA	ETF	98.75	99.069	98.13	98.22	178319.0
2021-02-22	AIEQ	ETF	40.68	40.725	39.58	39.61	57000.0
2021-02-22	AIQ	ETF	29.93	30.068	29.6	29.6	198406.0
2021-02-22	AIRR	ETF	38.15	38.89	38.04	38.86	31700.0
2021-02-22	AIVI	ETF	42.24	42.58	42.24	42.31	7100.0
2021-02-22	ALTL	ETF	37.6	37.9246	37.45	37.45	13492.0
2021-02-22	ALTY	ETF	12.3	12.46	12.3	12.44	22900.0
2021-02-22	AMJ	ETF	15.64	16.11	15.64	15.9	726221.0
2021-02-22	AMLP	ETF	28.06	29.01	28.06	28.58	2893500.0
2021-02-22	AMNA	ETF	28.3793	28.3793	28.3793	28.3793	0.0
2021-02-22	AMND	ETF	30.0775	30.0775	30.0775	30.0775	6.0
2021-02-22	AMOM	ETF	34.42	34.445	33.51	33.51	7200.0
2021-02-22	AMPS	ETF	10.7	10.72	10.43	10.55	71160.0
2021-02-22	AMTR	ETF	32.6267	32.6267	32.6267	32.6267	3.0

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

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