PREVIEW / etf_daily / 2021-01-08

all etf daily files

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

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-08	SPY	ETF	380.59	381.49	377.1	381.26	71677200.0
2021-01-08	QQQ	ETF	317.34	319.39	315.0814	319.03	33955847.0
2021-01-08	IWM	ETF	209.32	209.77	204.66	207.72	29017000.0
2021-01-08	DIA	ETF	311.25	311.43	307.99	311.04	3234900.0
2021-01-08	GLD	ETF	176.83	176.99	171.48	173.34	24399900.0
2021-01-08	TLT	ETF	151.48	151.96	150.66	151.32	13622500.0
2021-01-08	AAA	ETF	25.08	25.08	25.07	25.07	8761.0
2021-01-08	AAAU	ETF	18.78	18.78	18.22	18.41	1217300.0
2021-01-08	AADR	ETF	62.8	63.01	62.63	62.92	1900.0
2021-01-08	AAXJ	ETF	94.27	95.14	93.84	95.14	1811400.0
2021-01-08	ABEQ	ETF	26.013	26.015	25.975	26.015	700.0
2021-01-08	ACES	ETF	96.09	96.09	92.74	94.55	276500.0
2021-01-08	ACIO	ETF	27.98	28.03	27.859	28.03	16300.0
2021-01-08	ACSI	ETF	43.87	43.9949	43.87	43.9949	851.0
2021-01-08	ACTV	ETF	32.945	32.945	32.6	32.8232	2513.0
2021-01-08	ACTX	ETF	2.7	3.0	2.66	2.66	2804.0
2021-01-08	ACVF	ETF	28.36	28.36	28.015	28.218	4600.0
2021-01-08	ACWF	ETF	35.075	35.11	34.9	35.01	2341.0
2021-01-08	ACWI	ETF	93.3	93.49	92.5	93.44	3654600.0
2021-01-08	ACWV	ETF	97.61	98.08	97.32	98.02	466700.0
2021-01-08	ACWX	ETF	55.19	55.37	54.79	55.36	1292891.0
2021-01-08	ADFI	ETF	9.884	9.884	9.884	9.884	100.0
2021-01-08	ADME	ETF	36.49	36.49	36.14	36.44	12000.0
2021-01-08	ADRE	ETF	59.57	59.57	58.5202	59.5	15011.0
2021-01-08	AESR	ETF	12.07	12.101	12.04	12.101	1700.0
2021-01-08	AFIF	ETF	9.76	9.78	9.74	9.7648	1319405.0
2021-01-08	AFK	ETF	21.29	21.29	21.0001	21.07	14151.0
2021-01-08	AFLG	ETF	22.71	22.826	22.71	22.826	2000.0
2021-01-08	AFMC	ETF	22.378	22.378	22.378	22.378	100.0
2021-01-08	AFSM	ETF	23.425	23.425	23.425	23.425	100.0
2021-01-08	AFTY	ETF	24.23	24.297	24.18	24.24	7000.0
2021-01-08	AGG	ETF	117.18	117.34	116.98	117.08	7335700.0
2021-01-08	AGGY	ETF	53.19	53.19	53.075	53.13	124200.0
2021-01-08	AGNG	ETF	28.53	28.776	28.507	28.65	16800.0
2021-01-08	AGQ	ETF	51.67	51.83	43.14	46.09	5677100.0
2021-01-08	AGZ	ETF	119.26	119.26	119.1001	119.21	34294.0
2021-01-08	AGZD	ETF	23.605	23.605	23.51	23.545	7600.0
2021-01-08	AIA	ETF	93.1	93.8	92.5644	93.8	235733.0
2021-01-08	AIEQ	ETF	37.94	38.0	37.3	37.75	30400.0
2021-01-08	AIQ	ETF	27.78	27.9	27.5621	27.9	38218.0
2021-01-08	AIRR	ETF	37.22	37.22	35.982	36.399	53300.0
2021-01-08	AIVI	ETF	42.08	42.25	41.93	42.17	4200.0
2021-01-08	ALTL	ETF	33.97	33.97	33.51	33.821	137397.0
2021-01-08	ALTY	ETF	11.82	11.84	11.75	11.84	30300.0
2021-01-08	AMJ	ETF	15.44	15.44	14.84	15.02	1223660.0
2021-01-08	AMLP	ETF	28.4	28.43	27.47	27.77	2436900.0
2021-01-08	AMNA	ETF	26.9339	26.9339	26.9339	26.9339	0.0
2021-01-08	AMND	ETF	28.47	28.7029	28.47	28.7029	336.0
2021-01-08	AMOM	ETF	32.75	33.12	32.66	33.12	9100.0
2021-01-08	AMTR	ETF	30.4003	30.4003	30.4003	30.4003	0.0

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

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