PREVIEW / etf_daily / 2021-04-14

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-14.parquet
  size:    88 KB
  rows:    2,324

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
2021-04-14	SPY	ETF	412.83	413.96	410.87	411.45	61659900.0
2021-04-14	QQQ	ETF	340.85	340.98	335.67	336.51	42564337.0
2021-04-14	IWM	ETF	221.87	226.0	221.8	223.32	27362000.0
2021-04-14	DIA	ETF	336.81	339.11	336.74	337.53	3966800.0
2021-04-14	GLD	ETF	162.77	163.05	162.3	162.72	6312300.0
2021-04-14	TLT	ETF	138.03	138.24	137.57	138.04	7293200.0
2021-04-14	AAA	ETF	25.05	25.05	25.04	25.04	195.0
2021-04-14	AAAU	ETF	17.3	17.32	17.25	17.28	205500.0
2021-04-14	AADR	ETF	63.95	63.95	63.36	63.36	3000.0
2021-04-14	AAXJ	ETF	93.81	93.86	93.17	93.32	693500.0
2021-04-14	ABEQ	ETF	26.75	26.98	26.75	26.93	5300.0
2021-04-14	ACES	ETF	75.84	76.6	74.77	74.77	78300.0
2021-04-14	ACIO	ETF	29.42	29.42	29.16	29.195	22500.0
2021-04-14	ACSI	ETF	48.0826	48.0826	48.0826	48.0826	467.0
2021-04-14	ACTV	ETF	36.78	36.78	36.2547	36.2547	5693.0
2021-04-14	ACVF	ETF	31.06	31.06	30.69	30.921	2600.0
2021-04-14	ACWF	ETF	37.38	37.5	37.32	37.35	22493.0
2021-04-14	ACWI	ETF	98.51	98.78	98.17	98.36	2972900.0
2021-04-14	ACWV	ETF	100.27	100.33	100.01	100.2	109500.0
2021-04-14	ACWX	ETF	56.52	56.69	56.41	56.46	1046522.0
2021-04-14	ADFI	ETF	9.69	9.695	9.681	9.681	400.0
2021-04-14	ADIV	ETF	18.75	18.75	18.75	18.75	300.0
2021-04-14	ADME	ETF	38.2	38.27	37.97	37.97	22200.0
2021-04-14	ADRE	ETF	56.8777	57.0615	56.3001	56.36	14228.0
2021-04-14	AESR	ETF	13.16	13.195	13.06	13.061	35900.0
2021-04-14	AFIF	ETF	9.78	9.78	9.69	9.705	37672.0
2021-04-14	AFK	ETF	21.47	21.53	21.45	21.5	11373.0
2021-04-14	AFLG	ETF	24.658	24.658	24.658	24.658	200.0
2021-04-14	AFMC	ETF	25.0	25.0	24.88	24.88	300.0
2021-04-14	AFSM	ETF	25.742	25.742	25.742	25.742	100.0
2021-04-14	AFTY	ETF	22.038	22.05	21.981	21.981	5300.0
2021-04-14	AGG	ETF	114.41	114.44	114.28	114.39	3620500.0
2021-04-14	AGGY	ETF	51.74	51.75	51.68	51.71	65000.0
2021-04-14	AGNG	ETF	28.5	28.5	28.34	28.36	4200.0
2021-04-14	AGQ	ETF	43.84	44.69	43.84	44.41	310300.0
2021-04-14	AGZ	ETF	117.97	118.0899	117.97	118.01	36284.0
2021-04-14	AGZD	ETF	23.585	23.595	23.55	23.57	26400.0
2021-04-14	AIA	ETF	93.87	94.06	93.22	93.26	338012.0
2021-04-14	AIEQ	ETF	39.51	40.0	39.35	39.39	30200.0
2021-04-14	AIQ	ETF	30.0	30.01	29.52	29.52	22493.0
2021-04-14	AIRR	ETF	40.96	41.542	40.96	41.25	45500.0
2021-04-14	AIVI	ETF	42.96	43.06	42.94	42.95	6600.0
2021-04-14	ALTL	ETF	39.5	40.46	39.5	40.01	14344.0
2021-04-14	ALTY	ETF	13.08	13.08	13.005	13.059	8900.0
2021-04-14	AMJ	ETF	16.8	17.13	16.8	17.03	498184.0
2021-04-14	AMLP	ETF	31.09	31.63	31.09	31.49	2188200.0
2021-04-14	AMNA	ETF	29.9794	29.9794	29.9794	29.9794	6.0
2021-04-14	AMND	ETF	31.8788	31.8788	31.8788	31.8788	0.0
2021-04-14	AMOM	ETF	36.4	36.4	34.701	34.76	278800.0
2021-04-14	AMPS	ETF	10.01	10.05	10.0	10.006	28774.0

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

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