PREVIEW / etf_daily / 2020-04-23

all etf daily files

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

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-04-23	SPY	ETF	280.49	283.94	278.75	279.08	104709700.0
2020-04-23	QQQ	ETF	211.8	214.435	210.095	210.52	43278542.0
2020-04-23	IWM	ETF	120.11	122.9	119.68	120.34	38571200.0
2020-04-23	DIA	ETF	235.51	238.92	234.83	235.07	6364800.0
2020-04-23	GLD	ETF	162.39	163.6	161.84	163.34	14928500.0
2020-04-23	TLT	ETF	169.87	170.93	169.61	170.44	5968600.0
2020-04-23	AAAU	ETF	17.27	17.38	17.17	17.3	461700.0
2020-04-23	AADR	ETF	45.58	45.58	44.75	44.85	2800.0
2020-04-23	AAXJ	ETF	63.19	63.62	62.59	62.66	1039200.0
2020-04-23	ABEQ	ETF	21.608	21.715	21.5	21.5	6100.0
2020-04-23	ACES	ETF	31.75	32.055	31.466	31.64	28200.0
2020-04-23	ACIO	ETF	23.89	23.89	23.646	23.646	13100.0
2020-04-23	ACSI	ETF	29.943	29.943	29.8877	29.8877	205.0
2020-04-23	ACTX	ETF	5.428	5.428	3.835	4.72	1377.0
2020-04-23	ACWF	ETF	25.65	25.9435	25.441	25.51	14350.0
2020-04-23	ACWI	ETF	66.58	67.37	66.11	66.22	3718600.0
2020-04-23	ACWV	ETF	86.28	86.6	85.23	85.27	523100.0
2020-04-23	ACWX	ETF	38.93	39.4	38.63	38.67	4025542.0
2020-04-23	ADME	ETF	29.95	29.95	29.666	29.666	11700.0
2020-04-23	ADRE	ETF	36.03	36.03	35.36	35.39	8225.0
2020-04-23	AESR	ETF	9.06	9.06	8.983	8.983	454100.0
2020-04-23	AFIF	ETF	9.8298	9.85	9.76	9.76	906037.0
2020-04-23	AFK	ETF	13.9	14.38	13.9	14.0595	25571.0
2020-04-23	AFTY	ETF	15.59	15.59	15.55	15.55	4300.0
2020-04-23	AGG	ETF	117.33	117.45	117.19	117.42	4331100.0
2020-04-23	AGGY	ETF	53.18	53.22	53.1	53.19	110200.0
2020-04-23	AGNG	ETF	22.69	22.69	22.264	22.264	3700.0
2020-04-23	AGQ	ETF	21.8	22.33	21.13	21.43	480800.0
2020-04-23	AGZ	ETF	120.6	120.68	120.37	120.43	124833.0
2020-04-23	AGZD	ETF	23.38	23.66	23.145	23.325	11600.0
2020-04-23	AIA	ETF	58.72	59.095	58.28	58.28	131979.0
2020-04-23	AIEQ	ETF	25.24	25.51	25.13	25.14	17300.0
2020-04-23	AIQ	ETF	17.292	17.399	17.1853	17.22	6986.0
2020-04-23	AIRR	ETF	20.08	20.553	20.08	20.288	60500.0
2020-04-23	AIVI	ETF	32.18	32.54	31.94	31.94	11200.0
2020-04-23	ALTY	ETF	9.32	9.543	9.32	9.397	2100.0
2020-04-23	AMJ	ETF	11.72	12.38	11.68	12.35	2584987.0
2020-04-23	AMLP	ETF	22.15	23.3	22.15	23.15	6441440.0
2020-04-23	AMUB	ETF	7.53	7.7624	7.53	7.7624	12331.0
2020-04-23	AMZA	ETF	14.47	15.7	14.36	15.64	119700.0
2020-04-23	ANGL	ETF	26.72	26.93	26.6	26.75	891900.0
2020-04-23	AOA	ETF	49.97	50.44	49.69	49.84	100700.0
2020-04-23	AOK	ETF	34.69	34.98	34.69	34.85	67501.0
2020-04-23	AOM	ETF	37.85	37.9859	37.6817	37.71	266345.0
2020-04-23	AOR	ETF	43.13	43.39	42.87	43.02	241032.0
2020-04-23	ARGT	ETF	17.42	17.55	17.05	17.23	37000.0
2020-04-23	ARKF	ETF	23.34	23.499	23.06	23.11	64600.0
2020-04-23	ARKG	ETF	39.57	40.0	38.75	38.775	358200.0
2020-04-23	ARKK	ETF	52.43	53.469	51.927	52.01	654000.0
2020-04-23	ARKQ	ETF	36.7	37.219	36.42	36.42	38000.0

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

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