PREVIEW / etf_daily / 2021-02-12

all etf daily files

  file:    by_date/etf_daily/2021/2021-02-12.parquet
  size:    86 KB
  rows:    2,260

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-02-12	SPY	ETF	389.85	392.9	389.77	392.64	50593300.0
2021-02-12	QQQ	ETF	333.71	336.62	332.63	336.45	20346819.0
2021-02-12	IWM	ETF	225.93	227.74	224.64	227.26	17440200.0
2021-02-12	DIA	ETF	314.28	315.14	313.83	315.04	2479500.0
2021-02-12	GLD	ETF	170.29	171.65	169.88	170.69	6018900.0
2021-02-12	TLT	ETF	147.7	148.08	147.03	147.11	14088400.0
2021-02-12	AAA	ETF	25.13	25.13	25.12	25.12	598.0
2021-02-12	AAAU	ETF	18.09	18.22	18.04	18.12	606700.0
2021-02-12	AADR	ETF	66.96	67.15	66.78	67.0	3800.0
2021-02-12	AAXJ	ETF	101.33	101.92	101.13	101.7	674300.0
2021-02-12	ABEQ	ETF	25.87	25.98	25.87	25.97	7100.0
2021-02-12	ACES	ETF	98.33	98.33	96.473	98.0	129800.0
2021-02-12	ACIO	ETF	27.995	28.06	27.98	28.06	137000.0
2021-02-12	ACSI	ETF	45.271	45.4607	45.25	45.4607	1536.0
2021-02-12	ACTV	ETF	35.7	35.7	35.325	35.5317	2130.0
2021-02-12	ACTX	ETF	6.88	6.99	5.5	5.5	2159.0
2021-02-12	ACVF	ETF	29.07	29.165	29.07	29.165	400.0
2021-02-12	ACWF	ETF	36.03	36.1756	36.03	36.1756	12244.0
2021-02-12	ACWI	ETF	95.59	96.36	95.59	96.34	3231800.0
2021-02-12	ACWV	ETF	97.7	97.9	97.56	97.86	262200.0
2021-02-12	ACWX	ETF	56.31	56.72	56.27	56.69	363312.0
2021-02-12	ADFI	ETF	9.855	9.86	9.855	9.86	300.0
2021-02-12	ADME	ETF	37.27	37.27	36.84	37.02	111000.0
2021-02-12	ADRE	ETF	65.47	66.2499	65.34	65.8141	42498.0
2021-02-12	AESR	ETF	12.385	12.457	12.38	12.457	6400.0
2021-02-12	AFIF	ETF	9.74	9.76	9.74	9.74	22956.0
2021-02-12	AFK	ETF	21.61	21.819	21.57	21.75	15301.0
2021-02-12	AFLG	ETF	23.683	23.683	23.683	23.683	100.0
2021-02-12	AFMC	ETF	23.725	23.725	23.725	23.725	100.0
2021-02-12	AFSM	ETF	25.978	25.978	25.978	25.978	600.0
2021-02-12	AFTY	ETF	26.825	26.93	26.82	26.843	4500.0
2021-02-12	AGG	ETF	116.67	116.74	116.54	116.58	3284900.0
2021-02-12	AGGY	ETF	52.96	52.99	52.9	52.92	130500.0
2021-02-12	AGNG	ETF	29.41	29.49	29.31	29.49	3500.0
2021-02-12	AGQ	ETF	51.23	52.71	50.93	52.16	951400.0
2021-02-12	AGZ	ETF	119.23	119.235	119.14	119.19	26344.0
2021-02-12	AGZD	ETF	23.71	23.71	23.67	23.68	7400.0
2021-02-12	AIA	ETF	101.59	102.275	101.54	102.06	212787.0
2021-02-12	AIEQ	ETF	41.68	42.16	41.3	42.16	62600.0
2021-02-12	AIQ	ETF	30.34	30.5	30.19	30.5	40855.0
2021-02-12	AIRR	ETF	37.61	37.8	37.41	37.741	9100.0
2021-02-12	AIVI	ETF	42.12	42.3	42.12	42.29	7000.0
2021-02-12	ALTL	ETF	35.44	35.6496	35.44	35.6496	1575.0
2021-02-12	ALTY	ETF	12.34	12.37	12.31	12.35	15900.0
2021-02-12	AMJ	ETF	15.42	15.67	15.42	15.61	323796.0
2021-02-12	AMLP	ETF	27.79	28.27	27.72	28.16	2003000.0
2021-02-12	AMNA	ETF	28.0517	28.0517	28.0517	28.0517	0.0
2021-02-12	AMND	ETF	29.7617	29.7617	29.7617	29.7617	5.0
2021-02-12	AMOM	ETF	34.45	34.731	34.45	34.731	1500.0
2021-02-12	AMPS	ETF	10.66	11.0	10.51	10.57	83873.0

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

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