PREVIEW / etf_daily / 2019-10-11

all etf daily files

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

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-11	SPY	ETF	296.27	298.74	296.14	296.28	98720400.0
2019-10-11	QQQ	ETF	190.8	192.63	190.72	191.11	41428907.0
2019-10-11	IWM	ETF	149.79	151.96	147.69	150.22	29236300.0
2019-10-11	DIA	ETF	267.77	270.14	267.62	268.16	4177000.0
2019-10-11	GLD	ETF	139.97	140.19	138.91	140.03	11333400.0
2019-10-11	TLT	ETF	140.98	141.1	139.71	140.44	26294000.0
2019-10-11	AAAU	ETF	14.83	14.83	14.71	14.82	153900.0
2019-10-11	AADR	ETF	48.48	48.48	48.15	48.23	2500.0
2019-10-11	AAXJ	ETF	67.69	68.32	67.64	67.69	2070100.0
2019-10-11	ACES	ETF	31.35	31.35	30.961	30.961	9500.0
2019-10-11	ACIO	ETF	24.59	24.618	24.54	24.54	13300.0
2019-10-11	ACSI	ETF	33.8927	34.0	33.8483	33.8483	2584.0
2019-10-11	ACTX	ETF	12.3901	14.1601	12.3901	14.1601	182.0
2019-10-11	ACWF	ETF	28.91	29.25	28.91	29.0727	9624.0
2019-10-11	ACWI	ETF	73.88	74.45	73.85	73.97	4277500.0
2019-10-11	ACWV	ETF	95.1	95.29	94.69	94.7	291100.0
2019-10-11	ACWX	ETF	46.31	46.63	46.31	46.36	1833273.0
2019-10-11	ADRE	ETF	39.28	39.6585	39.28	39.559	3969.0
2019-10-11	AFIF	ETF	9.74	9.74	9.7	9.71	21530.0
2019-10-11	AFK	ETF	20.3027	20.3027	20.24	20.24	1557.0
2019-10-11	AFTY	ETF	17.476	17.577	17.43	17.44	12700.0
2019-10-11	AGG	ETF	112.84	112.85	112.59	112.73	3568600.0
2019-10-11	AGGY	ETF	52.2	52.2	52.1	52.12	141200.0
2019-10-11	AGNG	ETF	21.52	21.619	21.355	21.355	2900.0
2019-10-11	AGQ	ETF	31.14	31.22	30.47	31.07	405700.0
2019-10-11	AGZ	ETF	116.26	116.26	116.0236	116.07	24296.0
2019-10-11	AGZD	ETF	23.87	23.925	23.87	23.88	7000.0
2019-10-11	AIA	ETF	60.08	60.58	60.08	60.11	145834.0
2019-10-11	AIEQ	ETF	26.21	26.47	26.21	26.25	21700.0
2019-10-11	AIQ	ETF	16.1371	16.246	16.1364	16.1364	11039.0
2019-10-11	AIRR	ETF	26.81	27.07	26.64	26.64	7500.0
2019-10-11	AIVI	ETF	40.72	40.98	40.72	40.81	9600.0
2019-10-11	ALTY	ETF	14.7	14.78	14.65	14.71	17400.0
2019-10-11	AMJ	ETF	22.46	22.49	22.28	22.35	1894387.0
2019-10-11	AMLP	ETF	44.3	44.3	43.9	44.1	2839740.0
2019-10-11	AMUB	ETF	14.063	14.063	14.063	14.063	0.0
2019-10-11	AMZA	ETF	47.3	47.3	46.8	47.0	69510.0
2019-10-11	ANGL	ETF	29.12	29.24	29.12	29.17	294300.0
2019-10-11	AOA	ETF	54.73	55.07	54.73	54.8	30500.0
2019-10-11	AOK	ETF	35.47	35.6022	35.47	35.54	65321.0
2019-10-11	AOM	ETF	39.01	39.14	39.01	39.07	81249.0
2019-10-11	AOR	ETF	45.79	46.0094	45.79	45.88	69575.0
2019-10-11	ARCM	ETF	100.15	100.19	100.15	100.19	300.0
2019-10-11	ARGT	ETF	23.27	23.34	23.11	23.17	19900.0
2019-10-11	ARKF	ETF	21.66	21.861	21.66	21.721	10600.0
2019-10-11	ARKG	ETF	28.72	29.13	28.56	28.56	72400.0
2019-10-11	ARKK	ETF	41.94	42.52	41.9	41.93	242600.0
2019-10-11	ARKQ	ETF	32.0	32.19	31.86	31.88	36600.0
2019-10-11	ARKW	ETF	49.21	49.82	49.21	49.3	57700.0
2019-10-11	ASEA	ETF	15.69	15.72	15.65	15.7	13200.0

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

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