PREVIEW / etf_daily / 2020-10-08

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-08.parquet
  size:    80 KB
  rows:    2,112

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-10-08	SPY	ETF	342.85	343.85	341.86	343.78	45242500.0
2020-10-08	QQQ	ETF	282.32	282.47	280.31	281.41	25443287.0
2020-10-08	IWM	ETF	161.72	162.28	160.58	161.86	37278600.0
2020-10-08	DIA	ETF	284.52	284.68	282.69	284.29	2148000.0
2020-10-08	GLD	ETF	178.18	178.45	176.67	177.85	6530800.0
2020-10-08	TLT	ETF	159.97	160.25	159.66	160.12	8431500.0
2020-10-08	AAA	ETF	24.9	24.905	24.9	24.9	1697.0
2020-10-08	AAAU	ETF	18.9	18.93	18.76	18.87	417100.0
2020-10-08	AADR	ETF	56.57	56.95	56.57	56.78	1900.0
2020-10-08	AAXJ	ETF	79.52	79.77	79.33	79.65	1067100.0
2020-10-08	ABEQ	ETF	23.76	23.87	23.76	23.87	12000.0
2020-10-08	ACES	ETF	62.1	62.1	59.8	60.13	90100.0
2020-10-08	ACIO	ETF	26.93	26.98	26.905	26.96	60800.0
2020-10-08	ACSI	ETF	38.6492	38.6492	38.6492	38.6492	101.0
2020-10-08	ACTX	ETF	1.298	1.9411	1.298	1.298	2142.0
2020-10-08	ACWF	ETF	30.63	30.71	30.55	30.65	6455.0
2020-10-08	ACWI	ETF	81.95	82.14	81.76	82.12	4290700.0
2020-10-08	ACWV	ETF	93.22	93.58	93.22	93.5	138400.0
2020-10-08	ACWX	ETF	47.11	47.28	47.07	47.28	569856.0
2020-10-08	ADME	ETF	34.06	34.1	33.993	34.08	24500.0
2020-10-08	ADRE	ETF	48.66	48.9755	48.655	48.9755	7156.0
2020-10-08	AESR	ETF	11.1	11.14	11.06	11.126	4900.0
2020-10-08	AFIF	ETF	9.83	9.83	9.81	9.81	57509.0
2020-10-08	AFK	ETF	17.85	17.85	17.669	17.7912	5406.0
2020-10-08	AFLG	ETF	20.727	20.75	20.727	20.75	1600.0
2020-10-08	AFMC	ETF	18.89	18.89	18.89	18.89	200.0
2020-10-08	AFTY	ETF	19.79	19.875	19.79	19.875	500.0
2020-10-08	AGG	ETF	117.67	117.71	117.59	117.69	4236000.0
2020-10-08	AGGY	ETF	53.55	53.71	53.55	53.65	135800.0
2020-10-08	AGNG	ETF	26.28	26.388	26.28	26.38	1000.0
2020-10-08	AGQ	ETF	44.67	45.26	43.16	43.85	1028500.0
2020-10-08	AGZ	ETF	120.75	120.88	120.75	120.87	68147.0
2020-10-08	AGZD	ETF	23.485	23.495	23.445	23.495	9400.0
2020-10-08	AIA	ETF	74.07	74.29	73.87	74.22	60963.0
2020-10-08	AIEQ	ETF	31.97	31.98	31.845	31.85	6400.0
2020-10-08	AIQ	ETF	24.4	24.41	24.255	24.3302	19134.0
2020-10-08	AIRR	ETF	27.76	27.93	27.616	27.895	77400.0
2020-10-08	AIVI	ETF	36.77	36.87	36.77	36.85	4200.0
2020-10-08	ALTL	ETF	25.42	25.5247	25.42	25.5247	6504.0
2020-10-08	ALTY	ETF	10.77	10.845	10.77	10.845	6000.0
2020-10-08	AMJ	ETF	11.17	11.78	11.12	11.77	781415.0
2020-10-08	AMLP	ETF	20.7	21.86	20.6	21.86	2860100.0
2020-10-08	AMNA	ETF	22.97	23.07	22.97	23.0649	500.0
2020-10-08	AMND	ETF	24.3203	24.3203	24.3203	24.3203	0.0
2020-10-08	AMOM	ETF	36.479	36.479	36.32	36.403	1200.0
2020-10-08	AMUB	ETF	7.1444	7.4011	7.1444	7.4011	5823.0
2020-10-08	AMZA	ETF	14.14	15.09	14.078	15.07	169400.0
2020-10-08	ANGL	ETF	30.08	30.08	30.0	30.07	608700.0
2020-10-08	AOA	ETF	59.02	59.19	58.97	59.13	37200.0
2020-10-08	AOK	ETF	37.45	37.51	37.3922	37.49	74152.0

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

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