PREVIEW / etf_daily / 2020-03-25

all etf daily files

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

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-25	SPY	ETF	244.87	256.35	239.75	246.79	299430300.0
2020-03-25	QQQ	ETF	184.42	189.51	179.98	182.3	88754909.0
2020-03-25	IWM	ETF	109.48	114.0	106.02	109.97	56043700.0
2020-03-25	DIA	ETF	210.57	220.17	205.32	212.06	17556100.0
2020-03-25	GLD	ETF	152.58	152.88	151.01	151.3	16457200.0
2020-03-25	TLT	ETF	163.59	166.68	161.62	162.54	10750600.0
2020-03-25	AAAU	ETF	16.33	16.33	16.05	16.12	210300.0
2020-03-25	AADR	ETF	39.03	41.45	39.03	40.68	42100.0
2020-03-25	AAXJ	ETF	58.71	60.02	58.16	59.39	3566000.0
2020-03-25	ABEQ	ETF	19.56	20.42	19.536	19.881	10800.0
2020-03-25	ACES	ETF	28.52	29.76	27.22	29.01	88100.0
2020-03-25	ACIO	ETF	22.275	22.53	22.275	22.368	7200.0
2020-03-25	ACSI	ETF	26.66	27.8159	26.45	27.272	2328.0
2020-03-25	ACTX	ETF	2.95	3.54	2.8692	3.54	1055.0
2020-03-25	ACWF	ETF	22.95	24.04	22.6057	23.35	46268.0
2020-03-25	ACWI	ETF	59.42	62.13	58.53	60.36	14629400.0
2020-03-25	ACWV	ETF	76.64	79.23	75.23	77.33	617700.0
2020-03-25	ACWX	ETF	36.13	37.45	35.65	36.98	4678127.0
2020-03-25	ADME	ETF	27.32	28.018	27.32	27.569	35500.0
2020-03-25	ADRE	ETF	32.9	34.13	32.6416	33.4884	6409.0
2020-03-25	AESR	ETF	7.99	8.076	7.81	7.863	12100.0
2020-03-25	AFIF	ETF	9.665	9.6809	9.66	9.6809	3913.0
2020-03-25	AFK	ETF	13.63	13.9	12.72	13.04	18559.0
2020-03-25	AFLG	ETF	14.98	15.286	14.96	15.179	5100.0
2020-03-25	AFMC	ETF	13.79	13.79	13.734	13.734	500.0
2020-03-25	AFTY	ETF	14.95	15.1	14.83	14.998	11200.0
2020-03-25	AGG	ETF	114.0	114.75	113.7	114.73	10999700.0
2020-03-25	AGGY	ETF	50.23	50.57	49.91	50.35	216700.0
2020-03-25	AGNG	ETF	18.48	19.31	18.39	18.761	3200.0
2020-03-25	AGQ	ETF	18.93	20.48	18.83	19.88	409200.0
2020-03-25	AGZ	ETF	119.2	120.23	119.2	119.66	160422.0
2020-03-25	AGZD	ETF	21.525	22.645	21.525	22.55	20000.0
2020-03-25	AIA	ETF	55.68	56.9156	55.27	56.16	106922.0
2020-03-25	AIEQ	ETF	21.3	22.16	21.06	21.62	51700.0
2020-03-25	AIQ	ETF	15.25	15.6289	14.9219	15.156	33608.0
2020-03-25	AIRR	ETF	18.199	19.63	18.199	19.097	17700.0
2020-03-25	AIVI	ETF	30.04	31.07	29.74	30.73	149400.0
2020-03-25	ALTY	ETF	8.16	8.896	7.73	8.37	24000.0
2020-03-25	AMJ	ETF	8.36	9.32	8.14	8.94	7890091.0
2020-03-25	AMLP	ETF	16.15	17.85	15.45	16.95	14247020.0
2020-03-25	AMOM	ETF	21.719	21.719	21.719	21.719	100.0
2020-03-25	AMUB	ETF	5.37	5.8143	5.37	5.6653	48524.0
2020-03-25	AMZA	ETF	10.3	11.7	9.8	11.4	172700.0
2020-03-25	ANGL	ETF	23.74	24.7	23.73	23.94	912700.0
2020-03-25	AOA	ETF	45.44	47.46	45.2	46.12	231800.0
2020-03-25	AOK	ETF	32.69	33.33	32.42	33.1	168411.0
2020-03-25	AOM	ETF	35.16	36.21	35.0801	35.79	297105.0
2020-03-25	AOR	ETF	39.66	41.05	39.55	40.31	262922.0
2020-03-25	ARCM	ETF	99.4	99.4	99.33	99.33	30000.0
2020-03-25	ARGT	ETF	16.11	16.96	15.97	16.57	34300.0

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

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