PREVIEW / etf_daily / 2021-02-26

all etf daily files

  file:    by_date/etf_daily/2021/2021-02-26.parquet
  size:    86 KB
  rows:    2,268

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-26	SPY	ETF	384.35	385.58	378.23	380.36	152701600.0
2021-02-26	QQQ	ETF	315.85	319.11	310.88	314.14	104739841.0
2021-02-26	IWM	ETF	219.52	222.23	214.81	218.31	47734200.0
2021-02-26	DIA	ETF	314.42	314.44	308.78	309.45	7925600.0
2021-02-26	GLD	ETF	165.0	165.1	160.95	161.81	23730400.0
2021-02-26	TLT	ETF	140.77	143.3	139.68	143.12	45423300.0
2021-02-26	AAA	ETF	25.07	25.073	25.06	25.07	1043.0
2021-02-26	AAAU	ETF	17.53	17.53	17.1	17.19	1249100.0
2021-02-26	AADR	ETF	62.05	63.2	62.05	62.71	16300.0
2021-02-26	AAXJ	ETF	95.1	95.27	93.88	94.65	1621500.0
2021-02-26	ABEQ	ETF	25.48	25.5	25.35	25.359	10500.0
2021-02-26	ACES	ETF	80.38	82.19	78.63	81.14	122100.0
2021-02-26	ACIO	ETF	27.524	27.65	27.39	27.43	24200.0
2021-02-26	ACSI	ETF	44.73	45.08	44.6	44.6	710.0
2021-02-26	ACTV	ETF	34.4679	34.94	34.34	34.6118	2833.0
2021-02-26	ACTX	ETF	5.25	5.25	5.25	5.25	122.0
2021-02-26	ACVF	ETF	28.385	28.685	28.385	28.46	1400.0
2021-02-26	ACWF	ETF	35.1	35.22	34.87	35.0546	7243.0
2021-02-26	ACWI	ETF	93.42	93.5	92.1	92.51	6675200.0
2021-02-26	ACWV	ETF	95.22	95.22	94.05	94.12	224800.0
2021-02-26	ACWX	ETF	54.92	54.92	54.19	54.24	2072403.0
2021-02-26	ADFI	ETF	9.69	9.707	9.66	9.707	7200.0
2021-02-26	ADME	ETF	35.95	35.955	35.58	35.793	25300.0
2021-02-26	ADRE	ETF	60.44	60.485	58.89	59.79	114121.0
2021-02-26	AESR	ETF	12.149	12.149	12.113	12.113	5300.0
2021-02-26	AFIF	ETF	9.73	9.78	9.7286	9.7743	23494.0
2021-02-26	AFK	ETF	21.16	21.16	20.96	20.99	14316.0
2021-02-26	AFLG	ETF	22.865	22.865	22.865	22.865	100.0
2021-02-26	AFMC	ETF	23.25	23.25	23.25	23.25	100.0
2021-02-26	AFSM	ETF	24.8	24.8	24.35	24.669	500.0
2021-02-26	AFTY	ETF	24.13	24.19	23.98	24.08	6800.0
2021-02-26	AGG	ETF	114.96	115.39	114.59	115.34	11333400.0
2021-02-26	AGGY	ETF	51.74	52.02	51.66	52.02	235900.0
2021-02-26	AGNG	ETF	28.01	28.01	27.61	27.81	3900.0
2021-02-26	AGQ	ETF	50.29	50.35	47.3	48.84	2165700.0
2021-02-26	AGZ	ETF	118.39	118.51	118.11	118.51	138716.0
2021-02-26	AGZD	ETF	23.6	23.695	23.565	23.645	6200.0
2021-02-26	AIA	ETF	94.89	95.07	93.9	94.73	237716.0
2021-02-26	AIEQ	ETF	38.7	38.88	37.65	38.43	26400.0
2021-02-26	AIQ	ETF	28.73	28.9414	28.26	28.58	197839.0
2021-02-26	AIRR	ETF	38.95	39.009	38.37	38.39	42900.0
2021-02-26	AIVI	ETF	42.07	42.07	41.64	41.64	8100.0
2021-02-26	ALTL	ETF	37.76	37.76	36.925	37.6296	2895.0
2021-02-26	ALTY	ETF	12.357	12.41	12.26	12.26	20500.0
2021-02-26	AMJ	ETF	15.91	15.91	15.2795	15.43	1541882.0
2021-02-26	AMLP	ETF	29.11	29.28	28.08	28.45	3777900.0
2021-02-26	AMNA	ETF	27.8071	27.8071	27.8071	27.8071	4.0
2021-02-26	AMND	ETF	29.493	29.493	29.493	29.493	0.0
2021-02-26	AMOM	ETF	32.51	32.542	31.888	32.392	2400.0
2021-02-26	AMPS	ETF	10.45	10.462	10.05	10.05	139765.0

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

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