PREVIEW / etf_daily / 2020-07-28

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-28.parquet
  size:    78 KB
  rows:    2,052

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-07-28	SPY	ETF	322.43	323.64	320.85	321.17	57495000.0
2020-07-28	QQQ	ETF	259.33	259.85	256.51	256.81	31302390.0
2020-07-28	IWM	ETF	147.07	148.04	146.06	146.13	13268000.0
2020-07-28	DIA	ETF	264.92	265.61	263.63	263.93	1989300.0
2020-07-28	GLD	ETF	182.02	184.26	181.42	183.75	21164600.0
2020-07-28	TLT	ETF	169.54	170.34	169.43	170.28	8520700.0
2020-07-28	AAAU	ETF	19.34	19.55	19.27	19.53	492200.0
2020-07-28	AADR	ETF	57.99	58.29	57.9	57.95	4900.0
2020-07-28	AAXJ	ETF	75.05	75.13	74.49	74.58	1333500.0
2020-07-28	ABEQ	ETF	23.3	23.31	23.227	23.227	6800.0
2020-07-28	ACES	ETF	46.0	46.03	45.07	45.13	37800.0
2020-07-28	ACIO	ETF	26.05	26.05	25.87	25.9	29800.0
2020-07-28	ACSI	ETF	35.01	35.01	34.9184	34.9184	729.0
2020-07-28	ACTX	ETF	2.4279	2.9117	2.183	2.9117	623.0
2020-07-28	ACWF	ETF	29.26	29.3412	29.1431	29.1431	14234.0
2020-07-28	ACWI	ETF	77.73	78.02	77.42	77.49	1605600.0
2020-07-28	ACWV	ETF	91.21	91.62	91.0	91.23	973600.0
2020-07-28	ACWX	ETF	45.86	45.98	45.73	45.74	1080523.0
2020-07-28	ADME	ETF	33.51	33.51	33.088	33.088	29800.0
2020-07-28	ADRE	ETF	45.69	45.71	45.22	45.22	5626.0
2020-07-28	AESR	ETF	10.41	10.42	10.328	10.328	20900.0
2020-07-28	AFIF	ETF	9.8392	9.88	9.83	9.845	29627.0
2020-07-28	AFK	ETF	17.88	17.88	17.4	17.5797	5562.0
2020-07-28	AFLG	ETF	19.537	19.537	19.537	19.537	100.0
2020-07-28	AFSM	ETF	17.34	17.34	17.34	17.34	200.0
2020-07-28	AFTY	ETF	18.35	18.389	18.343	18.343	1300.0
2020-07-28	AGG	ETF	119.3	119.35	119.22	119.28	6080700.0
2020-07-28	AGGY	ETF	54.37	54.42	54.28	54.42	154300.0
2020-07-28	AGQ	ETF	48.44	51.41	47.35	50.42	4364800.0
2020-07-28	AGZ	ETF	121.72	121.74	121.58	121.73	29824.0
2020-07-28	AGZD	ETF	23.51	23.55	23.49	23.52	20200.0
2020-07-28	AIA	ETF	70.44	70.485	69.75	69.75	40857.0
2020-07-28	AIEQ	ETF	29.84	30.0	29.75	29.75	12300.0
2020-07-28	AIQ	ETF	21.76	21.7954	21.571	21.585	7073.0
2020-07-28	AIRR	ETF	24.68	24.7	24.413	24.413	4400.0
2020-07-28	AIVI	ETF	36.86	37.06	36.86	36.89	6600.0
2020-07-28	ALTL	ETF	24.9	24.9076	24.7042	24.7042	3606.0
2020-07-28	ALTY	ETF	10.661	10.71	10.661	10.7	1500.0
2020-07-28	AMJ	ETF	12.75	12.87	12.71	12.71	733676.0
2020-07-28	AMLP	ETF	23.64	23.9	23.57	23.62	2672200.0
2020-07-28	AMNA	ETF	23.53	23.56	23.4256	23.4256	6000.0
2020-07-28	AMND	ETF	24.6282	24.6282	24.6282	24.6282	0.0
2020-07-28	AMOM	ETF	32.71	32.71	32.096	32.096	3700.0
2020-07-28	AMUB	ETF	8.02	8.04	8.0	8.0086	8958.0
2020-07-28	AMZA	ETF	16.81	17.032	16.78	16.81	24800.0
2020-07-28	ANGL	ETF	30.25	30.25	30.07	30.07	1752200.0
2020-07-28	AOA	ETF	56.91	57.05	56.75	56.75	28800.0
2020-07-28	AOK	ETF	37.22	37.22	37.05	37.0895	67858.0
2020-07-28	AOM	ETF	40.82	40.82	40.67	40.67	96908.0
2020-07-28	AOR	ETF	47.81	47.829	47.62	47.66	57841.0

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

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