PREVIEW / etf_daily / 2020-11-19

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-19.parquet
  size:    81 KB
  rows:    2,147

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-11-19	SPY	ETF	355.6	358.18	354.15	357.78	59940900.0
2020-11-19	QQQ	ETF	289.48	292.7	288.85	292.38	22718422.0
2020-11-19	IWM	ETF	175.65	177.59	175.07	177.31	20187600.0
2020-11-19	DIA	ETF	294.06	295.81	292.9	295.33	3266600.0
2020-11-19	GLD	ETF	174.3	175.22	174.17	175.16	6965100.0
2020-11-19	TLT	ETF	159.97	160.72	159.84	160.09	10637200.0
2020-11-19	AAA	ETF	25.03	25.03	25.03	25.03	1602.0
2020-11-19	AAAU	ETF	18.49	18.6	18.49	18.59	439500.0
2020-11-19	AADR	ETF	55.98	57.07	55.98	56.92	4700.0
2020-11-19	AAXJ	ETF	84.59	85.21	84.43	85.09	1424400.0
2020-11-19	ABEQ	ETF	24.53	24.558	24.43	24.558	17700.0
2020-11-19	ACES	ETF	63.44	64.845	63.44	64.82	71000.0
2020-11-19	ACIO	ETF	27.195	27.31	27.195	27.31	25300.0
2020-11-19	ACSI	ETF	41.405	41.512	41.405	41.512	654.0
2020-11-19	ACTV	ETF	28.1099	28.2896	28.04	28.2896	2363.0
2020-11-19	ACTX	ETF	2.78	2.78	2.02	2.5	518.0
2020-11-19	ACVF	ETF	26.35	26.49	26.32	26.478	5000.0
2020-11-19	ACWF	ETF	31.78	31.9958	31.78	31.9958	2253.0
2020-11-19	ACWI	ETF	86.01	86.62	85.73	86.56	1777900.0
2020-11-19	ACWV	ETF	95.3	95.81	95.19	95.68	210100.0
2020-11-19	ACWX	ETF	50.2173	50.64	50.17	50.64	810465.0
2020-11-19	ADFI	ETF	10.0	10.0	10.0	10.0	100.0
2020-11-19	ADME	ETF	34.62	34.82	34.62	34.82	31000.0
2020-11-19	ADRE	ETF	52.43	52.94	52.41	52.7684	6459.0
2020-11-19	AESR	ETF	11.36	11.44	11.36	11.44	11900.0
2020-11-19	AFIF	ETF	9.785	9.82	9.785	9.805	33009.0
2020-11-19	AFK	ETF	19.45	19.59	19.44	19.44	4296.0
2020-11-19	AFLG	ETF	21.31	21.34	21.31	21.34	300.0
2020-11-19	AFMC	ETF	19.807	19.94	19.807	19.94	400.0
2020-11-19	AFTY	ETF	21.64	21.65	21.62	21.635	3400.0
2020-11-19	AGG	ETF	118.08	118.26	118.03	118.17	6680800.0
2020-11-19	AGGY	ETF	53.81	53.92	53.78	53.87	2428200.0
2020-11-19	AGNG	ETF	26.42	26.74	26.32	26.32	4200.0
2020-11-19	AGQ	ETF	42.31	43.59	42.09	43.56	723300.0
2020-11-19	AGZ	ETF	120.83	120.88	120.73	120.84	26842.0
2020-11-19	AGZD	ETF	23.525	23.595	23.525	23.54	16200.0
2020-11-19	AIA	ETF	81.23	81.7	81.03	81.64	158922.0
2020-11-19	AIEQ	ETF	31.88	32.48	31.73	32.419	9800.0
2020-11-19	AIQ	ETF	25.07	25.35	24.92	25.34	22668.0
2020-11-19	AIRR	ETF	31.18	31.19	30.777	31.165	8300.0
2020-11-19	AIVI	ETF	38.84	38.93	38.7	38.93	3700.0
2020-11-19	ALTL	ETF	28.7599	29.2066	28.7096	29.2066	4093.0
2020-11-19	ALTY	ETF	11.44	11.44	11.38	11.42	2500.0
2020-11-19	AMJ	ETF	13.45	13.98	13.32	13.98	1652679.0
2020-11-19	AMLP	ETF	24.37	25.31	24.15	25.26	8345800.0
2020-11-19	AMNA	ETF	24.5589	24.5589	24.5589	24.5589	4.0
2020-11-19	AMND	ETF	26.2775	26.2775	26.2775	26.2775	0.0
2020-11-19	AMOM	ETF	36.7	37.919	36.4	37.102	2400.0
2020-11-19	AMTR	ETF	26.94	27.7	26.84	27.68	120866.0
2020-11-19	AMUB	ETF	8.49	8.78	8.46	8.78	31440.0

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

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