PREVIEW / etf_daily / 2020-05-14

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-14.parquet
  size:    76 KB
  rows:    1,992

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-05-14	SPY	ETF	278.95	285.11	272.99	284.97	121977900.0
2020-05-14	QQQ	ETF	218.12	221.87	215.99	221.83	51549345.0
2020-05-14	IWM	ETF	119.97	123.27	117.18	123.12	55904300.0
2020-05-14	DIA	ETF	230.08	236.76	228.3	236.75	6964500.0
2020-05-14	GLD	ETF	161.53	163.34	161.51	163.01	17084400.0
2020-05-14	TLT	ETF	167.32	168.15	167.05	167.14	10080000.0
2020-05-14	AAAU	ETF	17.14	17.31	17.13	17.28	488600.0
2020-05-14	AADR	ETF	45.3	46.16	45.3	46.14	4200.0
2020-05-14	AAXJ	ETF	62.81	64.11	62.58	64.03	690200.0
2020-05-14	ABEQ	ETF	21.01	21.42	20.96	21.413	32400.0
2020-05-14	ACES	ETF	32.49	32.97	31.71	32.97	32300.0
2020-05-14	ACIO	ETF	23.489	23.96	23.489	23.96	29000.0
2020-05-14	ACSI	ETF	29.863	29.863	29.863	29.863	122.0
2020-05-14	ACTX	ETF	4.13	5.31	4.13	5.31	88.0
2020-05-14	ACWF	ETF	25.23	25.65	24.97	25.65	31429.0
2020-05-14	ACWI	ETF	66.37	67.68	65.77	67.68	3847900.0
2020-05-14	ACWV	ETF	83.73	85.16	83.37	85.12	630300.0
2020-05-14	ACWX	ETF	38.6	39.31	38.39	39.27	4206433.0
2020-05-14	ADME	ETF	30.163	30.67	30.163	30.67	21300.0
2020-05-14	ADRE	ETF	34.46	35.36	34.46	35.36	2336.0
2020-05-14	AESR	ETF	9.54	9.54	8.96	9.157	3300.0
2020-05-14	AFIF	ETF	10.4	10.4	9.8001	9.83	9881.0
2020-05-14	AFK	ETF	14.28	14.5	14.185	14.42	8669.0
2020-05-14	AFLG	ETF	17.24	17.393	17.24	17.393	500.0
2020-05-14	AFMC	ETF	15.08	15.08	15.08	15.08	100.0
2020-05-14	AFSM	ETF	14.2	14.529	14.2	14.529	200.0
2020-05-14	AFTY	ETF	15.87	15.98	15.87	15.98	700.0
2020-05-14	AGG	ETF	116.91	116.97	116.72	116.96	5698900.0
2020-05-14	AGGY	ETF	52.85	53.033	52.85	53.0	353200.0
2020-05-14	AGNG	ETF	22.4	22.675	22.4	22.671	3500.0
2020-05-14	AGQ	ETF	21.78	23.23	21.78	23.2	685100.0
2020-05-14	AGZ	ETF	120.85	121.089	120.81	120.9464	25597.0
2020-05-14	AGZD	ETF	23.19	23.25	23.15	23.21	19200.0
2020-05-14	AIA	ETF	58.17	59.27	57.91	59.27	38967.0
2020-05-14	AIEQ	ETF	26.18	26.42	25.79	26.42	19900.0
2020-05-14	AIQ	ETF	17.87	18.19	17.68	18.16	59594.0
2020-05-14	AIRR	ETF	18.5	19.319	18.35	19.319	35300.0
2020-05-14	AIVI	ETF	32.09	32.45	31.87	32.45	7100.0
2020-05-14	ALTY	ETF	9.37	9.664	9.19	9.64	13300.0
2020-05-14	AMJ	ETF	12.66	13.15	12.16	12.87	1615412.0
2020-05-14	AMLP	ETF	22.85	23.9	22.0	23.35	3743340.0
2020-05-14	AMOM	ETF	26.775	26.775	26.775	26.775	100.0
2020-05-14	AMUB	ETF	7.935	8.1	7.935	8.0816	6829.0
2020-05-14	AMZA	ETF	16.14	17.03	15.53	16.53	69700.0
2020-05-14	ANGL	ETF	26.46	26.82	26.32	26.59	925700.0
2020-05-14	AOA	ETF	49.77	50.47	49.35	50.47	93800.0
2020-05-14	AOK	ETF	34.72	34.93	34.57	34.93	82519.0
2020-05-14	AOM	ETF	37.55	37.93	37.42	37.92	212960.0
2020-05-14	AOR	ETF	42.85	43.37	42.625	43.37	83480.0
2020-05-14	ARB	ETF	24.82	24.86	24.82	24.84	3245.0

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

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