PREVIEW / etf_daily / 2021-02-10

all etf daily files

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

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-10	SPY	ETF	392.12	392.28	387.5	390.08	59154400.0
2021-02-10	QQQ	ETF	334.99	335.46	329.5	332.75	28068700.0
2021-02-10	IWM	ETF	229.92	230.32	224.95	226.88	27955400.0
2021-02-10	DIA	ETF	315.17	315.24	312.3	314.5	3048000.0
2021-02-10	GLD	ETF	173.15	173.22	172.01	172.71	6112800.0
2021-02-10	TLT	ETF	149.28	149.78	149.14	149.78	8079800.0
2021-02-10	AAA	ETF	25.1225	25.135	25.1225	25.135	711.0
2021-02-10	AAAU	ETF	18.38	18.39	18.27	18.34	792400.0
2021-02-10	AADR	ETF	66.52	66.52	66.03	66.03	1100.0
2021-02-10	AAXJ	ETF	101.06	101.21	99.78	100.37	1380500.0
2021-02-10	ABEQ	ETF	26.45	26.45	25.906	26.035	900.0
2021-02-10	ACES	ETF	101.72	101.72	97.45	98.43	156300.0
2021-02-10	ACIO	ETF	28.03	28.03	27.9	27.9	54700.0
2021-02-10	ACSI	ETF	45.47	45.47	45.2332	45.2332	407.0
2021-02-10	ACTV	ETF	35.22	35.5	35.22	35.4088	2932.0
2021-02-10	ACTX	ETF	5.7	15.0	5.7	7.0	7630.0
2021-02-10	ACVF	ETF	28.995	29.01	28.885	28.897	3400.0
2021-02-10	ACWF	ETF	35.75	35.78	35.53	35.5798	22241.0
2021-02-10	ACWI	ETF	95.98	95.98	94.84	95.41	1697500.0
2021-02-10	ACWV	ETF	98.11	98.37	97.63	97.82	527800.0
2021-02-10	ACWX	ETF	56.32	56.41	55.76	56.03	493219.0
2021-02-10	ADFI	ETF	9.881	9.881	9.881	9.881	100.0
2021-02-10	ADME	ETF	37.29	37.29	36.64	36.74	72200.0
2021-02-10	ADRE	ETF	65.14	65.56	64.5524	64.8	31572.0
2021-02-10	AESR	ETF	12.353	12.353	12.353	12.353	1200.0
2021-02-10	AFIF	ETF	9.789	9.79	9.75	9.77	18731.0
2021-02-10	AFK	ETF	21.73	21.77	21.171	21.59	24329.0
2021-02-10	AFLG	ETF	23.535	23.535	23.442	23.459	1500.0
2021-02-10	AFMC	ETF	23.5	23.5	23.5	23.5	100.0
2021-02-10	AFSM	ETF	25.71	25.889	25.666	25.71	3300.0
2021-02-10	AFTY	ETF	26.8	26.8	26.475	26.68	5000.0
2021-02-10	AGG	ETF	116.97	117.01	116.92	116.99	4378300.0
2021-02-10	AGGY	ETF	53.06	53.15	53.06	53.11	166400.0
2021-02-10	AGNG	ETF	29.46	29.49	29.226	29.226	5000.0
2021-02-10	AGQ	ETF	52.47	52.58	50.37	51.07	1012800.0
2021-02-10	AGZ	ETF	119.21	119.3256	119.21	119.29	17454.0
2021-02-10	AGZD	ETF	23.71	23.72	23.665	23.68	5400.0
2021-02-10	AIA	ETF	100.78	100.959	99.7112	100.16	201536.0
2021-02-10	AIEQ	ETF	42.25	42.35	41.0	41.65	89900.0
2021-02-10	AIQ	ETF	30.22	30.3293	29.802	30.16	42641.0
2021-02-10	AIRR	ETF	38.01	38.01	37.591	37.602	9600.0
2021-02-10	AIVI	ETF	41.92	41.93	41.75	41.84	3800.0
2021-02-10	ALTL	ETF	35.415	35.47	35.115	35.3442	5446.0
2021-02-10	ALTY	ETF	12.29	12.35	12.27	12.32	15300.0
2021-02-10	AMJ	ETF	15.2	15.45	15.185	15.3	787626.0
2021-02-10	AMLP	ETF	28.43	28.54	28.03	28.46	3843200.0
2021-02-10	AMNA	ETF	27.6871	27.6871	27.6871	27.6871	2.0
2021-02-10	AMND	ETF	29.368	29.368	29.368	29.368	0.0
2021-02-10	AMOM	ETF	34.56	34.56	34.02	34.238	6700.0
2021-02-10	AMPS	ETF	10.85	10.85	10.6	10.7	26759.0

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

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