PREVIEW / etf_daily / 2019-10-15

all etf daily files

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

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-15	SPY	ETF	297.1	299.7	296.97	298.88	46754500.0
2019-10-15	QQQ	ETF	191.65	193.97	191.56	193.52	23735826.0
2019-10-15	IWM	ETF	150.17	152.13	149.79	151.39	16801200.0
2019-10-15	DIA	ETF	269.12	271.19	268.86	270.22	3168900.0
2019-10-15	GLD	ETF	140.27	140.3	139.21	139.61	9128300.0
2019-10-15	TLT	ETF	140.67	140.95	139.55	139.75	11832300.0
2019-10-15	AAAU	ETF	14.86	14.86	14.75	14.78	34100.0
2019-10-15	AADR	ETF	48.13	48.43	48.13	48.43	5700.0
2019-10-15	AAXJ	ETF	67.77	68.3	67.77	68.2	2018400.0
2019-10-15	ACES	ETF	30.73	30.89	30.73	30.864	4600.0
2019-10-15	ACIO	ETF	24.615	24.65	24.604	24.604	15200.0
2019-10-15	ACSI	ETF	33.7702	33.98	33.7702	33.9412	6600.0
2019-10-15	ACTX	ETF	13.9241	14.6321	11.2101	14.0421	100.0
2019-10-15	ACWF	ETF	28.98	29.31	28.98	29.2263	3984.0
2019-10-15	ACWI	ETF	74.05	74.7	74.03	74.51	2847400.0
2019-10-15	ACWV	ETF	94.73	94.94	94.62	94.75	133000.0
2019-10-15	ACWX	ETF	46.36	46.81	46.28	46.69	1020404.0
2019-10-15	ADRE	ETF	39.47	39.77	39.47	39.77	1061.0
2019-10-15	AFIF	ETF	9.705	9.705	9.695	9.695	3120.0
2019-10-15	AFK	ETF	19.91	20.49	19.91	20.169	2989.0
2019-10-15	AFTY	ETF	17.54	17.633	17.54	17.59	6800.0
2019-10-15	AGG	ETF	112.9	112.92	112.55	112.55	4168600.0
2019-10-15	AGGY	ETF	52.23	52.26	52.111	52.15	167400.0
2019-10-15	AGNG	ETF	21.49	21.582	21.34	21.534	3500.0
2019-10-15	AGQ	ETF	31.11	31.13	30.47	30.66	215500.0
2019-10-15	AGZ	ETF	116.17	116.26	116.015	116.06	28883.0
2019-10-15	AGZD	ETF	23.925	23.925	23.83	23.86	5200.0
2019-10-15	AIA	ETF	60.12	60.71	60.12	60.59	36661.0
2019-10-15	AIEQ	ETF	26.28	26.542	26.28	26.45	30200.0
2019-10-15	AIQ	ETF	16.2306	16.33	16.2306	16.33	13792.0
2019-10-15	AIRR	ETF	26.74	26.967	26.74	26.887	12600.0
2019-10-15	AIVI	ETF	40.84	41.23	40.83	41.13	9700.0
2019-10-15	ALTY	ETF	14.67	14.74	14.67	14.71	35300.0
2019-10-15	AMJ	ETF	22.16	22.42	22.1	22.18	1162179.0
2019-10-15	AMLP	ETF	43.75	44.15	43.5	43.85	2145820.0
2019-10-15	AMUB	ETF	14.0006	14.0006	14.0006	14.0006	0.0
2019-10-15	AMZA	ETF	46.4	47.2	46.2	46.7	40140.0
2019-10-15	ANGL	ETF	29.28	29.4	29.22	29.38	1340500.0
2019-10-15	AOA	ETF	54.87	55.23	54.87	55.15	29500.0
2019-10-15	AOK	ETF	35.6	35.635	35.54	35.595	54395.0
2019-10-15	AOM	ETF	39.05	39.19	39.03	39.17	120647.0
2019-10-15	AOR	ETF	45.85	46.12	45.84	46.01	91059.0
2019-10-15	ARGT	ETF	22.86	23.13	22.86	23.06	13400.0
2019-10-15	ARKF	ETF	21.75	22.098	21.75	22.07	12800.0
2019-10-15	ARKG	ETF	28.69	29.364	28.69	29.24	91400.0
2019-10-15	ARKK	ETF	42.5	43.29	42.44	43.15	175500.0
2019-10-15	ARKQ	ETF	32.39	32.779	32.39	32.63	11800.0
2019-10-15	ARKW	ETF	49.71	50.76	49.71	50.63	94200.0
2019-10-15	ASEA	ETF	15.62	15.69	15.61	15.64	3000.0
2019-10-15	ASET	ETF	29.95	29.998	29.95	29.998	1483.0

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

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