PREVIEW / etf_daily / 2020-02-04

all etf daily files

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

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-04	SPY	ETF	328.07	330.01	327.72	329.06	62573200.0
2020-02-04	QQQ	ETF	225.39	227.86	224.6523	227.47	30691211.0
2020-02-04	IWM	ETF	164.31	165.31	164.16	164.77	15994200.0
2020-02-04	DIA	ETF	287.68	289.0	287.42	288.04	3004100.0
2020-02-04	GLD	ETF	146.97	147.03	145.8	146.43	10525600.0
2020-02-04	TLT	ETF	143.99	144.14	143.06	143.58	11388300.0
2020-02-04	AAAU	ETF	15.58	15.58	15.46	15.51	170200.0
2020-02-04	AADR	ETF	55.23	55.89	55.23	55.8	15000.0
2020-02-04	AAXJ	ETF	71.53	72.0	71.52	71.72	974800.0
2020-02-04	ABEQ	ETF	24.786	24.786	24.731	24.731	176600.0
2020-02-04	ACES	ETF	38.68	39.17	38.25	38.78	62500.0
2020-02-04	ACIO	ETF	25.251	25.253	25.217	25.217	3900.0
2020-02-04	ACSI	ETF	36.31	36.4	36.31	36.3202	2271.0
2020-02-04	ACTX	ETF	7.3751	8.8501	7.3751	8.0241	83.0
2020-02-04	ACWF	ETF	31.12	31.2056	31.11	31.118	7000.0
2020-02-04	ACWI	ETF	79.76	80.17	79.71	79.99	2279400.0
2020-02-04	ACWV	ETF	98.27	98.27	97.94	97.99	209100.0
2020-02-04	ACWX	ETF	48.42	48.61	48.39	48.47	4768753.0
2020-02-04	ADME	ETF	31.136	31.14	31.05	31.05	4300.0
2020-02-04	ADRE	ETF	43.42	43.75	43.42	43.59	5656.0
2020-02-04	AESR	ETF	10.33	10.35	10.325	10.325	800.0
2020-02-04	AFIF	ETF	9.74	9.74	9.71	9.7285	24761.0
2020-02-04	AFK	ETF	19.3838	19.4707	19.3838	19.4189	7232.0
2020-02-04	AFTY	ETF	15.92	16.16	15.92	16.092	26000.0
2020-02-04	AGG	ETF	114.1	114.1	113.89	113.99	5290800.0
2020-02-04	AGGY	ETF	53.15	53.15	53.065	53.13	171900.0
2020-02-04	AGNG	ETF	23.91	24.04	23.9	24.04	5100.0
2020-02-04	AGQ	ETF	30.77	30.77	30.17	30.53	169100.0
2020-02-04	AGZ	ETF	116.95	116.95	116.8006	116.91	38977.0
2020-02-04	AGZD	ETF	23.985	24.045	23.985	24.005	5000.0
2020-02-04	AIA	ETF	64.91	65.36	64.89	65.06	96443.0
2020-02-04	AIEQ	ETF	29.21	29.45	29.21	29.36	42600.0
2020-02-04	AIQ	ETF	19.03	19.279	19.03	19.25	11835.0
2020-02-04	AIRR	ETF	28.711	28.85	28.67	28.76	18600.0
2020-02-04	AIVI	ETF	41.7	41.83	41.7	41.75	3700.0
2020-02-04	ALTY	ETF	14.93	14.95	14.92	14.92	5400.0
2020-02-04	AMJ	ETF	20.6	21.04	20.6	20.78	2057107.0
2020-02-04	AMLP	ETF	40.35	41.05	40.25	40.45	5111160.0
2020-02-04	AMOM	ETF	27.0	27.06	27.0	27.06	1000.0
2020-02-04	AMUB	ETF	13.06	13.0646	13.06	13.0646	493.0
2020-02-04	AMZA	ETF	40.1	41.08	40.1	40.6	96040.0
2020-02-04	ANGL	ETF	30.01	30.01	29.91	29.99	743700.0
2020-02-04	AOA	ETF	58.22	58.44	58.22	58.37	46300.0
2020-02-04	AOK	ETF	36.55	36.66	36.53	36.6	67964.0
2020-02-04	AOM	ETF	40.42	40.6	40.42	40.54	198536.0
2020-02-04	AOR	ETF	48.19	48.27	48.169	48.24	102242.0
2020-02-04	ARGT	ETF	26.4	26.69	26.13	26.16	37900.0
2020-02-04	ARKF	ETF	26.24	26.5	26.19	26.42	65200.0
2020-02-04	ARKG	ETF	33.82	34.14	33.562	34.089	187000.0
2020-02-04	ARKK	ETF	55.72	57.039	55.18	56.32	664200.0

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

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