PREVIEW / etf_daily / 2020-02-03

all etf daily files

  file:    by_date/etf_daily/2020/2020-02-03.parquet
  size:    74 KB
  rows:    1,950

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
2020-02-03	SPY	ETF	323.35	326.16	323.22	324.12	69083000.0
2020-02-03	QQQ	ETF	220.14	222.885	219.99	222.38	25468307.0
2020-02-03	IWM	ETF	161.6	162.93	161.49	162.32	17373200.0
2020-02-03	DIA	ETF	283.69	286.26	283.5	283.98	3157400.0
2020-02-03	GLD	ETF	148.66	148.78	147.68	148.36	9105300.0
2020-02-03	TLT	ETF	144.95	145.76	144.12	145.54	15309000.0
2020-02-03	AAAU	ETF	15.74	15.76	15.68	15.73	57100.0
2020-02-03	AADR	ETF	53.96	54.64	53.96	54.5	13600.0
2020-02-03	AAXJ	ETF	69.21	69.87	69.17	69.67	948900.0
2020-02-03	ABEQ	ETF	24.626	24.65	24.58	24.593	24400.0
2020-02-03	ACES	ETF	36.67	37.435	36.67	37.42	25000.0
2020-02-03	ACIO	ETF	25.18	25.18	25.059	25.059	2600.0
2020-02-03	ACSI	ETF	36.01	36.17	35.8815	35.8815	1138.0
2020-02-03	ACTX	ETF	7.3751	10.0301	7.3751	7.4341	127.0
2020-02-03	ACWF	ETF	30.66	30.84	30.6294	30.67	10999.0
2020-02-03	ACWI	ETF	78.46	79.04	78.44	78.64	3539600.0
2020-02-03	ACWV	ETF	97.4	97.77	97.37	97.44	529400.0
2020-02-03	ACWX	ETF	47.52	47.8051	47.52	47.57	1691450.0
2020-02-03	ADME	ETF	30.65	30.737	30.65	30.65	4000.0
2020-02-03	ADRE	ETF	41.88	42.445	41.88	42.385	14283.0
2020-02-03	AESR	ETF	10.19	10.19	10.143	10.15	1600.0
2020-02-03	AFIF	ETF	9.75	9.75	9.74	9.7445	7215.0
2020-02-03	AFK	ETF	19.22	19.2881	19.15	19.1746	12071.0
2020-02-03	AFLG	ETF	20.465	20.465	20.465	20.465	100.0
2020-02-03	AFTY	ETF	15.24	15.46	15.24	15.32	8700.0
2020-02-03	AGG	ETF	114.2	114.41	114.08	114.37	7214200.0
2020-02-03	AGGY	ETF	53.21	53.26	53.11	53.26	93300.0
2020-02-03	AGNG	ETF	23.45	23.665	23.45	23.583	2700.0
2020-02-03	AGQ	ETF	31.08	31.11	30.39	30.62	377100.0
2020-02-03	AGZ	ETF	117.18	117.26	117.1	117.2212	14165.0
2020-02-03	AGZD	ETF	23.99	24.01	23.915	23.985	133000.0
2020-02-03	AIA	ETF	63.14	63.515	63.09	63.09	240041.0
2020-02-03	AIEQ	ETF	28.76	29.057	28.76	28.88	29000.0
2020-02-03	AIQ	ETF	18.61	18.835	18.61	18.8	24483.0
2020-02-03	AIRR	ETF	28.07	28.386	28.07	28.26	8700.0
2020-02-03	AIVI	ETF	41.23	41.33	41.15	41.17	7200.0
2020-02-03	ALTY	ETF	14.8	14.91	14.8	14.845	7900.0
2020-02-03	AMJ	ETF	20.65	20.71	20.425	20.48	3880224.0
2020-02-03	AMLP	ETF	40.05	40.35	39.75	39.8	3818620.0
2020-02-03	AMOM	ETF	26.61	26.636	26.61	26.636	200.0
2020-02-03	AMUB	ETF	12.97	12.97	12.875	12.875	9983.0
2020-02-03	AMZA	ETF	40.2	40.4	39.6	39.7	82100.0
2020-02-03	ANGL	ETF	29.87	29.89	29.74	29.74	377000.0
2020-02-03	AOA	ETF	57.43	57.85	57.43	57.63	73400.0
2020-02-03	AOK	ETF	36.53	36.58	36.5005	36.51	94963.0
2020-02-03	AOM	ETF	40.27	40.41	40.27	40.29	102062.0
2020-02-03	AOR	ETF	47.66	47.9	47.66	47.73	247181.0
2020-02-03	ARGT	ETF	25.56	26.33	25.56	26.18	45800.0
2020-02-03	ARKF	ETF	25.4	25.76	25.4	25.69	57600.0
2020-02-03	ARKG	ETF	32.99	33.19	32.789	33.18	144500.0

> showing 50 of 1,950 rows — these rows as CSV

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