PREVIEW / etf_daily / 2020-08-17

all etf daily files

  file:    by_date/etf_daily/2020/2020-08-17.parquet
  size:    78 KB
  rows:    2,059

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-17	SPY	ETF	337.94	338.34	336.85	337.91	35481000.0
2020-08-17	QQQ	ETF	273.91	275.84	272.1978	275.32	24802966.0
2020-08-17	IWM	ETF	157.5	158.03	156.74	157.9	9744200.0
2020-08-17	DIA	ETF	280.14	280.25	278.5	278.95	2436900.0
2020-08-17	GLD	ETF	184.69	187.01	184.66	186.5	15709800.0
2020-08-17	TLT	ETF	163.97	164.46	163.43	163.59	6901500.0
2020-08-17	AAAU	ETF	19.61	19.83	19.58	19.77	753800.0
2020-08-17	AADR	ETF	58.21	58.36	58.11	58.36	2200.0
2020-08-17	AAXJ	ETF	77.32	77.85	77.24	77.78	502500.0
2020-08-17	ABEQ	ETF	23.583	23.583	23.51	23.569	2500.0
2020-08-17	ACES	ETF	50.62	51.24	50.6	51.11	72900.0
2020-08-17	ACIO	ETF	26.85	26.85	26.73	26.81	75400.0
2020-08-17	ACSI	ETF	37.69	37.7736	37.69	37.7736	1248.0
2020-08-17	ACTX	ETF	2.5783	2.5783	2.36	2.36	109.0
2020-08-17	ACWF	ETF	30.3	30.4266	30.3	30.37	7373.0
2020-08-17	ACWI	ETF	80.56	80.78	80.51	80.76	3984200.0
2020-08-17	ACWV	ETF	92.95	93.28	92.79	93.1	227300.0
2020-08-17	ACWX	ETF	46.86	47.03	46.86	47.03	467347.0
2020-08-17	ADME	ETF	34.15	34.21	33.66	33.99	52300.0
2020-08-17	ADRE	ETF	45.78	46.1948	45.78	46.1618	6733.0
2020-08-17	AESR	ETF	10.83	10.864	10.81	10.864	27000.0
2020-08-17	AFIF	ETF	9.79	9.85	9.79	9.8349	14807.0
2020-08-17	AFK	ETF	17.56	17.56	17.455	17.485	2557.0
2020-08-17	AFTY	ETF	19.43	19.55	19.43	19.55	8700.0
2020-08-17	AGG	ETF	118.38	118.47	118.31	118.36	4523900.0
2020-08-17	AGGY	ETF	54.06	54.09	54.01	54.01	120500.0
2020-08-17	AGNG	ETF	25.67	25.869	25.67	25.817	2200.0
2020-08-17	AGQ	ETF	60.35	61.27	59.32	60.94	2380200.0
2020-08-17	AGZ	ETF	121.31	121.3189	121.04	121.29	44271.0
2020-08-17	AGZD	ETF	23.745	23.745	23.505	23.555	21200.0
2020-08-17	AIA	ETF	72.13	72.5649	72.09	72.515	43914.0
2020-08-17	AIEQ	ETF	30.62	30.89	30.556	30.89	19600.0
2020-08-17	AIQ	ETF	22.5	22.5899	22.475	22.5502	10819.0
2020-08-17	AIRR	ETF	27.49	27.49	27.31	27.39	10000.0
2020-08-17	AIVI	ETF	37.59	37.64	37.52	37.61	13600.0
2020-08-17	ALTL	ETF	25.4	25.4115	25.345	25.35	3353.0
2020-08-17	ALTY	ETF	11.2	11.2	11.08	11.1	20000.0
2020-08-17	AMJ	ETF	13.94	13.96	13.79	13.83	428489.0
2020-08-17	AMLP	ETF	25.01	25.1	24.79	24.9	1531300.0
2020-08-17	AMNA	ETF	25.67	25.67	25.65	25.6593	1700.0
2020-08-17	AMND	ETF	27.0961	27.0961	27.0961	27.0961	4.0
2020-08-17	AMOM	ETF	34.52	35.11	34.52	35.0	4600.0
2020-08-17	AMUB	ETF	8.51	8.7424	8.51	8.7199	2990.0
2020-08-17	AMZA	ETF	18.83	18.92	18.61	18.72	61500.0
2020-08-17	ANGL	ETF	30.09	30.35	30.09	30.3	668200.0
2020-08-17	AOA	ETF	58.6	58.67	58.38	58.67	36900.0
2020-08-17	AOK	ETF	37.36	37.49	37.36	37.4	128878.0
2020-08-17	AOM	ETF	41.35	41.39	41.23	41.27	106908.0
2020-08-17	AOR	ETF	48.8	48.88	48.77	48.83	83465.0
2020-08-17	APRT	ETF	26.265	26.265	26.265	26.265	0.0

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

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