PREVIEW / etf_daily / 2021-01-12

all etf daily files

  file:    by_date/etf_daily/2021/2021-01-12.parquet
  size:    84 KB
  rows:    2,219

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
2021-01-12	SPY	ETF	378.89	379.86	376.36	378.77	52547700.0
2021-01-12	QQQ	ETF	314.46	315.58	311.2	313.92	29266762.0
2021-01-12	IWM	ETF	208.52	211.39	208.49	211.26	24892200.0
2021-01-12	DIA	ETF	310.18	311.25	308.91	310.74	2290900.0
2021-01-12	GLD	ETF	173.13	174.18	172.32	174.12	9798500.0
2021-01-12	TLT	ETF	150.79	151.16	149.93	150.95	12186300.0
2021-01-12	AAA	ETF	25.11	25.11	25.1	25.1	816.0
2021-01-12	AAAU	ETF	18.39	18.49	18.3	18.49	497800.0
2021-01-12	AADR	ETF	62.78	62.97	62.65	62.92	2000.0
2021-01-12	AAXJ	ETF	94.71	95.04	94.36	94.68	1776800.0
2021-01-12	ABEQ	ETF	25.92	26.03	25.895	25.995	700.0
2021-01-12	ACES	ETF	96.14	97.26	94.746	96.7	318000.0
2021-01-12	ACIO	ETF	27.87	27.91	27.744	27.89	25600.0
2021-01-12	ACSI	ETF	44.245	44.26	43.9875	44.16	1469.0
2021-01-12	ACTV	ETF	33.125	33.22	33.08	33.1811	4993.0
2021-01-12	ACTX	ETF	2.95	2.95	2.55	2.55	1152.0
2021-01-12	ACVF	ETF	28.05	28.36	28.0	28.09	9400.0
2021-01-12	ACWF	ETF	34.97	35.11	34.97	35.0916	7788.0
2021-01-12	ACWI	ETF	92.67	93.04	92.31	92.95	9483200.0
2021-01-12	ACWV	ETF	97.4	97.58	96.97	97.55	558000.0
2021-01-12	ACWX	ETF	54.72	55.01	54.575	54.96	826076.0
2021-01-12	ADFI	ETF	9.857	9.857	9.857	9.857	100.0
2021-01-12	ADME	ETF	36.59	36.59	35.985	36.19	36400.0
2021-01-12	ADRE	ETF	59.54	59.65	59.1203	59.44	110438.0
2021-01-12	AESR	ETF	12.02	12.06	12.0	12.034	5400.0
2021-01-12	AFIF	ETF	9.735	9.76	9.72	9.75	25224.0
2021-01-12	AFK	ETF	20.78	21.055	20.7281	20.98	12294.0
2021-01-12	AFLG	ETF	22.863	22.863	22.863	22.863	1000.0
2021-01-12	AFMC	ETF	22.735	22.735	22.735	22.735	100.0
2021-01-12	AFSM	ETF	23.785	23.785	23.785	23.785	100.0
2021-01-12	AFTY	ETF	24.84	24.93	24.81	24.93	7700.0
2021-01-12	AGG	ETF	116.82	116.99	116.68	116.99	7269600.0
2021-01-12	AGGY	ETF	53.0	53.09	52.88	53.09	124500.0
2021-01-12	AGNG	ETF	28.874	28.874	28.67	28.788	4500.0
2021-01-12	AGQ	ETF	46.28	47.44	45.66	47.1	1004700.0
2021-01-12	AGZ	ETF	119.06	119.25	118.95	119.24	1009481.0
2021-01-12	AGZD	ETF	23.5	23.585	23.465	23.54	384200.0
2021-01-12	AIA	ETF	93.61	93.99	93.32	93.57	1838296.0
2021-01-12	AIEQ	ETF	37.75	38.475	37.75	38.45	18300.0
2021-01-12	AIQ	ETF	27.7	27.732	27.46	27.69	37226.0
2021-01-12	AIRR	ETF	36.69	37.37	36.57	37.322	9900.0
2021-01-12	AIVI	ETF	41.76	41.83	41.6	41.83	6000.0
2021-01-12	ALTL	ETF	34.0393	34.7474	34.0393	34.7474	8458.0
2021-01-12	ALTY	ETF	11.82	11.89	11.808	11.85	26400.0
2021-01-12	AMJ	ETF	15.24	15.91	15.24	15.67	552304.0
2021-01-12	AMLP	ETF	28.33	29.46	28.33	29.35	3383400.0
2021-01-12	AMNA	ETF	27.6278	27.6278	27.6278	27.6278	10.0
2021-01-12	AMND	ETF	29.4663	29.4663	29.4663	29.4663	10.0
2021-01-12	AMOM	ETF	33.27	33.27	32.85	32.95	2000.0
2021-01-12	AMTR	ETF	31.79	31.79	31.7439	31.7439	101.0

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

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