PREVIEW / etf_daily / 2021-02-18

all etf daily files

  file:    by_date/etf_daily/2021/2021-02-18.parquet
  size:    85 KB
  rows:    2,260

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-18	SPY	ETF	389.59	391.52	387.74	390.72	59712800.0
2021-02-18	QQQ	ETF	330.23	333.8661	328.36	332.47	32236240.0
2021-02-18	IWM	ETF	222.34	222.9	219.39	220.59	24501500.0
2021-02-18	DIA	ETF	314.75	316.0	313.38	315.56	2609600.0
2021-02-18	GLD	ETF	166.98	167.3	165.73	166.32	7498200.0
2021-02-18	TLT	ETF	144.61	145.6	144.32	145.2	10755300.0
2021-02-18	AAA	ETF	25.14	25.14	25.13	25.13	243.0
2021-02-18	AAAU	ETF	17.73	17.77	17.6	17.66	796300.0
2021-02-18	AADR	ETF	65.43	65.43	65.0	65.41	2000.0
2021-02-18	AAXJ	ETF	100.38	100.53	99.39	100.42	1414200.0
2021-02-18	ABEQ	ETF	25.49	25.55	25.47	25.534	62200.0
2021-02-18	ACES	ETF	90.05	90.81	87.81	88.53	154200.0
2021-02-18	ACIO	ETF	27.97	28.11	27.96	28.07	22700.0
2021-02-18	ACSI	ETF	45.06	45.2607	45.06	45.2607	13279.0
2021-02-18	ACTV	ETF	34.765	34.765	34.54	34.6565	3351.0
2021-02-18	ACTX	ETF	5.0	5.0	4.99	4.99	1676.0
2021-02-18	ACVF	ETF	28.881	29.042	28.881	29.042	1200.0
2021-02-18	ACWF	ETF	35.81	35.8449	35.69	35.8449	9638.0
2021-02-18	ACWI	ETF	95.38	95.82	94.92	95.66	2689800.0
2021-02-18	ACWV	ETF	96.94	97.31	96.69	97.19	342800.0
2021-02-18	ACWX	ETF	56.22	56.37	55.87	56.36	2889114.0
2021-02-18	ADFI	ETF	9.82	9.85	9.8	9.825	47200.0
2021-02-18	ADME	ETF	36.77	36.77	36.545	36.71	13200.0
2021-02-18	ADRE	ETF	64.6	64.7583	63.87	64.64	18495.0
2021-02-18	AESR	ETF	12.32	12.397	12.32	12.397	6400.0
2021-02-18	AFIF	ETF	9.7193	9.7481	9.71	9.73	56584.0
2021-02-18	AFK	ETF	22.0	22.0368	21.66	21.85	16888.0
2021-02-18	AFLG	ETF	23.49	23.49	23.46	23.49	500.0
2021-02-18	AFMC	ETF	23.26	23.277	23.26	23.277	100.0
2021-02-18	AFSM	ETF	25.2	25.2	25.177	25.177	500.0
2021-02-18	AFTY	ETF	26.31	26.36	26.14	26.36	15800.0
2021-02-18	AGG	ETF	116.14	116.28	116.03	116.2	5333500.0
2021-02-18	AGGY	ETF	52.66	52.68	52.53	52.66	81700.0
2021-02-18	AGNG	ETF	28.6	28.88	28.6	28.88	2400.0
2021-02-18	AGQ	ETF	51.54	52.2	50.41	50.91	783500.0
2021-02-18	AGZ	ETF	118.87	118.97	118.86	118.9261	35414.0
2021-02-18	AGZD	ETF	23.73	23.735	23.63	23.685	10600.0
2021-02-18	AIA	ETF	100.12	100.4292	99.348	100.38	1125248.0
2021-02-18	AIEQ	ETF	40.75	40.77	40.0	40.25	70000.0
2021-02-18	AIQ	ETF	30.1	30.1912	29.8138	30.19	46903.0
2021-02-18	AIRR	ETF	37.8	37.8	37.4	37.47	7700.0
2021-02-18	AIVI	ETF	42.12	42.19	41.91	42.16	4300.0
2021-02-18	ALTL	ETF	35.825	35.86	35.555	35.69	4170.0
2021-02-18	ALTY	ETF	12.41	12.41	12.31	12.333	17000.0
2021-02-18	AMJ	ETF	15.74	15.77	15.35	15.43	556590.0
2021-02-18	AMLP	ETF	28.46	28.46	27.64	27.73	2528300.0
2021-02-18	AMNA	ETF	27.76	27.7617	27.76	27.7617	210.0
2021-02-18	AMND	ETF	29.4518	29.4518	29.4518	29.4518	0.0
2021-02-18	AMOM	ETF	34.535	34.535	34.07	34.335	1600.0
2021-02-18	AMPS	ETF	10.64	10.79	10.57	10.67	22162.0

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

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