PREVIEW / etf_daily / 2020-11-10

all etf daily files

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

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-10	SPY	ETF	353.49	355.18	350.51	354.04	85552000.0
2020-11-10	QQQ	ETF	285.26	286.6599	280.62	283.42	69024878.0
2020-11-10	IWM	ETF	171.2	173.33	169.75	172.7	35492200.0
2020-11-10	DIA	ETF	293.3	294.96	291.4	294.51	4354500.0
2020-11-10	GLD	ETF	176.75	176.91	175.66	175.66	11728500.0
2020-11-10	TLT	ETF	154.96	155.81	154.78	155.16	12561000.0
2020-11-10	AAA	ETF	24.94	24.94	24.92	24.92	1899.0
2020-11-10	AAAU	ETF	18.77	18.78	18.65	18.66	457100.0
2020-11-10	AADR	ETF	57.07	57.07	56.04	56.04	3500.0
2020-11-10	AAXJ	ETF	83.85	83.99	82.76	83.2	1832500.0
2020-11-10	ABEQ	ETF	24.58	24.621	24.58	24.619	13100.0
2020-11-10	ACES	ETF	62.0	62.0	59.73	60.27	58600.0
2020-11-10	ACIO	ETF	27.45	27.45	27.15	27.21	24000.0
2020-11-10	ACSI	ETF	40.5673	40.5673	40.5673	40.5673	289.0
2020-11-10	ACTV	ETF	27.15	27.55	27.15	27.34	371460.0
2020-11-10	ACTX	ETF	1.99	2.75	1.99	2.35	3935.0
2020-11-10	ACVF	ETF	26.258	26.258	26.247	26.247	100.0
2020-11-10	ACWF	ETF	31.43	31.55	31.41	31.4938	2635.0
2020-11-10	ACWI	ETF	85.17	85.43	84.44	85.08	14894200.0
2020-11-10	ACWV	ETF	95.18	95.76	94.96	95.55	290800.0
2020-11-10	ACWX	ETF	49.59	49.82	49.3699	49.55	1015362.0
2020-11-10	ADME	ETF	34.56	34.71	34.555	34.656	18800.0
2020-11-10	ADRE	ETF	51.65	51.67	50.36	50.94	19526.0
2020-11-10	AESR	ETF	11.37	11.37	11.304	11.304	4800.0
2020-11-10	AFIF	ETF	9.765	9.78	9.75	9.76	22089.0
2020-11-10	AFK	ETF	19.13	19.51	19.13	19.25	5715.0
2020-11-10	AFSM	ETF	19.73	19.73	19.73	19.73	100.0
2020-11-10	AFTY	ETF	21.45	21.64	21.45	21.54	4300.0
2020-11-10	AGG	ETF	117.05	117.23	117.03	117.06	5146300.0
2020-11-10	AGGY	ETF	53.35	53.403	53.3	53.34	179400.0
2020-11-10	AGNG	ETF	26.77	26.817	26.595	26.718	4000.0
2020-11-10	AGQ	ETF	44.47	45.08	43.6	43.73	1510500.0
2020-11-10	AGZ	ETF	120.42	120.4599	120.29	120.44	26041.0
2020-11-10	AGZD	ETF	23.585	23.59	23.495	23.495	25400.0
2020-11-10	AIA	ETF	79.26	79.68	78.59	78.85	273683.0
2020-11-10	AIEQ	ETF	31.2	31.2	30.33	30.94	36800.0
2020-11-10	AIQ	ETF	25.83	25.83	24.11	24.34	54253.0
2020-11-10	AIRR	ETF	29.77	30.65	29.77	30.484	12700.0
2020-11-10	AIVI	ETF	38.09	38.45	38.09	38.32	19700.0
2020-11-10	ALTL	ETF	27.92	27.991	27.82	27.991	6989.0
2020-11-10	ALTY	ETF	11.088	11.234	11.088	11.205	11200.0
2020-11-10	AMJ	ETF	12.41	12.845	12.36	12.73	1068101.0
2020-11-10	AMLP	ETF	23.24	23.85	22.88	23.64	5855900.0
2020-11-10	AMNA	ETF	23.3322	23.3322	23.3322	23.3322	2.0
2020-11-10	AMND	ETF	24.79	24.79	24.76	24.77	5100.0
2020-11-10	AMOM	ETF	36.0	36.0	35.482	35.482	700.0
2020-11-10	AMTR	ETF	25.45	26.35	25.43	26.27	278646.0
2020-11-10	AMUB	ETF	7.74	8.03	7.74	8.02	14837.0
2020-11-10	AMZA	ETF	16.06	16.52	15.91	16.49	101800.0
2020-11-10	ANEW	ETF	38.78	38.78	38.19	38.56	21100.0

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

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