PREVIEW / etf_daily / 2021-02-05

all etf daily files

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

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-05	SPY	ETF	388.2	388.47	386.14	387.71	48669800.0
2021-02-05	QQQ	ETF	331.22	332.4025	329.53	331.36	22731960.0
2021-02-05	IWM	ETF	220.94	221.84	218.77	221.65	23338800.0
2021-02-05	DIA	ETF	312.36	312.55	310.87	311.54	1955600.0
2021-02-05	GLD	ETF	168.99	170.18	168.67	169.81	6538500.0
2021-02-05	TLT	ETF	149.1	149.57	148.02	148.03	10258900.0
2021-02-05	AAA	ETF	25.1388	25.14	25.1388	25.14	1785.0
2021-02-05	AAAU	ETF	17.93	18.07	17.91	18.04	398300.0
2021-02-05	AADR	ETF	64.31	64.84	64.31	64.82	7100.0
2021-02-05	AAXJ	ETF	98.31	98.73	97.95	98.73	1203600.0
2021-02-05	ABEQ	ETF	26.21	26.21	25.84	25.95	6000.0
2021-02-05	ACES	ETF	98.02	98.29	96.405	97.62	138600.0
2021-02-05	ACIO	ETF	27.72	27.912	27.72	27.84	43200.0
2021-02-05	ACSI	ETF	44.785	45.0	44.785	45.0	854.0
2021-02-05	ACTV	ETF	34.565	34.63	34.52	34.5841	2674.0
2021-02-05	ACTX	ETF	4.3	4.3	4.3	4.3	220.0
2021-02-05	ACVF	ETF	28.85	28.85	28.5	28.656	1400.0
2021-02-05	ACWF	ETF	35.19	35.19	35.09	35.1008	20458.0
2021-02-05	ACWI	ETF	94.45	94.63	94.13	94.49	3502100.0
2021-02-05	ACWV	ETF	97.05	97.32	97.0	97.28	166600.0
2021-02-05	ACWX	ETF	55.24	55.38	55.03	55.34	476022.0
2021-02-05	ADFI	ETF	9.849	9.849	9.849	9.849	400.0
2021-02-05	ADME	ETF	36.4	36.97	36.4	36.5	54700.0
2021-02-05	ADRE	ETF	62.82	63.12	62.66	63.12	41824.0
2021-02-05	AESR	ETF	12.29	12.291	12.29	12.291	100.0
2021-02-05	AFIF	ETF	9.77	9.77	9.743	9.745	12025.0
2021-02-05	AFK	ETF	21.36	21.658	21.15	21.35	28190.0
2021-02-05	AFLG	ETF	23.218	23.22	23.185	23.22	500.0
2021-02-05	AFMC	ETF	22.961	23.044	22.961	23.044	500.0
2021-02-05	AFSM	ETF	24.977	24.977	24.977	24.977	100.0
2021-02-05	AFTY	ETF	25.25	25.329	25.25	25.286	5200.0
2021-02-05	AGG	ETF	116.91	116.96	116.7	116.71	3446600.0
2021-02-05	AGGY	ETF	53.14	53.17	53.04	53.04	239500.0
2021-02-05	AGNG	ETF	29.03	29.26	29.005	29.24	9100.0
2021-02-05	AGQ	ETF	49.72	51.2	49.37	50.58	1262300.0
2021-02-05	AGZ	ETF	119.31	119.31	119.16	119.16	41981.0
2021-02-05	AGZD	ETF	23.69	23.71	23.645	23.67	27000.0
2021-02-05	AIA	ETF	98.59	98.84	97.98	98.84	222689.0
2021-02-05	AIEQ	ETF	40.51	40.67	40.19	40.592	84100.0
2021-02-05	AIQ	ETF	29.4	29.53	29.27	29.5	69911.0
2021-02-05	AIRR	ETF	37.14	37.14	36.74	36.992	11700.0
2021-02-05	AIVI	ETF	41.54	41.57	41.44	41.57	8400.0
2021-02-05	ALTL	ETF	34.5885	34.69	34.4255	34.5	21219.0
2021-02-05	ALTY	ETF	12.12	12.18	12.12	12.18	12100.0
2021-02-05	AMJ	ETF	15.26	15.4	15.15	15.31	516360.0
2021-02-05	AMLP	ETF	28.27	28.47	27.96	28.15	1847000.0
2021-02-05	AMNA	ETF	27.1467	27.1467	27.1467	27.1467	14.0
2021-02-05	AMND	ETF	28.7967	28.7967	28.7967	28.7967	0.0
2021-02-05	AMOM	ETF	33.62	33.785	33.55	33.785	1800.0
2021-02-05	AMPS	ETF	10.49	10.49	10.21	10.46	34601.0

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

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