PREVIEW / etf_daily / 2020-03-24

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-24.parquet
  size:    75 KB
  rows:    1,980

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-03-24	SPY	ETF	234.42	244.1	233.8	243.15	235494500.0
2020-03-24	QQQ	ETF	179.91	183.83	177.95	183.66	94881785.0
2020-03-24	IWM	ETF	105.37	109.33	99.93	109.04	73386700.0
2020-03-24	DIA	ETF	196.27	207.21	196.21	206.64	14123600.0
2020-03-24	GLD	ETF	153.5	155.66	152.05	153.4	20743500.0
2020-03-24	TLT	ETF	161.25	165.45	160.41	162.91	11948600.0
2020-03-24	AAAU	ETF	16.39	16.5	16.08	16.36	605500.0
2020-03-24	AADR	ETF	37.18	38.31	37.18	38.31	34300.0
2020-03-24	AAXJ	ETF	56.83	57.58	56.7	57.55	1122200.0
2020-03-24	ABEQ	ETF	19.96	19.96	19.063	19.56	11900.0
2020-03-24	ACES	ETF	25.37	27.53	25.37	27.53	82300.0
2020-03-24	ACIO	ETF	21.27	22.61	21.24	22.2	147100.0
2020-03-24	ACSI	ETF	26.0478	26.637	26.0478	26.637	628.0
2020-03-24	ACTX	ETF	2.36	3.54	2.36	2.95	1077.0
2020-03-24	ACWF	ETF	22.08	22.92	22.08	22.92	59913.0
2020-03-24	ACWI	ETF	57.64	59.11	57.18	58.75	5105700.0
2020-03-24	ACWV	ETF	74.17	76.13	74.0	76.04	2063400.0
2020-03-24	ACWX	ETF	35.14	35.77	34.935	35.55	3448758.0
2020-03-24	ADME	ETF	26.992	27.64	26.992	27.511	124900.0
2020-03-24	ADRE	ETF	31.64	32.5557	31.64	32.275	17818.0
2020-03-24	AESR	ETF	7.49	7.84	7.42	7.785	42600.0
2020-03-24	AFIF	ETF	9.55	9.76	9.55	9.6752	146397.0
2020-03-24	AFK	ETF	12.44	12.75	12.44	12.55	10059.0
2020-03-24	AFLG	ETF	14.45	14.831	14.45	14.831	400.0
2020-03-24	AFMC	ETF	13.297	13.297	13.297	13.297	100.0
2020-03-24	AFSM	ETF	12.928	12.928	12.928	12.928	100.0
2020-03-24	AFTY	ETF	14.62	14.85	14.62	14.85	16700.0
2020-03-24	AGG	ETF	111.52	113.57	111.08	113.57	10253600.0
2020-03-24	AGGY	ETF	49.34	49.891	48.641	49.68	527500.0
2020-03-24	AGNG	ETF	18.2	18.55	18.087	18.463	9900.0
2020-03-24	AGQ	ETF	18.66	19.18	17.88	18.89	666800.0
2020-03-24	AGZ	ETF	119.77	123.37	119.492	119.84	157490.0
2020-03-24	AGZD	ETF	22.225	22.605	22.22	22.25	39400.0
2020-03-24	AIA	ETF	54.25	54.898	54.07	54.7819	94095.0
2020-03-24	AIEQ	ETF	20.56	21.33	20.509	21.3	46100.0
2020-03-24	AIQ	ETF	14.64	14.98	14.64	14.9519	26667.0
2020-03-24	AIRR	ETF	17.9	18.66	17.76	18.549	27900.0
2020-03-24	AIVI	ETF	29.62	30.04	29.14	29.86	82300.0
2020-03-24	ALTY	ETF	7.78	8.13	7.61	7.892	29300.0
2020-03-24	AMJ	ETF	8.53	8.76	8.22	8.38	3167051.0
2020-03-24	AMLP	ETF	16.75	17.05	15.6	16.05	9065600.0
2020-03-24	AMOM	ETF	20.9	21.523	20.9	21.523	200.0
2020-03-24	AMUB	ETF	5.35	5.35	4.9	5.3005	21145.0
2020-03-24	AMZA	ETF	11.0	11.0	10.2	10.3	72710.0
2020-03-24	ANGL	ETF	22.48	23.7	22.24	23.66	1093000.0
2020-03-24	AOA	ETF	44.0	45.36	44.0	45.13	151700.0
2020-03-24	AOK	ETF	32.18	32.72	32.09	32.59	248217.0
2020-03-24	AOM	ETF	34.54	35.33	34.54	35.3	538277.0
2020-03-24	AOR	ETF	38.67	39.81	38.67	39.5	505405.0
2020-03-24	ARCM	ETF	99.35	99.35	99.35	99.35	100.0

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

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