PREVIEW / etf_daily / 2021-02-23

all etf daily files

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

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-23	SPY	ETF	384.66	388.95	380.2	387.5	107284100.0
2021-02-23	QQQ	ETF	317.0	323.2	311.0	321.48	97241936.0
2021-02-23	IWM	ETF	220.96	222.98	215.56	221.76	38646800.0
2021-02-23	DIA	ETF	314.77	316.49	311.6	315.39	5723400.0
2021-02-23	GLD	ETF	169.48	169.74	168.28	169.12	8616800.0
2021-02-23	TLT	ETF	141.52	142.5	141.14	141.77	12658500.0
2021-02-23	AAA	ETF	25.06	25.08	25.06	25.07	608.0
2021-02-23	AAAU	ETF	18.01	18.03	17.88	17.95	1068300.0
2021-02-23	AADR	ETF	63.29	64.6	63.29	64.6	3200.0
2021-02-23	AAXJ	ETF	97.61	99.1	96.77	98.76	1742400.0
2021-02-23	ABEQ	ETF	25.72	25.89	25.72	25.886	13500.0
2021-02-23	ACES	ETF	81.57	83.74	77.0	82.98	280800.0
2021-02-23	ACIO	ETF	27.81	27.81	27.43	27.76	18900.0
2021-02-23	ACSI	ETF	45.06	45.1236	45.06	45.1236	3237.0
2021-02-23	ACTV	ETF	34.3322	34.784	34.3322	34.784	3564.0
2021-02-23	ACTX	ETF	4.75	4.75	4.75	4.75	597.0
2021-02-23	ACVF	ETF	28.76	28.895	28.53	28.82	1600.0
2021-02-23	ACWF	ETF	35.42	35.75	34.95	35.68	8899.0
2021-02-23	ACWI	ETF	94.3	95.22	93.16	94.91	8551800.0
2021-02-23	ACWV	ETF	95.8	96.5	95.58	96.16	860200.0
2021-02-23	ACWX	ETF	55.86	56.28	55.26	56.13	881318.0
2021-02-23	ADFI	ETF	9.76	9.77	9.753	9.753	1200.0
2021-02-23	ADME	ETF	36.3	36.325	35.76	36.21	13400.0
2021-02-23	ADRE	ETF	61.69	62.8499	59.81	62.58	60052.0
2021-02-23	AESR	ETF	12.05	12.3	12.05	12.29	30800.0
2021-02-23	AFIF	ETF	9.746	9.75	9.71	9.7313	181067.0
2021-02-23	AFK	ETF	21.95	21.95	21.62	21.79	24575.0
2021-02-23	AFLG	ETF	22.95	23.31	22.95	23.263	1000.0
2021-02-23	AFMC	ETF	23.507	23.507	23.507	23.507	100.0
2021-02-23	AFSM	ETF	25.07	25.07	25.07	25.07	100.0
2021-02-23	AFTY	ETF	25.13	25.245	25.0	25.12	9300.0
2021-02-23	AGG	ETF	115.75	115.75	115.27	115.51	6035200.0
2021-02-23	AGGY	ETF	52.1	52.17	52.05	52.14	118400.0
2021-02-23	AGNG	ETF	28.17	28.48	28.17	28.48	4900.0
2021-02-23	AGQ	ETF	54.16	54.16	51.9	53.56	2148800.0
2021-02-23	AGZ	ETF	118.75	118.8	118.69	118.71	44352.0
2021-02-23	AGZD	ETF	23.58	23.64	23.58	23.615	58000.0
2021-02-23	AIA	ETF	98.19	98.89	97.03	98.55	507186.0
2021-02-23	AIEQ	ETF	38.82	39.43	37.111	39.15	77700.0
2021-02-23	AIQ	ETF	28.99	29.5999	28.36	29.39	65777.0
2021-02-23	AIRR	ETF	38.67	39.07	38.36	38.9	167200.0
2021-02-23	AIVI	ETF	42.36	42.71	42.32	42.6	13700.0
2021-02-23	ALTL	ETF	36.86	37.87	36.79	37.8199	7811.0
2021-02-23	ALTY	ETF	12.44	12.44	12.29	12.42	19600.0
2021-02-23	AMJ	ETF	15.92	16.07	15.195	15.99	1308843.0
2021-02-23	AMLP	ETF	28.72	28.96	27.31	28.94	3300400.0
2021-02-23	AMNA	ETF	28.6535	28.6535	28.6535	28.6535	0.0
2021-02-23	AMND	ETF	30.3297	30.3297	30.3297	30.3297	0.0
2021-02-23	AMOM	ETF	33.0	33.224	32.53	33.224	1500.0
2021-02-23	AMPS	ETF	10.49	10.68	10.19	10.4	68562.0

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

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