PREVIEW / etf_daily / 2021-09-28

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-28.parquet
  size:    94 KB
  rows:    2,510

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-09-28	SPY	ETF	439.69	440.04	432.94	433.72	130436300.0
2021-09-28	QQQ	ETF	365.67	370.302	359.35	359.87	97701632.0
2021-09-28	IWM	ETF	225.41	225.6	220.85	221.29	39938200.0
2021-09-28	DIA	ETF	347.31	347.82	342.41	342.92	7493800.0
2021-09-28	GLD	ETF	162.73	162.82	161.73	162.05	9282800.0
2021-09-28	TLT	ETF	144.33	145.07	143.64	144.09	26613500.0
2021-09-28	AAA	ETF	25.011	25.03	25.011	25.02	1228.0
2021-09-28	AAAU	ETF	17.32	17.32	17.2	17.24	288100.0
2021-09-28	AADR	ETF	64.3	64.3	63.62	63.64	2000.0
2021-09-28	AAXJ	ETF	85.64	85.77	84.87	85.14	886400.0
2021-09-28	ABEQ	ETF	26.967	26.967	26.939	26.939	1100.0
2021-09-28	ACES	ETF	67.99	68.03	66.51	66.6	67500.0
2021-09-28	ACIO	ETF	30.228	30.26	30.07	30.14	59700.0
2021-09-28	ACSI	ETF	49.98	49.98	49.7946	49.7946	417.0
2021-09-28	ACT	ETF	21.79	21.9402	21.55	21.85	169406.0
2021-09-28	ACTV	ETF	38.39	38.39	38.0928	38.0928	4598.0
2021-09-28	ACTX	ETF	1.0	1.0	1.0	1.0	512.0
2021-09-28	ACVF	ETF	32.67	32.67	32.23	32.28	10800.0
2021-09-28	ACWF	ETF	37.66	37.67	37.2349	37.2349	59057.0
2021-09-28	ACWI	ETF	101.9	102.01	100.57	100.81	6237800.0
2021-09-28	ACWV	ETF	103.41	103.56	102.72	102.86	152600.0
2021-09-28	ACWX	ETF	56.06	56.1	55.5	55.66	2774146.0
2021-09-28	ADFI	ETF	9.68	9.68	9.66	9.675	1300.0
2021-09-28	ADIV	ETF	16.97	16.97	16.9	16.908	500.0
2021-09-28	ADME	ETF	39.97	40.0	39.76	39.76	35300.0
2021-09-28	ADRE	ETF	49.13	49.13	48.15	48.3854	6593.0
2021-09-28	AEMB	ETF	49.188	49.188	49.145	49.145	1100.0
2021-09-28	AESR	ETF	13.94	13.95	13.74	13.79	10800.0
2021-09-28	AFIF	ETF	9.6	9.62	9.6	9.61	20195.0
2021-09-28	AFK	ETF	20.78	20.78	20.51	20.58	4482.0
2021-09-28	AFLG	ETF	25.657	25.657	25.657	25.657	100.0
2021-09-28	AFMC	ETF	25.4	25.54	25.354	25.354	300.0
2021-09-28	AFSM	ETF	26.3	26.3	26.178	26.178	300.0
2021-09-28	AFTY	ETF	20.61	20.61	20.475	20.51	3500.0
2021-09-28	AGG	ETF	114.9	115.0	114.7	114.77	7017100.0
2021-09-28	AGGY	ETF	51.98	52.04	51.92	51.98	84000.0
2021-09-28	AGNG	ETF	29.51	29.52	29.0	29.16	30800.0
2021-09-28	AGOV	ETF	99.25	99.25	99.25	99.25	53.0
2021-09-28	AGOX	ETF	26.23	26.23	25.92	25.92	20400.0
2021-09-28	AGQ	ETF	33.11	33.29	32.35	33.01	1245000.0
2021-09-28	AGZ	ETF	118.255	118.3499	118.19	118.24	19327.0
2021-09-28	AGZD	ETF	23.405	23.45	23.395	23.445	43600.0
2021-09-28	AIA	ETF	79.01	79.2	78.2194	78.41	114565.0
2021-09-28	AIEQ	ETF	42.39	42.39	41.419	41.419	14700.0
2021-09-28	AIQ	ETF	30.88	30.88	30.29	30.52	21068.0
2021-09-28	AIRR	ETF	42.2	42.2	41.26	41.387	47500.0
2021-09-28	AIVI	ETF	41.29	41.29	40.88	40.88	67700.0
2021-09-28	ALTL	ETF	41.63	41.7	41.25	41.33	71570.0
2021-09-28	ALTY	ETF	13.484	13.484	13.31	13.35	14400.0
2021-09-28	AMJ	ETF	18.66	18.69	18.21	18.22	592676.0

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

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