PREVIEW / etf_daily / 2020-02-28

all etf daily files

  file:    by_date/etf_daily/2020/2020-02-28.parquet
  size:    75 KB
  rows:    1,984

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-28	SPY	ETF	288.7	297.89	285.54	296.26	384975800.0
2020-02-28	QQQ	ETF	198.92	207.17	198.17	205.8	149247073.0
2020-02-28	IWM	ETF	144.85	149.13	143.91	146.33	72036400.0
2020-02-28	DIA	ETF	250.52	255.12	247.0	254.56	17541400.0
2020-02-28	GLD	ETF	152.71	152.77	147.05	148.38	42699600.0
2020-02-28	TLT	ETF	154.45	155.98	154.16	155.31	44935200.0
2020-02-28	AAAU	ETF	16.19	16.19	15.59	15.73	325700.0
2020-02-28	AADR	ETF	48.71	49.38	47.94	49.38	23300.0
2020-02-28	AAXJ	ETF	66.53	68.34	66.07	68.34	5505100.0
2020-02-28	ABEQ	ETF	22.48	22.812	22.48	22.812	3500.0
2020-02-28	ACES	ETF	35.46	37.16	35.26	37.16	77400.0
2020-02-28	ACIO	ETF	23.98	24.32	23.8	24.192	26400.0
2020-02-28	ACSI	ETF	32.44	32.91	32.34	32.8912	7137.0
2020-02-28	ACTX	ETF	6.7851	7.3751	6.0476	6.4901	226.0
2020-02-28	ACWF	ETF	27.8644	28.18	27.57	28.18	21495.0
2020-02-28	ACWI	ETF	70.81	72.37	70.17	72.26	7472500.0
2020-02-28	ACWV	ETF	89.02	90.21	88.04	90.17	1175900.0
2020-02-28	ACWX	ETF	43.48	44.34	43.14	44.28	1749930.0
2020-02-28	ADME	ETF	29.59	29.91	29.54	29.885	64100.0
2020-02-28	ADRE	ETF	38.63	39.74	38.53	39.69	21374.0
2020-02-28	AESR	ETF	9.0	9.181	9.0	9.181	600.0
2020-02-28	AFIF	ETF	9.855	9.885	9.85	9.885	889.0
2020-02-28	AFK	ETF	18.03	18.03	17.01	17.5297	29290.0
2020-02-28	AFLG	ETF	18.235	18.39	18.235	18.39	600.0
2020-02-28	AFMC	ETF	18.028	18.028	18.028	18.028	100.0
2020-02-28	AFSM	ETF	17.766	17.778	17.766	17.778	300.0
2020-02-28	AFTY	ETF	15.89	16.14	15.66	16.136	3500.0
2020-02-28	AGG	ETF	115.88	116.34	115.76	116.22	17243000.0
2020-02-28	AGGY	ETF	53.64	53.806	53.52	53.79	477200.0
2020-02-28	AGNG	ETF	22.13	22.55	21.8	22.43	10400.0
2020-02-28	AGQ	ETF	28.17	28.17	25.98	26.65	677500.0
2020-02-28	AGZ	ETF	119.03	119.2	118.9105	119.125	97654.0
2020-02-28	AGZD	ETF	23.87	23.92	23.815	23.86	21000.0
2020-02-28	AIA	ETF	60.42	61.9	60.04	61.9	98143.0
2020-02-28	AIEQ	ETF	25.74	26.44	25.5	26.43	207800.0
2020-02-28	AIQ	ETF	16.9	17.4	16.8	17.15	51390.0
2020-02-28	AIRR	ETF	25.08	25.551	25.0	25.445	14600.0
2020-02-28	AIVI	ETF	37.21	37.58	36.76	37.58	152200.0
2020-02-28	ALTY	ETF	13.45	13.45	13.06	13.321	33000.0
2020-02-28	AMJ	ETF	16.6	17.29	16.2	17.29	10632647.0
2020-02-28	AMLP	ETF	32.0	33.45	31.35	33.35	13550120.0
2020-02-28	AMOM	ETF	24.18	24.459	24.175	24.459	500.0
2020-02-28	AMUB	ETF	10.28	10.74	10.25	10.74	5963.0
2020-02-28	AMZA	ETF	29.3	31.2	28.5	31.0	256360.0
2020-02-28	ANGL	ETF	29.17	29.53	28.76	29.48	1825500.0
2020-02-28	AOA	ETF	52.99	53.97	52.66	53.85	203900.0
2020-02-28	AOK	ETF	35.59	35.92	35.47	35.92	258183.0
2020-02-28	AOM	ETF	38.84	39.23	38.76	39.23	371513.0
2020-02-28	AOR	ETF	44.99	45.7	44.765	45.7	321510.0
2020-02-28	ARCM	ETF	100.0	100.0	99.29	99.29	3300.0

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

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