PREVIEW / etf_daily / 2020-02-21

all etf daily files

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

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-21	SPY	ETF	335.47	335.81	332.58	333.48	113788200.0
2020-02-21	QQQ	ETF	233.64	234.01	229.3211	230.27	66058611.0
2020-02-21	IWM	ETF	168.15	168.63	166.33	167.1	18729900.0
2020-02-21	DIA	ETF	290.8	291.05	288.75	289.74	3271800.0
2020-02-21	GLD	ETF	154.43	155.22	154.18	154.7	16344500.0
2020-02-21	TLT	ETF	147.8	148.88	147.65	148.04	13860300.0
2020-02-21	AAAU	ETF	16.37	16.44	16.34	16.4	135000.0
2020-02-21	AADR	ETF	56.73	56.96	56.51	56.7	4300.0
2020-02-21	AAXJ	ETF	71.8	71.9	71.4	71.47	1372400.0
2020-02-21	ABEQ	ETF	25.055	25.115	25.04	25.092	2900.0
2020-02-21	ACES	ETF	43.48	43.48	42.51	42.997	69700.0
2020-02-21	ACIO	ETF	25.078	25.11	25.042	25.082	13100.0
2020-02-21	ACSI	ETF	37.5275	37.5275	37.3276	37.3682	850.0
2020-02-21	ACTX	ETF	7.5249	7.5249	7.0801	7.0801	69.0
2020-02-21	ACWF	ETF	31.361	31.53	31.361	31.4126	7539.0
2020-02-21	ACWI	ETF	80.76	80.76	80.18	80.36	2489600.0
2020-02-21	ACWV	ETF	98.64	98.78	98.47	98.69	145800.0
2020-02-21	ACWX	ETF	48.28	48.33	48.1	48.18	795843.0
2020-02-21	ADME	ETF	31.64	31.65	31.535	31.56	12600.0
2020-02-21	ADRE	ETF	42.6301	42.6802	42.4296	42.465	1894.0
2020-02-21	AESR	ETF	10.425	10.425	10.425	10.425	100.0
2020-02-21	AFIF	ETF	9.76	9.77	9.75	9.7648	19616.0
2020-02-21	AFK	ETF	19.43	19.52	19.32	19.3835	8926.0
2020-02-21	AFLG	ETF	20.976	20.976	20.976	20.976	100.0
2020-02-21	AFTY	ETF	16.6	16.685	16.6	16.6	9800.0
2020-02-21	AGG	ETF	114.86	115.1	114.84	114.9	4492700.0
2020-02-21	AGGY	ETF	53.54	53.63	53.5	53.56	144800.0
2020-02-21	AGNG	ETF	24.563	24.775	24.563	24.775	900.0
2020-02-21	AGQ	ETF	33.48	34.03	33.43	33.54	615000.0
2020-02-21	AGZ	ETF	117.45	117.61	117.445	117.53	32579.0
2020-02-21	AGZD	ETF	23.985	24.095	23.985	24.07	17200.0
2020-02-21	AIA	ETF	64.78	64.86	64.48	64.52	32153.0
2020-02-21	AIEQ	ETF	30.05	30.123	29.75	29.831	27500.0
2020-02-21	AIQ	ETF	19.67	19.67	19.242	19.311	22875.0
2020-02-21	AIRR	ETF	29.11	29.21	28.966	29.145	126000.0
2020-02-21	AIVI	ETF	41.27	41.27	41.19	41.24	4500.0
2020-02-21	ALTY	ETF	14.97	15.014	14.93	14.967	16200.0
2020-02-21	AMJ	ETF	20.3	20.32	20.0	20.08	2362462.0
2020-02-21	AMLP	ETF	38.5	38.6	37.95	38.25	4371580.0
2020-02-21	AMOM	ETF	27.464	27.464	27.464	27.464	100.0
2020-02-21	AMUB	ETF	12.605	12.6688	12.605	12.6688	534.0
2020-02-21	AMZA	ETF	39.2	39.2	37.9	38.2	121110.0
2020-02-21	ANGL	ETF	30.43	30.48	30.39	30.43	403700.0
2020-02-21	AOA	ETF	58.85	58.85	58.57	58.67	64900.0
2020-02-21	AOK	ETF	36.83	36.92	36.83	36.89	57081.0
2020-02-21	AOM	ETF	40.91	40.91	40.776	40.84	256743.0
2020-02-21	AOR	ETF	48.52	48.6209	48.41	48.51	227984.0
2020-02-21	ARGT	ETF	26.3	26.64	26.24	26.57	18700.0
2020-02-21	ARKF	ETF	27.35	27.35	26.78	26.92	80200.0
2020-02-21	ARKG	ETF	36.84	36.992	36.15	36.41	240900.0

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

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