PREVIEW / etf_daily / 2020-11-12

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-12.parquet
  size:    81 KB
  rows:    2,134

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-11-12	SPY	ETF	355.58	356.72	351.26	353.21	67546200.0
2020-11-12	QQQ	ETF	290.72	292.074	287.25	288.4	34516826.0
2020-11-12	IWM	ETF	171.4	172.64	168.34	169.98	33986800.0
2020-11-12	DIA	ETF	292.22	293.32	289.19	291.05	4361900.0
2020-11-12	GLD	ETF	176.04	176.77	175.84	175.96	7167900.0
2020-11-12	TLT	ETF	156.94	158.4	156.71	158.37	15999700.0
2020-11-12	AAA	ETF	24.945	24.945	24.945	24.945	256.0
2020-11-12	AAAU	ETF	18.7	18.76	18.67	18.68	260800.0
2020-11-12	AADR	ETF	57.39	57.5	56.78	56.78	3200.0
2020-11-12	AAXJ	ETF	83.95	84.28	83.05	83.27	1548600.0
2020-11-12	ABEQ	ETF	24.36	24.36	24.152	24.255	3500.0
2020-11-12	ACES	ETF	62.65	62.89	61.41	61.77	220100.0
2020-11-12	ACIO	ETF	27.51	27.51	27.17	27.19	26500.0
2020-11-12	ACSI	ETF	40.6143	40.6143	40.6143	40.6143	110.0
2020-11-12	ACTV	ETF	27.08	27.11	26.89	26.9419	1670.0
2020-11-12	ACTX	ETF	2.93	2.93	2.93	2.93	334.0
2020-11-12	ACVF	ETF	27.48	27.48	26.1	26.23	24400.0
2020-11-12	ACWF	ETF	31.64	31.7481	31.3	31.39	3423.0
2020-11-12	ACWI	ETF	85.47	85.68	84.53	84.86	4812400.0
2020-11-12	ACWV	ETF	95.73	95.93	95.01	95.39	238700.0
2020-11-12	ACWX	ETF	49.73	49.82	49.21	49.3	1475988.0
2020-11-12	ADFI	ETF	9.95	9.95	9.95	9.95	100.0
2020-11-12	ADME	ETF	34.959	34.959	34.726	34.81	15300.0
2020-11-12	ADRE	ETF	52.51	52.51	51.67	51.735	17563.0
2020-11-12	AESR	ETF	10.78	11.45	10.78	11.347	23200.0
2020-11-12	AFIF	ETF	9.77	9.81	9.77	9.81	64688.0
2020-11-12	AFK	ETF	19.34	19.63	19.29	19.36	8539.0
2020-11-12	AFLG	ETF	20.98	21.038	20.98	21.038	900.0
2020-11-12	AFMC	ETF	19.264	19.264	19.264	19.264	100.0
2020-11-12	AFSM	ETF	19.504	19.504	19.504	19.504	100.0
2020-11-12	AFTY	ETF	21.28	21.424	21.227	21.227	3300.0
2020-11-12	AGG	ETF	117.37	117.63	117.33	117.62	7740800.0
2020-11-12	AGGY	ETF	53.55	53.6	53.46	53.6	677900.0
2020-11-12	AGNG	ETF	26.62	26.715	26.418	26.418	3800.0
2020-11-12	AGQ	ETF	44.1	44.73	43.95	44.19	778600.0
2020-11-12	AGZ	ETF	120.7	120.78	120.66	120.78	25688.0
2020-11-12	AGZD	ETF	23.595	23.595	23.485	23.51	49000.0
2020-11-12	AIA	ETF	79.62	80.21	78.7852	78.94	144185.0
2020-11-12	AIEQ	ETF	31.844	31.965	31.51	31.71	23700.0
2020-11-12	AIQ	ETF	24.87	25.05	24.56	24.6003	50024.0
2020-11-12	AIRR	ETF	30.01	30.01	29.394	29.612	8900.0
2020-11-12	AIVI	ETF	38.35	38.39	38.03	38.06	1700.0
2020-11-12	ALTL	ETF	27.25	27.374	26.8147	26.8147	19369.0
2020-11-12	ALTY	ETF	11.17	11.18	11.063	11.09	11700.0
2020-11-12	AMJ	ETF	12.49	12.7433	12.35	12.51	1328930.0
2020-11-12	AMLP	ETF	22.51	22.92	22.16	22.45	3189700.0
2020-11-12	AMNA	ETF	23.3	23.31	22.8006	22.8006	5100.0
2020-11-12	AMND	ETF	24.53	24.63	23.9	24.2203	6001.0
2020-11-12	AMOM	ETF	36.75	36.75	36.298	36.376	1900.0
2020-11-12	AMTR	ETF	26.04	26.28	25.36	25.67	304090.0

> showing 50 of 2,134 rows — these rows as CSV

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