PREVIEW / etf_daily / 2021-08-20

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-20.parquet
  size:    92 KB
  rows:    2,430

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-08-20	SPY	ETF	440.23	443.71	439.71	443.36	72008700.0
2021-08-20	QQQ	ETF	365.06	368.14	364.74	367.73	39486034.0
2021-08-20	IWM	ETF	212.1	216.02	211.42	215.52	31759500.0
2021-08-20	DIA	ETF	348.98	351.75	348.53	351.16	3394800.0
2021-08-20	GLD	ETF	166.8	167.14	166.36	166.7	7154000.0
2021-08-20	TLT	ETF	150.59	150.81	150.11	150.55	12388400.0
2021-08-20	AAA	ETF	25.01	25.015	25.01	25.015	651.0
2021-08-20	AAAU	ETF	17.75	17.77	17.69	17.73	135800.0
2021-08-20	AAXJ	ETF	83.44	84.18	83.32	84.02	842000.0
2021-08-20	ABEQ	ETF	27.637	27.66	27.62	27.63	5100.0
2021-08-20	ACES	ETF	66.37	67.609	66.37	67.54	40500.0
2021-08-20	ACIO	ETF	30.702	30.76	30.7	30.72	52400.0
2021-08-20	ACSI	ETF	51.152	51.152	51.152	51.152	0.0
2021-08-20	ACTV	ETF	37.21	37.54	37.2	37.5188	2916.0
2021-08-20	ACTX	ETF	1.48	1.48	1.0	1.0	1315.0
2021-08-20	ACVF	ETF	32.94	33.43	32.791	33.11	59800.0
2021-08-20	ACWF	ETF	37.81	38.11	37.81	38.0919	4689.0
2021-08-20	ACWI	ETF	101.33	102.12	101.21	102.02	2399900.0
2021-08-20	ACWV	ETF	105.6	106.37	105.56	106.26	81000.0
2021-08-20	ACWX	ETF	55.37	55.855	55.37	55.83	1144988.0
2021-08-20	ADFI	ETF	9.74	9.74	9.723	9.723	1100.0
2021-08-20	ADIV	ETF	17.918	17.918	17.918	17.918	1400.0
2021-08-20	ADME	ETF	40.457	40.644	40.457	40.644	22200.0
2021-08-20	ADRE	ETF	48.32	48.7825	48.1268	48.3	24710.0
2021-08-20	AESR	ETF	13.95	14.03	13.95	14.02	16600.0
2021-08-20	AFIF	ETF	9.675	9.69	9.66	9.675	4239.0
2021-08-20	AFK	ETF	21.0	21.0	20.79	20.89	7549.0
2021-08-20	AFLG	ETF	26.27	26.311	26.25	26.311	2900.0
2021-08-20	AFMC	ETF	25.38	25.386	25.38	25.386	400.0
2021-08-20	AFSM	ETF	25.669	25.669	25.669	25.669	1700.0
2021-08-20	AFTY	ETF	19.81	19.92	19.81	19.92	2000.0
2021-08-20	AGG	ETF	116.18	116.21	116.08	116.16	2897800.0
2021-08-20	AGGY	ETF	52.76	52.77	52.69	52.738	70500.0
2021-08-20	AGNG	ETF	30.63	30.93	30.582	30.638	8100.0
2021-08-20	AGOV	ETF	99.65	100.08	99.65	99.75	3055.0
2021-08-20	AGOX	ETF	25.65	25.785	25.619	25.715	62700.0
2021-08-20	AGQ	ETF	35.42	35.71	34.56	35.07	825400.0
2021-08-20	AGZ	ETF	119.3	119.3	119.16	119.17	15470.0
2021-08-20	AGZD	ETF	23.4	23.43	23.4	23.42	9600.0
2021-08-20	AIA	ETF	77.93	78.71	77.85	78.33	115558.0
2021-08-20	AIEQ	ETF	40.97	41.38	40.85	41.38	20100.0
2021-08-20	AIQ	ETF	30.0	30.25	30.0	30.2	25546.0
2021-08-20	AIRR	ETF	40.55	41.35	40.55	41.3	42800.0
2021-08-20	AIVI	ETF	42.94	42.94	42.89	42.92	1300.0
2021-08-20	ALTL	ETF	43.93	43.93	43.47	43.75	33755.0
2021-08-20	ALTY	ETF	13.5	13.6	13.5	13.55	19600.0
2021-08-20	AMJ	ETF	17.23	17.48	17.15	17.35	350384.0
2021-08-20	AMLP	ETF	31.04	31.61	30.9	31.49	2004800.0
2021-08-20	AMNA	ETF	30.7764	30.7764	30.7764	30.7764	0.0
2021-08-20	AMND	ETF	32.4155	32.4155	32.4155	32.4155	12.0

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

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