PREVIEW / etf_daily / 2020-07-31

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-31.parquet
  size:    77 KB
  rows:    2,051

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-31	SPY	ETF	325.9	326.63	321.33	326.52	84986800.0
2020-07-31	QQQ	ETF	265.83	265.95	260.85	265.79	53756159.0
2020-07-31	IWM	ETF	148.14	148.42	144.67	147.36	29881500.0
2020-07-31	DIA	ETF	263.76	264.49	260.18	264.35	3306800.0
2020-07-31	GLD	ETF	184.51	185.75	184.17	185.43	15876700.0
2020-07-31	TLT	ETF	170.15	171.46	169.94	171.0	8886000.0
2020-07-31	AAAU	ETF	19.58	19.7	19.53	19.69	477800.0
2020-07-31	AADR	ETF	57.3	57.3	56.49	56.78	2800.0
2020-07-31	AAXJ	ETF	75.15	75.21	74.17	74.84	569600.0
2020-07-31	ABEQ	ETF	23.15	23.176	23.12	23.176	1000.0
2020-07-31	ACES	ETF	45.98	45.98	44.59	45.19	54700.0
2020-07-31	ACIO	ETF	26.46	26.46	25.86	26.068	6300.0
2020-07-31	ACSI	ETF	35.65	35.782	35.3919	35.782	576.0
2020-07-31	ACTX	ETF	3.009	3.4161	2.1358	3.4161	1202.0
2020-07-31	ACWF	ETF	29.41	29.41	28.93	29.2574	10990.0
2020-07-31	ACWI	ETF	78.02	78.03	76.75	77.67	4089200.0
2020-07-31	ACWV	ETF	90.97	91.0	90.08	91.0	252200.0
2020-07-31	ACWX	ETF	45.57	45.57	44.67	44.98	1490902.0
2020-07-31	ADME	ETF	33.49	33.609	33.3	33.609	5900.0
2020-07-31	ADRE	ETF	45.74	45.74	45.1	45.36	5945.0
2020-07-31	AESR	ETF	10.41	10.51	10.375	10.51	10500.0
2020-07-31	AFIF	ETF	9.86	9.87	9.83	9.87	15137.0
2020-07-31	AFK	ETF	17.7	17.8	17.15	17.1927	7273.0
2020-07-31	AFLG	ETF	19.85	19.85	19.85	19.85	100.0
2020-07-31	AFMC	ETF	17.826	17.826	17.826	17.826	100.0
2020-07-31	AFSM	ETF	17.646	17.646	17.646	17.646	100.0
2020-07-31	AFTY	ETF	18.7	18.7	18.655	18.655	700.0
2020-07-31	AGG	ETF	119.45	119.63	119.4	119.56	5277900.0
2020-07-31	AGGY	ETF	54.49	54.58	54.421	54.58	111000.0
2020-07-31	AGNG	ETF	25.38	25.38	25.17	25.27	34200.0
2020-07-31	AGQ	ETF	47.93	50.0	47.48	49.92	2359800.0
2020-07-31	AGZ	ETF	121.6	121.86	121.6	121.71	25336.0
2020-07-31	AGZD	ETF	23.525	23.6	23.51	23.575	43000.0
2020-07-31	AIA	ETF	70.11	70.11	69.0079	69.57	86632.0
2020-07-31	AIEQ	ETF	30.43	30.44	30.026	30.42	10400.0
2020-07-31	AIQ	ETF	22.21	22.21	21.81	22.11	106906.0
2020-07-31	AIRR	ETF	24.778	24.778	24.28	24.734	70500.0
2020-07-31	AIVI	ETF	36.21	36.21	35.51	35.68	11800.0
2020-07-31	ALTL	ETF	24.91	24.91	24.5992	24.8	1827.0
2020-07-31	ALTY	ETF	10.83	10.83	10.63	10.76	15000.0
2020-07-31	AMJ	ETF	12.93	13.0	12.52	12.77	791779.0
2020-07-31	AMLP	ETF	23.85	24.12	23.22	23.74	1596900.0
2020-07-31	AMNA	ETF	23.45	23.64	23.26	23.64	7200.0
2020-07-31	AMND	ETF	24.83	24.8316	24.83	24.8316	200.0
2020-07-31	AMOM	ETF	33.79	33.79	33.34	33.491	1100.0
2020-07-31	AMUB	ETF	8.06	8.06	7.91	8.035	4731.0
2020-07-31	AMZA	ETF	17.14	17.19	16.511	16.87	67900.0
2020-07-31	ANGL	ETF	30.4	30.69	30.29	30.64	1482200.0
2020-07-31	AOA	ETF	57.05	57.05	56.21	56.75	43400.0
2020-07-31	AOK	ETF	37.18	37.23	37.02	37.17	65266.0

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

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