PREVIEW / etf_daily / 2020-08-28

all etf daily files

  file:    by_date/etf_daily/2020/2020-08-28.parquet
  size:    79 KB
  rows:    2,076

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-08-28	SPY	ETF	349.44	350.72	348.15	350.58	48588900.0
2020-08-28	QQQ	ETF	292.27	293.18	290.93	292.53	28021022.0
2020-08-28	IWM	ETF	156.6	157.2	155.73	157.12	12371400.0
2020-08-28	DIA	ETF	286.23	287.45	285.0	286.7	2715500.0
2020-08-28	GLD	ETF	183.98	185.4	183.4	184.39	13200800.0
2020-08-28	TLT	ETF	161.77	162.05	160.64	161.12	8415400.0
2020-08-28	AAAU	ETF	19.51	19.66	19.46	19.57	566500.0
2020-08-28	AADR	ETF	56.97	57.06	56.87	56.99	1200.0
2020-08-28	AAXJ	ETF	78.93	79.37	78.81	79.29	656500.0
2020-08-28	ABEQ	ETF	23.57	23.77	23.55	23.765	3200.0
2020-08-28	ACES	ETF	53.3	53.57	53.01	53.31	66800.0
2020-08-28	ACIO	ETF	27.56	27.56	27.22	27.38	36800.0
2020-08-28	ACSI	ETF	38.48	38.5516	38.45	38.5516	2779.0
2020-08-28	ACTX	ETF	2.1889	2.773	2.1889	2.773	3179.0
2020-08-28	ACWF	ETF	30.425	30.57	30.41	30.5344	15710.0
2020-08-28	ACWI	ETF	82.6	82.88	82.36	82.85	2744400.0
2020-08-28	ACWV	ETF	93.29	93.5	92.96	93.43	127700.0
2020-08-28	ACWX	ETF	47.34	47.44	47.12	47.43	649503.0
2020-08-28	ADFI	ETF	9.981	9.981	9.981	9.981	100.0
2020-08-28	ADME	ETF	35.54	35.54	35.187	35.24	12600.0
2020-08-28	ADRE	ETF	47.5	48.085	47.5	48.085	5114.0
2020-08-28	AESR	ETF	11.28	11.356	11.28	11.356	8500.0
2020-08-28	AFIF	ETF	9.84	9.84	9.8	9.8157	19155.0
2020-08-28	AFK	ETF	17.59	17.9599	17.59	17.81	8445.0
2020-08-28	AFLG	ETF	20.92	20.97	20.92	20.97	3900.0
2020-08-28	AFMC	ETF	18.42	18.503	18.42	18.503	100.0
2020-08-28	AFSM	ETF	18.57	18.618	18.57	18.618	100.0
2020-08-28	AFTY	ETF	19.87	19.87	19.8	19.85	2800.0
2020-08-28	AGG	ETF	118.08	118.16	117.99	118.11	6467400.0
2020-08-28	AGGY	ETF	53.75	53.83	53.74	53.82	556500.0
2020-08-28	AGNG	ETF	25.65	25.66	25.535	25.61	8400.0
2020-08-28	AGQ	ETF	60.47	61.48	59.9	60.54	2075900.0
2020-08-28	AGZ	ETF	121.21	121.25	120.96	121.16	33852.0
2020-08-28	AGZD	ETF	23.48	23.55	23.465	23.51	8400.0
2020-08-28	AIA	ETF	73.14	73.47	73.05	73.47	142349.0
2020-08-28	AIEQ	ETF	31.74	31.74	31.498	31.59	14800.0
2020-08-28	AIQ	ETF	24.06	24.175	24.03	24.1429	34328.0
2020-08-28	AIRR	ETF	26.973	27.072	26.95	27.072	600.0
2020-08-28	AIVI	ETF	37.04	37.26	37.04	37.24	6400.0
2020-08-28	ALTL	ETF	25.3748	25.48	25.3483	25.48	8288.0
2020-08-28	ALTY	ETF	10.98	11.04	10.92	11.025	20800.0
2020-08-28	AMJ	ETF	12.41	12.8	12.41	12.73	532393.0
2020-08-28	AMLP	ETF	23.08	23.66	22.98	23.53	2050700.0
2020-08-28	AMNA	ETF	24.37	24.65	24.29	24.6063	4000.0
2020-08-28	AMND	ETF	25.92	25.9458	25.92	25.9458	200.0
2020-08-28	AMOM	ETF	36.58	36.58	36.05	36.15	13200.0
2020-08-28	AMUB	ETF	7.86	8.015	7.85	8.015	25824.0
2020-08-28	AMZA	ETF	16.65	17.19	16.512	17.11	107400.0
2020-08-28	ANGL	ETF	30.58	30.58	30.49	30.52	613400.0
2020-08-28	AOA	ETF	59.55	59.72	59.43	59.62	43100.0

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

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