PREVIEW / etf_daily / 2020-11-06

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-06.parquet
  size:    80 KB
  rows:    2,125

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-06	SPY	ETF	349.93	351.51	347.65	350.16	74973000.0
2020-11-06	QQQ	ETF	293.58	295.36	289.83	294.61	40959764.0
2020-11-06	IWM	ETF	165.62	165.71	163.3	163.62	24930400.0
2020-11-06	DIA	ETF	283.95	284.38	281.89	283.22	3078200.0
2020-11-06	GLD	ETF	183.4	183.53	182.19	183.19	10378300.0
2020-11-06	TLT	ETF	159.62	159.92	158.94	159.41	12408400.0
2020-11-06	AAA	ETF	24.885	24.885	24.885	24.885	3.0
2020-11-06	AAAU	ETF	19.47	19.48	19.34	19.45	427300.0
2020-11-06	AADR	ETF	59.3	59.6	59.25	59.6	3900.0
2020-11-06	AAXJ	ETF	83.53	84.09	83.16	83.81	1856700.0
2020-11-06	ABEQ	ETF	23.86	23.897	23.8	23.811	5600.0
2020-11-06	ACES	ETF	61.31	61.92	60.67	61.31	95200.0
2020-11-06	ACIO	ETF	27.2	27.31	26.95	27.31	63300.0
2020-11-06	ACSI	ETF	40.3934	40.3934	40.3934	40.3934	156.0
2020-11-06	ACTV	ETF	26.31	26.31	25.9582	25.9582	7367.0
2020-11-06	ACTX	ETF	2.1	2.98	2.1	2.75	1285.0
2020-11-06	ACVF	ETF	25.995	26.04	25.995	26.003	1100.0
2020-11-06	ACWF	ETF	31.29	31.43	31.2701	31.35	14914.0
2020-11-06	ACWI	ETF	83.9	84.23	83.43	83.93	2643200.0
2020-11-06	ACWV	ETF	94.02	94.58	93.92	94.25	112800.0
2020-11-06	ACWX	ETF	48.4	48.58	48.22	48.43	1365109.0
2020-11-06	ADME	ETF	34.64	35.06	34.64	34.99	29100.0
2020-11-06	ADRE	ETF	51.72	52.5	51.61	52.38	8084.0
2020-11-06	AESR	ETF	11.32	11.396	11.32	11.382	3300.0
2020-11-06	AFIF	ETF	9.77	9.816	9.77	9.8	26108.0
2020-11-06	AFK	ETF	19.25	19.25	19.045	19.0822	3621.0
2020-11-06	AFLG	ETF	21.07	21.09	21.05	21.09	5400.0
2020-11-06	AFMC	ETF	19.097	19.097	19.097	19.097	200.0
2020-11-06	AFTY	ETF	21.375	21.41	21.361	21.361	300.0
2020-11-06	AGG	ETF	117.81	117.86	117.67	117.8	5929700.0
2020-11-06	AGGY	ETF	53.8	53.8	53.706	53.77	92100.0
2020-11-06	AGNG	ETF	26.34	26.34	26.185	26.185	2900.0
2020-11-06	AGQ	ETF	50.26	50.43	48.41	49.74	1728900.0
2020-11-06	AGZ	ETF	120.84	120.84	120.71	120.82	17322.0
2020-11-06	AGZD	ETF	23.455	23.56	23.45	23.51	30600.0
2020-11-06	AIA	ETF	79.63	79.995	79.32	79.8	135460.0
2020-11-06	AIEQ	ETF	32.43	32.59	32.04	32.51	51000.0
2020-11-06	AIQ	ETF	25.3	25.54	25.15	25.52	38282.0
2020-11-06	AIRR	ETF	28.29	28.31	27.87	27.89	9800.0
2020-11-06	AIVI	ETF	36.58	36.67	36.5	36.61	4000.0
2020-11-06	ALTL	ETF	25.16	25.16	25.0	25.0822	9799.0
2020-11-06	ALTY	ETF	10.79	10.79	10.63	10.663	14000.0
2020-11-06	AMJ	ETF	11.85	11.87	11.325	11.34	928990.0
2020-11-06	AMLP	ETF	21.82	22.0	20.95	21.0	3221900.0
2020-11-06	AMNA	ETF	21.06	21.1	21.0494	21.0494	300.0
2020-11-06	AMND	ETF	22.3024	22.3024	22.3024	22.3024	0.0
2020-11-06	AMOM	ETF	37.95	38.14	37.95	38.135	2300.0
2020-11-06	AMTR	ETF	24.23	24.23	23.63	23.65	22801.0
2020-11-06	AMUB	ETF	7.329	7.329	7.159	7.159	527.0
2020-11-06	AMZA	ETF	14.6	14.82	13.85	13.91	126900.0

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

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