PREVIEW / etf_daily / 2021-05-21

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-21.parquet
  size:    89 KB
  rows:    2,346

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-05-21	SPY	ETF	416.87	418.2	414.45	414.94	76578700.0
2021-05-21	QQQ	ETF	330.43	330.86	326.64	327.01	50330449.0
2021-05-21	IWM	ETF	221.33	222.37	219.35	219.97	24213700.0
2021-05-21	DIA	ETF	342.29	344.07	341.28	342.04	4481000.0
2021-05-21	GLD	ETF	176.58	176.86	175.15	176.04	7677200.0
2021-05-21	TLT	ETF	137.66	137.7	137.06	137.67	10171600.0
2021-05-21	AAA	ETF	25.015	25.015	25.015	25.015	100.0
2021-05-21	AAAU	ETF	18.77	18.79	18.62	18.7	342600.0
2021-05-21	AADR	ETF	64.9	64.9	64.36	64.36	2100.0
2021-05-21	AAXJ	ETF	92.32	92.32	91.14	91.27	365300.0
2021-05-21	ABEQ	ETF	28.19	28.19	28.19	28.19	200.0
2021-05-21	ACES	ETF	67.8	68.099	67.3	67.63	35000.0
2021-05-21	ACIO	ETF	29.67	29.71	29.58	29.595	14100.0
2021-05-21	ACSI	ETF	48.7604	48.7604	48.75	48.75	832.0
2021-05-21	ACTV	ETF	38.35	38.35	38.1128	38.1128	6721.0
2021-05-21	ACTX	ETF	4.46	4.46	4.46	4.46	203.0
2021-05-21	ACVF	ETF	31.2	31.2	31.009	31.009	4900.0
2021-05-21	ACWF	ETF	37.82	37.899	37.7189	37.72	3286.0
2021-05-21	ACWI	ETF	99.64	99.8	99.0	99.22	2376100.0
2021-05-21	ACWV	ETF	103.07	103.43	102.71	102.96	299800.0
2021-05-21	ACWX	ETF	57.69	57.69	57.23	57.4	1289541.0
2021-05-21	ADFI	ETF	9.66	9.68	9.66	9.665	4400.0
2021-05-21	ADIV	ETF	18.447	18.447	18.447	18.447	100.0
2021-05-21	ADME	ETF	38.63	38.706	38.415	38.429	11900.0
2021-05-21	ADRE	ETF	55.84	55.84	55.0	55.1424	25695.0
2021-05-21	AESR	ETF	13.21	13.23	13.11	13.128	11100.0
2021-05-21	AFIF	ETF	9.6957	9.7097	9.68	9.7005	17434.0
2021-05-21	AFK	ETF	22.2	22.2	21.811	22.06	6296.0
2021-05-21	AFLG	ETF	24.91	24.98	24.851	24.851	900.0
2021-05-21	AFMC	ETF	25.103	25.103	25.103	25.103	600.0
2021-05-21	AFSM	ETF	25.604	25.604	25.604	25.604	100.0
2021-05-21	AFTY	ETF	23.057	23.057	22.978	22.978	900.0
2021-05-21	AGG	ETF	114.36	114.4	114.23	114.34	3873200.0
2021-05-21	AGGY	ETF	51.66	51.66	51.58	51.65	49000.0
2021-05-21	AGNG	ETF	29.311	29.37	29.13	29.175	3300.0
2021-05-21	AGOX	ETF	24.94	25.284	24.94	25.129	11400.0
2021-05-21	AGQ	ETF	53.66	53.66	50.41	51.69	899800.0
2021-05-21	AGZ	ETF	118.24	118.24	118.0982	118.18	23334.0
2021-05-21	AGZD	ETF	23.515	23.515	23.485	23.51	22400.0
2021-05-21	AIA	ETF	89.54	89.54	88.425	88.5	62925.0
2021-05-21	AIEQ	ETF	36.76	36.86	36.44	36.55	8200.0
2021-05-21	AIQ	ETF	28.48	28.48	28.15	28.15	19170.0
2021-05-21	AIRR	ETF	41.18	41.475	41.04	41.22	19400.0
2021-05-21	AIVI	ETF	44.18	44.18	43.97	44.1	3500.0
2021-05-21	ALTL	ETF	41.48	41.67	41.38	41.38	51904.0
2021-05-21	ALTY	ETF	13.5	13.5	13.37	13.405	11400.0
2021-05-21	AMJ	ETF	19.37	19.37	19.0	19.11	462625.0
2021-05-21	AMLP	ETF	34.74	34.93	34.38	34.55	2576400.0
2021-05-21	AMNA	ETF	33.27	33.27	33.1871	33.1871	160.0
2021-05-21	AMND	ETF	35.2338	35.2338	35.2338	35.2338	0.0

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

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