PREVIEW / etf_daily / 2020-11-11

all etf daily files

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

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-11	SPY	ETF	356.4	357.56	355.06	356.67	58649000.0
2020-11-11	QQQ	ETF	285.92	290.25	283.38	289.76	36102931.0
2020-11-11	IWM	ETF	173.34	173.48	170.86	172.63	23972600.0
2020-11-11	DIA	ETF	296.07	296.14	292.93	294.11	2910400.0
2020-11-11	GLD	ETF	174.7	175.28	174.44	174.9	9008500.0
2020-11-11	TLT	ETF	155.02	155.94	154.97	155.72	5888200.0
2020-11-11	AAA	ETF	24.93	24.93	24.93	24.93	62.0
2020-11-11	AAAU	ETF	18.55	18.59	18.51	18.57	527300.0
2020-11-11	AADR	ETF	57.04	57.04	56.6	56.93	2700.0
2020-11-11	AAXJ	ETF	83.06	83.83	82.89	83.72	989100.0
2020-11-11	ABEQ	ETF	24.13	24.55	24.13	24.436	6600.0
2020-11-11	ACES	ETF	61.38	62.58	61.2	62.47	72100.0
2020-11-11	ACIO	ETF	27.15	27.69	27.15	27.365	85400.0
2020-11-11	ACSI	ETF	40.9557	40.9557	40.9557	40.9557	130.0
2020-11-11	ACTV	ETF	27.355	27.3824	27.25	27.3824	1685.0
2020-11-11	ACTX	ETF	2.01	2.9	2.01	2.7	1353.0
2020-11-11	ACVF	ETF	26.51	26.51	26.457	26.457	400.0
2020-11-11	ACWF	ETF	31.745	31.865	31.74	31.8	3126.0
2020-11-11	ACWI	ETF	85.55	85.88	85.4	85.79	4449400.0
2020-11-11	ACWV	ETF	95.96	96.31	95.79	96.15	770300.0
2020-11-11	ACWX	ETF	49.78	49.97	49.71	49.95	1092187.0
2020-11-11	ADFI	ETF	9.91	9.91	9.91	9.91	100.0
2020-11-11	ADME	ETF	34.89	35.21	34.89	35.001	60500.0
2020-11-11	ADRE	ETF	51.28	51.91	51.28	51.7	11885.0
2020-11-11	AESR	ETF	11.38	11.457	11.38	11.437	700.0
2020-11-11	AFIF	ETF	9.7775	9.79	9.7775	9.7786	4634.0
2020-11-11	AFK	ETF	19.46	19.49	19.25	19.3469	13084.0
2020-11-11	AFLG	ETF	21.211	21.26	21.211	21.26	1200.0
2020-11-11	AFSM	ETF	19.801	19.801	19.801	19.801	100.0
2020-11-11	AFTY	ETF	21.28	21.433	21.28	21.404	2300.0
2020-11-11	AGG	ETF	117.06	117.18	117.02	117.13	3044300.0
2020-11-11	AGGY	ETF	53.35	53.39	53.26	53.39	82300.0
2020-11-11	AGNG	ETF	26.729	26.76	26.647	26.74	5500.0
2020-11-11	AGQ	ETF	42.85	44.21	42.7	44.05	833200.0
2020-11-11	AGZ	ETF	120.43	120.4718	120.32	120.38	22317.0
2020-11-11	AGZD	ETF	23.5	23.6	23.5	23.51	16600.0
2020-11-11	AIA	ETF	78.74	79.75	78.58	79.58	193437.0
2020-11-11	AIEQ	ETF	31.23	31.7	31.15	31.62	23400.0
2020-11-11	AIQ	ETF	24.51	24.87	24.485	24.86	26594.0
2020-11-11	AIRR	ETF	30.76	30.76	29.918	30.196	14100.0
2020-11-11	AIVI	ETF	38.64	38.67	38.54	38.66	11200.0
2020-11-11	ALTL	ETF	27.66	27.77	27.61	27.61	5255.0
2020-11-11	ALTY	ETF	11.201	11.25	11.164	11.22	7100.0
2020-11-11	AMJ	ETF	13.0	13.0	12.55	12.7	987404.0
2020-11-11	AMLP	ETF	23.97	23.99	23.23	23.52	3632100.0
2020-11-11	AMNA	ETF	23.4247	23.4247	23.4247	23.4247	0.0
2020-11-11	AMND	ETF	24.95	25.04	24.62	24.7336	34400.0
2020-11-11	AMOM	ETF	36.54	36.588	36.53	36.588	1400.0
2020-11-11	AMTR	ETF	26.34	26.49	26.23	26.39	36401.0
2020-11-11	AMUB	ETF	8.04	8.045	7.9	7.96	9079.0

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

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