PREVIEW / etf_daily / 2021-06-07

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-07.parquet
  size:    88 KB
  rows:    2,352

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-06-07	SPY	ETF	422.59	422.78	421.19	422.19	51555000.0
2021-06-07	QQQ	ETF	335.05	336.66	334.34	336.6	32611852.0
2021-06-07	IWM	ETF	227.89	230.78	227.25	230.45	24049900.0
2021-06-07	DIA	ETF	348.5	348.54	346.02	346.59	2224300.0
2021-06-07	GLD	ETF	176.96	177.9	176.63	177.87	7709100.0
2021-06-07	TLT	ETF	139.59	139.71	139.32	139.47	7799800.0
2021-06-07	AAA	ETF	24.995	24.995	24.995	24.995	12.0
2021-06-07	AAAU	ETF	18.8	18.91	18.77	18.91	387100.0
2021-06-07	AADR	ETF	67.52	67.87	67.52	67.87	1200.0
2021-06-07	AAXJ	ETF	95.08	95.24	94.58	95.02	720200.0
2021-06-07	ABEQ	ETF	28.245	28.26	28.222	28.25	400.0
2021-06-07	ACES	ETF	69.14	70.175	68.555	70.12	30100.0
2021-06-07	ACIO	ETF	29.85	29.85	29.73	29.76	9900.0
2021-06-07	ACSI	ETF	49.0375	49.0375	49.0375	49.0375	308.0
2021-06-07	ACTV	ETF	39.415	39.415	39.26	39.2761	6085.0
2021-06-07	ACTX	ETF	3.41	3.41	3.4	3.4	1059.0
2021-06-07	ACVF	ETF	31.48	31.57	31.48	31.57	3800.0
2021-06-07	ACWF	ETF	38.605	38.739	38.5585	38.726	21382.0
2021-06-07	ACWI	ETF	101.53	101.55	101.27	101.52	2279500.0
2021-06-07	ACWV	ETF	103.83	104.03	103.81	104.02	121600.0
2021-06-07	ACWX	ETF	59.14	59.1899	58.99	59.14	804620.0
2021-06-07	ADFI	ETF	9.7	9.706	9.7	9.706	2000.0
2021-06-07	ADIV	ETF	19.03	19.03	19.03	19.03	100.0
2021-06-07	ADME	ETF	39.0	39.0	38.82	38.88	5600.0
2021-06-07	ADRE	ETF	57.31	57.4099	57.05	57.1901	14634.0
2021-06-07	AESR	ETF	13.35	13.361	13.31	13.35	17000.0
2021-06-07	AFIF	ETF	9.7201	9.74	9.72	9.732	22021.0
2021-06-07	AFK	ETF	22.98	22.98	22.8093	22.87	10232.0
2021-06-07	AFLG	ETF	25.19	25.224	25.17	25.224	400.0
2021-06-07	AFMC	ETF	25.589	25.617	25.589	25.617	400.0
2021-06-07	AFSM	ETF	26.501	26.501	26.501	26.501	100.0
2021-06-07	AFTY	ETF	24.22	24.22	24.07	24.189	4200.0
2021-06-07	AGG	ETF	113.97	114.64	113.97	114.6	3728400.0
2021-06-07	AGGY	ETF	51.81	51.87	51.81	51.84	73900.0
2021-06-07	AGNG	ETF	29.28	29.93	29.27	29.79	7400.0
2021-06-07	AGOX	ETF	26.5	26.5	25.97	26.035	13800.0
2021-06-07	AGQ	ETF	52.72	53.35	52.43	53.24	705900.0
2021-06-07	AGZ	ETF	118.27	118.37	118.27	118.37	46034.0
2021-06-07	AGZD	ETF	23.495	23.515	23.49	23.49	34800.0
2021-06-07	AIA	ETF	92.21	92.23	91.5889	92.0	44151.0
2021-06-07	AIEQ	ETF	38.4	39.045	38.34	38.959	14400.0
2021-06-07	AIQ	ETF	29.23	29.43	29.19	29.43	18520.0
2021-06-07	AIRR	ETF	42.16	42.16	41.92	42.15	27400.0
2021-06-07	AIVI	ETF	45.05	45.1	45.02	45.07	2700.0
2021-06-07	ALTL	ETF	41.64	41.67	41.345	41.4	7504.0
2021-06-07	ALTY	ETF	13.6	13.7	13.59	13.68	40400.0
2021-06-07	AMJ	ETF	19.64	20.01	19.64	19.91	255568.0
2021-06-07	AMLP	ETF	36.12	36.92	36.12	36.7	1955800.0
2021-06-07	AMNA	ETF	34.8976	34.8976	34.8976	34.8976	1.0
2021-06-07	AMND	ETF	36.6982	36.6982	36.6982	36.6982	7.0

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

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