PREVIEW / etf_daily / 2021-05-17

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-17.parquet
  size:    88 KB
  rows:    2,341

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-17	SPY	ETF	415.39	416.39	413.36	415.52	65129200.0
2021-05-17	QQQ	ETF	324.63	326.3721	321.45	324.41	39394997.0
2021-05-17	IWM	ETF	219.78	221.39	217.9	221.32	20048500.0
2021-05-17	DIA	ETF	343.33	345.13	342.04	343.65	3262200.0
2021-05-17	GLD	ETF	173.3	175.0	173.28	174.7	11956800.0
2021-05-17	TLT	ETF	136.83	137.17	136.57	136.79	6113800.0
2021-05-17	AAA	ETF	25.005	25.005	25.005	25.005	84.0
2021-05-17	AAAU	ETF	18.42	18.59	18.42	18.57	304100.0
2021-05-17	AADR	ETF	64.83	64.92	64.61	64.91	13800.0
2021-05-17	AAXJ	ETF	90.14	90.63	89.96	90.61	1030200.0
2021-05-17	ABEQ	ETF	28.29	28.44	28.29	28.44	10500.0
2021-05-17	ACES	ETF	63.53	63.78	62.49	63.63	44900.0
2021-05-17	ACIO	ETF	29.47	29.529	29.39	29.506	15900.0
2021-05-17	ACSI	ETF	49.2744	49.2744	49.2744	49.2744	295.0
2021-05-17	ACTV	ETF	37.99	38.62	37.99	38.35	8102.0
2021-05-17	ACVF	ETF	31.07	31.07	30.63	30.99	6200.0
2021-05-17	ACWF	ETF	37.51	37.62	37.5	37.62	4164.0
2021-05-17	ACWI	ETF	98.67	98.93	98.42	98.93	1907800.0
2021-05-17	ACWV	ETF	102.12	102.48	102.12	102.32	74900.0
2021-05-17	ACWX	ETF	56.74	57.0015	56.65	56.97	1426106.0
2021-05-17	ADFI	ETF	9.68	9.68	9.63	9.655	4700.0
2021-05-17	ADME	ETF	38.31	38.4	38.25	38.38	17600.0
2021-05-17	ADRE	ETF	54.02	54.24	53.64	54.24	6410.0
2021-05-17	AESR	ETF	13.17	13.17	13.09	13.145	9000.0
2021-05-17	AFIF	ETF	9.705	9.71	9.68	9.695	32920.0
2021-05-17	AFK	ETF	21.78	22.18	21.78	22.07	7312.0
2021-05-17	AFLG	ETF	24.993	24.993	24.993	24.993	100.0
2021-05-17	AFMC	ETF	25.437	25.437	25.437	25.437	100.0
2021-05-17	AFTY	ETF	23.37	23.37	23.18	23.348	10700.0
2021-05-17	AGG	ETF	114.21	114.25	114.15	114.2	4926600.0
2021-05-17	AGGY	ETF	51.54	51.6	51.54	51.57	82700.0
2021-05-17	AGNG	ETF	29.11	29.11	28.541	28.598	3900.0
2021-05-17	AGOX	ETF	25.05	25.5	24.01	25.09	16500.0
2021-05-17	AGQ	ETF	51.85	54.83	51.58	54.56	2022800.0
2021-05-17	AGZ	ETF	118.03	118.04	117.9365	118.04	23960.0
2021-05-17	AGZD	ETF	23.52	23.535	23.515	23.52	15000.0
2021-05-17	AIA	ETF	87.34	87.8551	87.255	87.76	153433.0
2021-05-17	AIEQ	ETF	36.29	36.5	36.01	36.5	12100.0
2021-05-17	AIQ	ETF	27.8	27.86	27.65	27.815	13636.0
2021-05-17	AIRR	ETF	41.69	41.83	41.23	41.82	75400.0
2021-05-17	AIVI	ETF	44.12	44.24	44.12	44.22	1800.0
2021-05-17	ALTL	ETF	41.64	41.64	41.33	41.33	33254.0
2021-05-17	ALTY	ETF	13.25	13.374	13.25	13.35	8900.0
2021-05-17	AMJ	ETF	19.05	19.38	18.89	19.34	639582.0
2021-05-17	AMLP	ETF	34.65	35.2	34.27	35.2	2204500.0
2021-05-17	AMNA	ETF	33.5024	33.5024	33.5024	33.5024	6.0
2021-05-17	AMND	ETF	35.6159	35.6159	35.6159	35.6159	20.0
2021-05-17	AMOM	ETF	34.45	34.45	33.68	34.01	75300.0
2021-05-17	AMPS	ETF	9.7	9.78	9.7	9.77	954848.0
2021-05-17	AMTR	ETF	39.1993	39.1993	39.1993	39.1993	0.0

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

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