PREVIEW / etf_daily / 2019-10-01

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-01.parquet
  size:    71 KB
  rows:    1,848

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
2019-10-01	SPY	ETF	297.74	298.46	293.0	293.24	88242400.0
2019-10-01	QQQ	ETF	189.54	190.5898	186.955	187.27	32665025.0
2019-10-01	IWM	ETF	152.11	153.35	148.05	148.37	34093500.0
2019-10-01	DIA	ETF	269.76	270.29	265.45	265.5	3558400.0
2019-10-01	GLD	ETF	138.07	140.19	137.8	139.63	12476200.0
2019-10-01	TLT	ETF	141.26	143.91	141.14	143.26	16613700.0
2019-10-01	AAAU	ETF	14.61	14.83	14.59	14.77	236400.0
2019-10-01	AADR	ETF	47.59	47.59	47.02	47.25	3900.0
2019-10-01	AAXJ	ETF	66.47	66.47	65.81	65.95	761900.0
2019-10-01	ACES	ETF	31.172	31.172	30.58	30.625	12300.0
2019-10-01	ACIO	ETF	24.68	24.68	24.419	24.54	32900.0
2019-10-01	ACSI	ETF	34.1	34.2075	33.681	33.7195	1737.0
2019-10-01	ACTX	ETF	12.9801	14.1601	12.8916	12.9801	358.0
2019-10-01	ACWF	ETF	28.7313	28.7574	28.6659	28.6659	5127.0
2019-10-01	ACWI	ETF	73.82	73.87	72.87	72.9	2298600.0
2019-10-01	ACWV	ETF	94.73	94.76	94.06	94.1	315300.0
2019-10-01	ACWX	ETF	45.96	45.96	45.58	45.66	2152833.0
2019-10-01	ADRE	ETF	38.5	38.5	38.3	38.3	11029.0
2019-10-01	AFIF	ETF	9.75	9.75	9.72	9.7403	3938.0
2019-10-01	AFK	ETF	19.79	19.97	19.79	19.97	1566.0
2019-10-01	AFTY	ETF	16.84	16.84	16.63	16.643	12800.0
2019-10-01	AGG	ETF	112.71	113.25	112.63	113.12	5980200.0
2019-10-01	AGGY	ETF	52.19	52.45	52.15	52.365	149100.0
2019-10-01	AGNG	ETF	21.21	21.21	21.2	21.2	1200.0
2019-10-01	AGQ	ETF	29.63	30.52	29.47	30.29	421800.0
2019-10-01	AGZ	ETF	116.15	116.6	116.15	116.55	24471.0
2019-10-01	AGZD	ETF	23.9	23.905	23.87	23.9	5200.0
2019-10-01	AIA	ETF	58.86	58.86	58.4	58.4	51441.0
2019-10-01	AIEQ	ETF	26.21	26.328	25.89	25.89	21400.0
2019-10-01	AIQ	ETF	16.0225	16.0225	15.7295	15.78	7588.0
2019-10-01	AIRR	ETF	27.05	27.05	26.07	26.07	16600.0
2019-10-01	AIVI	ETF	40.33	40.33	40.08	40.14	6400.0
2019-10-01	ALTY	ETF	14.962	14.962	14.83	14.83	3900.0
2019-10-01	AMJ	ETF	23.28	23.4	23.08	23.09	843254.0
2019-10-01	AMLP	ETF	45.8	45.95	45.4	45.5	3013460.0
2019-10-01	AMOM	ETF	26.33	26.33	25.998	25.998	100.0
2019-10-01	AMUB	ETF	14.5631	14.5631	14.5631	14.5631	0.0
2019-10-01	AMZA	ETF	49.3	49.5	48.65	48.9	109900.0
2019-10-01	ANGL	ETF	29.28	29.28	29.08	29.14	424700.0
2019-10-01	AOA	ETF	54.91	54.97	54.38	54.46	84300.0
2019-10-01	AOK	ETF	35.62	35.67	35.54	35.5576	48208.0
2019-10-01	AOM	ETF	39.2	39.288	39.1	39.1	98997.0
2019-10-01	AOR	ETF	46.06	46.08	45.7101	45.77	82489.0
2019-10-01	ARCM	ETF	100.189	100.19	100.115	100.115	1100.0
2019-10-01	ARGT	ETF	22.78	23.07	22.59	22.69	50800.0
2019-10-01	ARKF	ETF	21.53	21.6	21.327	21.331	8800.0
2019-10-01	ARKG	ETF	29.72	30.05	28.42	28.52	124800.0
2019-10-01	ARKK	ETF	43.14	43.35	41.86	41.9	280700.0
2019-10-01	ARKQ	ETF	31.72	31.99	31.21	31.21	28500.0
2019-10-01	ARKW	ETF	48.77	48.98	48.201	48.22	42300.0

> showing 50 of 1,848 rows — these rows as CSV

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