PREVIEW / etf_daily / 2021-03-18

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-18.parquet
  size:    87 KB
  rows:    2,283

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-18	SPY	ETF	394.48	396.72	390.75	391.48	115349100.0
2021-03-18	QQQ	ETF	316.87	317.8801	311.57	312.04	82942269.0
2021-03-18	IWM	ETF	230.8	232.93	224.61	225.24	35637200.0
2021-03-18	DIA	ETF	330.3	332.86	328.77	329.36	5376500.0
2021-03-18	GLD	ETF	161.15	162.82	161.11	162.56	8711100.0
2021-03-18	TLT	ETF	133.31	134.47	133.19	133.92	21615100.0
2021-03-18	AAA	ETF	25.08	25.09	25.08	25.09	435.0
2021-03-18	AAAU	ETF	17.1	17.29	17.1	17.28	385300.0
2021-03-18	AADR	ETF	64.26	64.45	63.36	63.36	9400.0
2021-03-18	AAXJ	ETF	94.32	94.39	93.31	93.45	599000.0
2021-03-18	ABEQ	ETF	26.56	26.59	26.42	26.43	11600.0
2021-03-18	ACES	ETF	76.01	76.415	73.03	73.35	84600.0
2021-03-18	ACIO	ETF	27.84	27.9	27.73	27.73	11600.0
2021-03-18	ACSI	ETF	46.35	46.35	45.818	45.818	5735.0
2021-03-18	ACTV	ETF	36.27	36.63	35.8968	35.8968	6712.0
2021-03-18	ACTX	ETF	3.5	4.0	3.28	3.28	1234.0
2021-03-18	ACVF	ETF	29.47	29.554	29.227	29.227	700.0
2021-03-18	ACWF	ETF	36.1	36.33	35.87	35.87	13607.0
2021-03-18	ACWI	ETF	95.31	95.84	94.52	94.66	1612700.0
2021-03-18	ACWV	ETF	97.43	97.79	97.23	97.23	146200.0
2021-03-18	ACWX	ETF	55.87	56.14	55.47	55.47	1738802.0
2021-03-18	ADFI	ETF	9.55	9.576	9.55	9.576	400.0
2021-03-18	ADME	ETF	35.965	36.1	35.75	35.77	9000.0
2021-03-18	ADRE	ETF	58.52	58.5566	57.63	57.6685	21088.0
2021-03-18	AESR	ETF	12.58	12.63	12.41	12.439	9900.0
2021-03-18	AFIF	ETF	9.68	9.69	9.67	9.6781	111653.0
2021-03-18	AFK	ETF	21.57	21.57	21.33	21.4	6518.0
2021-03-18	AFLG	ETF	23.783	23.783	23.514	23.514	400.0
2021-03-18	AFMC	ETF	24.241	24.241	24.241	24.241	100.0
2021-03-18	AFSM	ETF	25.46	25.46	25.46	25.46	100.0
2021-03-18	AFTY	ETF	22.97	22.97	22.803	22.803	1200.0
2021-03-18	AGG	ETF	113.32	113.55	113.2	113.42	6222200.0
2021-03-18	AGGY	ETF	51.05	51.15	51.04	51.09	332100.0
2021-03-18	AGNG	ETF	27.51	27.51	27.35	27.37	18400.0
2021-03-18	AGQ	ETF	46.23	48.07	46.14	46.69	657500.0
2021-03-18	AGZ	ETF	117.56	117.77	117.56	117.77	38835.0
2021-03-18	AGZD	ETF	23.64	23.68	23.55	23.61	680600.0
2021-03-18	AIA	ETF	94.04	94.13	93.0	93.01	109213.0
2021-03-18	AIEQ	ETF	39.33	39.75	38.384	38.54	62700.0
2021-03-18	AIQ	ETF	28.83	28.88	28.35	28.3572	31852.0
2021-03-18	AIRR	ETF	41.62	41.97	40.74	40.814	35300.0
2021-03-18	AIVI	ETF	42.96	43.19	42.72	42.72	12700.0
2021-03-18	ALTL	ETF	40.48	40.7	39.52	39.52	13339.0
2021-03-18	ALTY	ETF	12.8	12.8	12.55	12.55	19200.0
2021-03-18	AMJ	ETF	17.2	17.2	16.47	16.55	905903.0
2021-03-18	AMLP	ETF	31.64	31.7	30.31	30.44	2320700.0
2021-03-18	AMNA	ETF	29.4199	29.4199	29.4199	29.4199	0.0
2021-03-18	AMND	ETF	31.3252	31.3252	31.3252	31.3252	14.0
2021-03-18	AMOM	ETF	32.69	32.69	32.312	32.312	2000.0
2021-03-18	AMPS	ETF	10.01	10.01	9.9	9.9	166130.0

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

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