PREVIEW / etf_daily / 2020-07-08

all etf daily files

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

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-08	SPY	ETF	314.61	316.3	312.7	316.18	54638600.0
2020-07-08	QQQ	ETF	258.0	260.02	256.5	259.99	30426273.0
2020-07-08	IWM	ETF	140.76	142.5	139.1	141.94	27358900.0
2020-07-08	DIA	ETF	259.64	261.19	258.25	260.72	2837800.0
2020-07-08	GLD	ETF	170.32	170.86	169.78	170.09	11662700.0
2020-07-08	TLT	ETF	164.32	164.92	163.83	164.55	7253900.0
2020-07-08	AAAU	ETF	18.07	18.13	18.02	18.05	446000.0
2020-07-08	AADR	ETF	55.26	55.52	55.04	55.52	2600.0
2020-07-08	AAXJ	ETF	74.67	75.77	74.64	75.76	1539000.0
2020-07-08	ABEQ	ETF	22.38	22.38	22.277	22.324	1100.0
2020-07-08	ACES	ETF	42.86	42.86	41.96	42.83	123300.0
2020-07-08	ACIO	ETF	25.21	25.43	25.21	25.43	16100.0
2020-07-08	ACSI	ETF	34.2365	34.2365	34.2365	34.2365	100.0
2020-07-08	ACTX	ETF	3.422	3.422	2.8202	2.95	422.0
2020-07-08	ACWF	ETF	28.4215	28.4673	28.3	28.4673	18477.0
2020-07-08	ACWI	ETF	75.73	76.31	75.48	76.29	1859800.0
2020-07-08	ACWV	ETF	88.64	88.97	88.34	88.97	169200.0
2020-07-08	ACWX	ETF	44.62	45.04	44.55	45.03	1031615.0
2020-07-08	ADME	ETF	32.02	32.87	32.02	32.87	10700.0
2020-07-08	ADRE	ETF	42.69	43.445	42.69	43.445	8430.0
2020-07-08	AESR	ETF	10.19	10.23	10.15	10.23	8700.0
2020-07-08	AFIF	ETF	9.83	9.8414	9.825	9.8349	18136.0
2020-07-08	AFK	ETF	16.67	16.91	16.67	16.8	4037.0
2020-07-08	AFLG	ETF	19.17	19.17	19.141	19.141	200.0
2020-07-08	AFTY	ETF	19.56	19.873	19.56	19.873	7400.0
2020-07-08	AGG	ETF	118.35	118.45	118.22	118.32	5026800.0
2020-07-08	AGGY	ETF	53.99	54.05	53.93	54.05	91200.0
2020-07-08	AGNG	ETF	24.98	24.98	24.98	24.98	800.0
2020-07-08	AGQ	ETF	30.63	31.35	30.52	31.17	1586600.0
2020-07-08	AGZ	ETF	120.88	120.9	120.69	120.9	54959.0
2020-07-08	AGZD	ETF	23.595	23.595	23.555	23.575	11000.0
2020-07-08	AIA	ETF	69.41	70.19	69.39	70.19	74002.0
2020-07-08	AIEQ	ETF	29.06	29.16	28.91	29.142	13200.0
2020-07-08	AIQ	ETF	21.46	21.89	21.46	21.8547	22878.0
2020-07-08	AIRR	ETF	23.07	23.16	22.78	22.96	27700.0
2020-07-08	AIVI	ETF	35.9	36.14	35.88	36.14	2100.0
2020-07-08	ALTL	ETF	23.6	23.9148	23.56	23.9148	49330.0
2020-07-08	ALTY	ETF	10.58	10.62	10.47	10.54	14900.0
2020-07-08	AMJ	ETF	12.82	12.96	12.61	12.72	2130722.0
2020-07-08	AMLP	ETF	23.79	24.05	23.37	23.7	2966800.0
2020-07-08	AMNA	ETF	25.43	25.43	23.12	23.2074	2030.0
2020-07-08	AMOM	ETF	31.42	31.782	31.42	31.742	600.0
2020-07-08	AMUB	ETF	7.96	8.12	7.94	8.04	12168.0
2020-07-08	AMZA	ETF	16.67	16.84	16.24	16.5	52000.0
2020-07-08	ANGL	ETF	28.86	28.97	28.76	28.96	859600.0
2020-07-08	AOA	ETF	55.48	55.84	55.34	55.84	61700.0
2020-07-08	AOK	ETF	36.6	36.7	36.5	36.69	138737.0
2020-07-08	AOM	ETF	40.02	40.2	39.972	40.2	291798.0
2020-07-08	AOR	ETF	46.79	47.0	46.6988	46.98	144801.0
2020-07-08	ARB	ETF	24.8	24.85	24.8	24.84	1900.0

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

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