PREVIEW / etf_daily / 2021-03-17

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-17.parquet
  size:    86 KB
  rows:    2,263

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-17	SPY	ETF	394.53	398.12	393.3	397.26	97959300.0
2021-03-17	QQQ	ETF	317.45	323.85	315.68	321.9	78258729.0
2021-03-17	IWM	ETF	228.97	232.82	227.36	232.31	29422600.0
2021-03-17	DIA	ETF	329.21	331.03	328.38	330.77	4338200.0
2021-03-17	GLD	ETF	162.27	164.15	161.48	163.51	12626700.0
2021-03-17	TLT	ETF	135.15	135.53	134.15	135.29	27107500.0
2021-03-17	AAA	ETF	25.09	25.09	25.09	25.09	215.0
2021-03-17	AAAU	ETF	17.25	17.43	17.16	17.36	510000.0
2021-03-17	AADR	ETF	63.64	64.89	63.64	64.64	1800.0
2021-03-17	AAXJ	ETF	93.78	95.19	93.49	94.88	534600.0
2021-03-17	ABEQ	ETF	26.37	26.56	26.36	26.56	26300.0
2021-03-17	ACES	ETF	76.41	78.33	75.3	77.55	140500.0
2021-03-17	ACIO	ETF	28.02	28.03	27.84	27.99	19000.0
2021-03-17	ACSI	ETF	46.4615	46.4615	46.4615	46.4615	205.0
2021-03-17	ACTV	ETF	36.56	36.83	36.3094	36.83	4687.0
2021-03-17	ACTX	ETF	4.0	4.0	4.0	4.0	516.0
2021-03-17	ACVF	ETF	29.39	29.576	29.39	29.576	200.0
2021-03-17	ACWF	ETF	35.79	36.3613	35.67	36.35	11383.0
2021-03-17	ACWI	ETF	95.2	96.23	94.92	95.95	1891400.0
2021-03-17	ACWV	ETF	97.88	98.15	97.45	97.9	163800.0
2021-03-17	ACWX	ETF	55.53	56.295	55.5	56.15	2021561.0
2021-03-17	ADFI	ETF	9.87	9.87	9.62	9.62	1300.0
2021-03-17	ADME	ETF	36.1	36.34	36.027	36.28	16600.0
2021-03-17	ADRE	ETF	58.18	59.253	57.57	58.9592	12531.0
2021-03-17	AESR	ETF	12.51	12.601	12.48	12.601	25000.0
2021-03-17	AFIF	ETF	9.69	9.72	9.65	9.7	42909.0
2021-03-17	AFK	ETF	21.61	21.715	21.2501	21.7137	12113.0
2021-03-17	AFMC	ETF	24.647	24.647	24.647	24.647	1400.0
2021-03-17	AFTY	ETF	22.93	23.19	22.82	23.12	9800.0
2021-03-17	AGG	ETF	113.55	113.98	113.48	113.86	6229800.0
2021-03-17	AGGY	ETF	51.2	51.39	51.15	51.32	123200.0
2021-03-17	AGNG	ETF	27.58	27.73	27.53	27.73	1100.0
2021-03-17	AGQ	ETF	46.73	48.76	46.4	48.03	769500.0
2021-03-17	AGZ	ETF	117.85	117.9965	117.745	117.97	25998.0
2021-03-17	AGZD	ETF	23.64	23.665	23.62	23.65	43400.0
2021-03-17	AIA	ETF	93.4	94.53	93.02	94.43	155198.0
2021-03-17	AIEQ	ETF	39.27	40.05	38.53	40.04	18200.0
2021-03-17	AIQ	ETF	28.7	29.1731	28.46	29.0607	49747.0
2021-03-17	AIRR	ETF	41.48	41.91	41.26	41.64	30700.0
2021-03-17	AIVI	ETF	42.72	43.24	42.72	43.21	10700.0
2021-03-17	ALTL	ETF	39.51	40.4	39.51	40.35	12217.0
2021-03-17	ALTY	ETF	12.77	12.778	12.694	12.778	12700.0
2021-03-17	AMJ	ETF	17.27	17.31	16.98	17.24	742905.0
2021-03-17	AMLP	ETF	31.61	31.95	31.31	31.81	1949300.0
2021-03-17	AMNA	ETF	30.27	30.3966	30.15	30.3966	500.0
2021-03-17	AMND	ETF	32.3905	32.3905	32.3905	32.3905	0.0
2021-03-17	AMOM	ETF	32.716	32.94	32.69	32.881	1900.0
2021-03-17	AMPS	ETF	9.97	9.99	9.905	9.95	7853.0
2021-03-17	AMTR	ETF	34.75	34.9804	34.75	34.9804	300.0
2021-03-17	AMUB	ETF	10.81	10.8408	10.76	10.8408	6512.0

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

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