PREVIEW / etf_daily / 2020-01-22

all etf daily files

  file:    by_date/etf_daily/2020/2020-01-22.parquet
  size:    74 KB
  rows:    1,926

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-01-22	SPY	ETF	332.24	332.95	331.17	331.34	48914900.0
2020-01-22	QQQ	ETF	224.38	225.15	223.59	223.87	20736403.0
2020-01-22	IWM	ETF	168.19	168.62	167.18	167.56	14916300.0
2020-01-22	DIA	ETF	292.5	293.07	291.58	291.81	2077000.0
2020-01-22	GLD	ETF	146.68	146.81	146.38	146.79	4778200.0
2020-01-22	TLT	ETF	139.72	140.14	139.59	139.96	6317000.0
2020-01-22	AAAU	ETF	15.54	15.55	15.51	15.55	28900.0
2020-01-22	AADR	ETF	56.17	56.26	56.03	56.15	17500.0
2020-01-22	AAXJ	ETF	74.9	74.93	74.41	74.55	1057100.0
2020-01-22	ABEQ	ETF	25.07	28.2002	24.94	24.9781	149692.0
2020-01-22	ACES	ETF	37.13	37.13	36.6	36.625	34100.0
2020-01-22	ACIO	ETF	25.78	25.78	25.737	25.754	27900.0
2020-01-22	ACSI	ETF	36.4	36.43	36.3308	36.3308	4131.0
2020-01-22	ACTX	ETF	12.0951	12.0951	11.8001	11.8768	1185.0
2020-01-22	ACWF	ETF	31.93	31.93	31.7215	31.7742	5280.0
2020-01-22	ACWI	ETF	81.16	81.29	80.91	80.93	2105700.0
2020-01-22	ACWV	ETF	98.53	98.69	98.4	98.48	159800.0
2020-01-22	ACWX	ETF	49.69	49.7	49.495	49.57	1369546.0
2020-01-22	ADME	ETF	31.41	31.41	31.3	31.3	116200.0
2020-01-22	ADRE	ETF	44.91	45.1315	44.75	44.75	6168.0
2020-01-22	AESR	ETF	10.38	10.38	10.38	10.38	99100.0
2020-01-22	AFIF	ETF	9.746	9.76	9.73	9.745	1576.0
2020-01-22	AFK	ETF	20.2	20.3851	20.2	20.28	3586.0
2020-01-22	AFLG	ETF	21.0	21.0	20.954	20.954	300.0
2020-01-22	AFTY	ETF	17.207	17.21	17.151	17.163	5600.0
2020-01-22	AGG	ETF	113.44	113.49	113.39	113.43	3627200.0
2020-01-22	AGGY	ETF	52.68	52.78	52.65	52.7	335400.0
2020-01-22	AGNG	ETF	24.652	24.652	24.17	24.375	11100.0
2020-01-22	AGQ	ETF	31.57	31.65	31.25	31.39	252200.0
2020-01-22	AGZ	ETF	116.28	116.3813	116.27	116.38	53747.0
2020-01-22	AGZD	ETF	24.025	24.085	24.025	24.045	7600.0
2020-01-22	AIA	ETF	67.87	67.95	67.5133	67.7	85981.0
2020-01-22	AIEQ	ETF	29.67	29.71	29.568	29.568	44800.0
2020-01-22	AIQ	ETF	19.1	19.18	19.1	19.1	16795.0
2020-01-22	AIRR	ETF	29.229	29.229	29.025	29.045	4500.0
2020-01-22	AIVI	ETF	42.82	42.82	42.7	42.73	6000.0
2020-01-22	ALTY	ETF	15.1	15.1	15.022	15.031	9600.0
2020-01-22	AMJ	ETF	22.14	22.16	21.66	21.66	3862120.0
2020-01-22	AMLP	ETF	43.25	43.25	42.2	42.35	6710540.0
2020-01-22	AMOM	ETF	27.072	27.072	27.072	27.072	100.0
2020-01-22	AMUB	ETF	13.7101	13.717	13.6612	13.6612	10974.0
2020-01-22	AMZA	ETF	44.6	45.0	43.1	43.2	175590.0
2020-01-22	ANGL	ETF	30.12	30.2	30.08	30.12	2104500.0
2020-01-22	AOA	ETF	59.03	59.16	58.9	59.0	68100.0
2020-01-22	AOK	ETF	36.65	36.73	36.65	36.67	147386.0
2020-01-22	AOM	ETF	40.65	40.6986	40.61	40.66	173908.0
2020-01-22	AOR	ETF	48.55	48.6361	48.47	48.47	107869.0
2020-01-22	ARGT	ETF	26.22	26.4	26.13	26.28	167700.0
2020-01-22	ARKF	ETF	25.69	25.835	25.57	25.618	16800.0
2020-01-22	ARKG	ETF	34.72	35.02	34.592	34.75	124600.0

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

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