PREVIEW / etf_daily / 2021-10-14

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-14.parquet
  size:    94 KB
  rows:    2,523

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-10-14	SPY	ETF	439.08	442.66	438.58	442.5	70236800.0
2021-10-14	QQQ	ETF	363.69	366.85	363.01	366.63	43433867.0
2021-10-14	IWM	ETF	224.75	226.0	224.32	225.87	18160000.0
2021-10-14	DIA	ETF	347.21	349.22	346.6	349.13	4473900.0
2021-10-14	GLD	ETF	168.19	168.22	167.71	168.0	5081400.0
2021-10-14	TLT	ETF	145.37	145.96	144.95	145.88	12946400.0
2021-10-14	AAA	ETF	25.0	25.0	25.0	25.0	37.0
2021-10-14	AAAU	ETF	17.88	17.9	17.85	17.86	149500.0
2021-10-14	AADR	ETF	64.98	65.36	64.98	65.36	2400.0
2021-10-14	AAXJ	ETF	86.49	86.64	86.06	86.44	718400.0
2021-10-14	ABEQ	ETF	27.72	27.72	27.653	27.653	400.0
2021-10-14	ACES	ETF	71.98	72.0	70.51	70.71	190200.0
2021-10-14	ACIO	ETF	30.53	30.66	30.53	30.66	24100.0
2021-10-14	ACSI	ETF	50.55	50.582	50.55	50.582	489.0
2021-10-14	ACT	ETF	20.99	21.6	20.85	21.32	573558.0
2021-10-14	ACTV	ETF	39.0099	39.11	38.8947	39.0534	6781.0
2021-10-14	ACTX	ETF	1.0	1.0	0.8775	0.8775	3246.0
2021-10-14	ACVF	ETF	32.98	33.06	32.8	33.01	24300.0
2021-10-14	ACWF	ETF	37.33	37.583	37.33	37.583	2626.0
2021-10-14	ACWI	ETF	102.36	102.86	102.19	102.79	3027500.0
2021-10-14	ACWV	ETF	104.01	104.46	104.0	104.36	206000.0
2021-10-14	ACWX	ETF	56.61	56.68	56.475	56.64	1098264.0
2021-10-14	ADFI	ETF	9.68	9.68	9.675	9.675	1200.0
2021-10-14	ADIV	ETF	17.226	17.226	17.226	17.226	100.0
2021-10-14	ADME	ETF	40.3	40.49	40.3	40.49	22100.0
2021-10-14	ADRE	ETF	50.48	50.48	49.8701	50.1901	11231.0
2021-10-14	AESR	ETF	13.95	13.983	13.94	13.98	25600.0
2021-10-14	AFIF	ETF	9.64	9.65	9.63	9.64	8406.0
2021-10-14	AFK	ETF	21.55	21.95	21.55	21.7366	15428.0
2021-10-14	AFLG	ETF	26.072	26.072	26.072	26.072	100.0
2021-10-14	AFTY	ETF	21.34	21.417	21.32	21.417	7200.0
2021-10-14	AGG	ETF	114.7	114.85	114.63	114.85	4094500.0
2021-10-14	AGGY	ETF	51.95	52.055	51.942	52.045	112200.0
2021-10-14	AGNG	ETF	29.197	29.209	29.13	29.134	3000.0
2021-10-14	AGOV	ETF	99.0557	99.295	99.0557	99.295	1119.0
2021-10-14	AGOX	ETF	26.38	26.5	26.35	26.46	19500.0
2021-10-14	AGQ	ETF	35.65	36.32	35.2	36.21	758700.0
2021-10-14	AGZ	ETF	118.25	118.3546	118.21	118.34	16398.0
2021-10-14	AGZD	ETF	23.425	23.48	23.425	23.44	17000.0
2021-10-14	AIA	ETF	79.97	79.97	79.41	79.8	73499.0
2021-10-14	AIEQ	ETF	42.58	42.76	42.4	42.644	18000.0
2021-10-14	AIQ	ETF	31.08	31.4	31.08	31.375	35138.0
2021-10-14	AIRR	ETF	41.86	42.21	41.69	42.14	8300.0
2021-10-14	AIVI	ETF	41.57	41.66	41.57	41.63	2700.0
2021-10-14	ALTL	ETF	41.96	42.22	41.93	42.22	28222.0
2021-10-14	ALTY	ETF	13.44	13.55	13.44	13.549	12700.0
2021-10-14	AMJ	ETF	19.53	19.77	19.48	19.77	478884.0
2021-10-14	AMLP	ETF	36.07	36.42	35.88	36.42	2044700.0
2021-10-14	AMNA	ETF	35.538	35.538	35.538	35.538	0.0
2021-10-14	AMND	ETF	36.6	36.6364	36.6	36.6364	1028.0

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

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