PREVIEW / etf_daily / 2020-09-16

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-16.parquet
  size:    79 KB
  rows:    2,091

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-09-16	SPY	ETF	341.51	343.06	338.52	338.82	82096000.0
2020-09-16	QQQ	ETF	279.77	280.36	274.25	274.61	42435626.0
2020-09-16	IWM	ETF	154.11	156.85	153.84	154.82	22178400.0
2020-09-16	DIA	ETF	281.54	284.23	280.78	281.03	2651800.0
2020-09-16	GLD	ETF	184.98	185.01	183.33	183.97	12702400.0
2020-09-16	TLT	ETF	164.78	164.89	162.98	163.58	8815200.0
2020-09-16	AAA	ETF	24.97	24.9839	24.97	24.97	14920.0
2020-09-16	AAAU	ETF	19.63	19.63	19.45	19.51	570300.0
2020-09-16	AADR	ETF	56.92	57.09	56.59	56.7	3400.0
2020-09-16	AAXJ	ETF	78.75	78.96	78.38	78.4	1008400.0
2020-09-16	ABEQ	ETF	24.09	24.11	23.95	23.959	10600.0
2020-09-16	ACES	ETF	53.16	53.62	52.78	53.08	42100.0
2020-09-16	ACIO	ETF	27.0	27.0	26.599	26.599	2600.0
2020-09-16	ACSI	ETF	37.575	37.575	37.3722	37.3722	233.0
2020-09-16	ACTX	ETF	2.242	2.4055	2.242	2.2538	14.0
2020-09-16	ACWF	ETF	30.2369	30.34	30.0667	30.0667	3532.0
2020-09-16	ACWI	ETF	81.66	81.94	81.05	81.1	1910300.0
2020-09-16	ACWV	ETF	93.49	93.64	92.9	92.97	224800.0
2020-09-16	ACWX	ETF	47.4	47.58	47.18	47.23	602548.0
2020-09-16	ADFI	ETF	10.005	10.005	10.005	10.005	100.0
2020-09-16	ADME	ETF	33.8	33.87	33.525	33.525	3100.0
2020-09-16	ADRE	ETF	48.034	48.0404	47.645	47.65	3951.0
2020-09-16	AESR	ETF	11.01	11.025	10.9	10.9	4400.0
2020-09-16	AFIF	ETF	9.8102	9.8399	9.79	9.8127	6191.0
2020-09-16	AFK	ETF	18.2427	18.4389	18.2427	18.3	7181.0
2020-09-16	AFLG	ETF	20.43	20.43	20.31	20.31	400.0
2020-09-16	AFTY	ETF	19.7	19.7	19.6	19.631	900.0
2020-09-16	AGG	ETF	118.53	118.53	118.2	118.33	6452500.0
2020-09-16	AGGY	ETF	54.13	54.17	54.011	54.06	82700.0
2020-09-16	AGNG	ETF	26.02	26.02	25.877	25.877	1000.0
2020-09-16	AGQ	ETF	59.37	59.75	57.2	58.18	1369500.0
2020-09-16	AGZ	ETF	121.38	121.38	121.13	121.21	28872.0
2020-09-16	AGZD	ETF	23.54	23.545	23.5	23.525	21600.0
2020-09-16	AIA	ETF	74.01	74.12	73.54	73.54	69263.0
2020-09-16	AIEQ	ETF	30.43	30.508	30.189	30.26	10500.0
2020-09-16	AIQ	ETF	23.53	23.53	23.1326	23.1841	12661.0
2020-09-16	AIRR	ETF	26.26	26.676	26.17	26.438	77800.0
2020-09-16	AIVI	ETF	37.46	37.78	37.45	37.5	183600.0
2020-09-16	ALTL	ETF	25.26	25.33	25.08	25.08	19293.0
2020-09-16	ALTY	ETF	10.9	10.95	10.84	10.92	6100.0
2020-09-16	AMJ	ETF	11.69	12.03	11.62	11.86	1060688.0
2020-09-16	AMLP	ETF	21.51	22.18	21.43	21.82	2776300.0
2020-09-16	AMNA	ETF	23.45	23.78	23.45	23.53	3900.0
2020-09-16	AMND	ETF	24.5888	24.5888	24.5888	24.5888	0.0
2020-09-16	AMOM	ETF	34.665	34.68	34.375	34.38	2600.0
2020-09-16	AMUB	ETF	7.51	7.52	7.4562	7.4562	17896.0
2020-09-16	AMZA	ETF	15.01	15.73	14.95	15.36	160700.0
2020-09-16	ANGL	ETF	30.15	30.19	29.98	30.08	1939900.0
2020-09-16	AOA	ETF	59.09	59.25	58.74	58.84	37800.0
2020-09-16	AOK	ETF	37.65	37.65	37.5	37.55	90407.0

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

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