PREVIEW / etf_daily / 2019-10-24

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-24.parquet
  size:    70 KB
  rows:    1,840

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-24	SPY	ETF	300.91	301.07	299.46	300.37	35453100.0
2019-10-24	QQQ	ETF	193.62	194.21	192.74	194.09	19264220.0
2019-10-24	IWM	ETF	154.95	155.06	153.47	154.18	9091400.0
2019-10-24	DIA	ETF	269.02	269.12	267.06	267.98	1843700.0
2019-10-24	GLD	ETF	141.02	141.74	140.93	141.53	6174800.0
2019-10-24	TLT	ETF	139.68	140.24	139.03	139.2	6161700.0
2019-10-24	AAAU	ETF	14.93	15.01	14.92	15.0	185300.0
2019-10-24	AADR	ETF	48.83	49.44	48.83	49.44	12600.0
2019-10-24	AAXJ	ETF	68.83	68.83	68.58	68.71	706300.0
2019-10-24	ACES	ETF	31.66	31.69	31.35	31.385	7400.0
2019-10-24	ACIO	ETF	24.88	24.88	24.731	24.743	1500.0
2019-10-24	ACSI	ETF	34.4361	34.4361	34.31	34.4335	1213.0
2019-10-24	ACTX	ETF	11.8001	11.8001	10.0891	11.1393	404.0
2019-10-24	ACWF	ETF	29.5	29.5181	29.44	29.5181	7273.0
2019-10-24	ACWI	ETF	75.31	75.35	74.98	75.2	1295200.0
2019-10-24	ACWV	ETF	95.25	95.3	94.98	95.16	179400.0
2019-10-24	ACWX	ETF	47.37	47.37	47.185	47.3	888563.0
2019-10-24	ADRE	ETF	39.98	40.0047	39.975	40.0047	2534.0
2019-10-24	AFIF	ETF	9.66	9.716	9.66	9.715	9958.0
2019-10-24	AFK	ETF	20.52	20.52	20.35	20.41	2727.0
2019-10-24	AFTY	ETF	17.43	17.43	17.338	17.368	3300.0
2019-10-24	AGG	ETF	112.84	112.95	112.75	112.78	1725800.0
2019-10-24	AGGY	ETF	52.17	52.2	52.1	52.15	185300.0
2019-10-24	AGNG	ETF	21.954	22.11	21.938	21.938	1300.0
2019-10-24	AGQ	ETF	31.96	32.18	31.76	32.03	211800.0
2019-10-24	AGZ	ETF	116.15	116.2628	116.08	116.08	54382.0
2019-10-24	AGZD	ETF	23.885	23.97	23.815	23.895	14800.0
2019-10-24	AIA	ETF	60.99	60.99	60.78	60.95	87487.0
2019-10-24	AIEQ	ETF	26.27	26.49	26.27	26.37	11700.0
2019-10-24	AIQ	ETF	15.9347	16.0374	15.9347	16.0374	2062.0
2019-10-24	AIRR	ETF	28.06	28.06	27.6	27.71	2700.0
2019-10-24	AIVI	ETF	41.73	41.77	41.7	41.77	1900.0
2019-10-24	ALTY	ETF	14.901	14.91	14.83	14.83	8700.0
2019-10-24	AMJ	ETF	22.15	22.21	21.96	22.06	1285733.0
2019-10-24	AMLP	ETF	43.45	43.65	43.1	43.25	2924500.0
2019-10-24	AMUB	ETF	13.9009	13.9009	13.9009	13.9009	0.0
2019-10-24	AMZA	ETF	46.0	46.1	45.55	45.9	72420.0
2019-10-24	ANGL	ETF	29.4	29.41	29.36	29.38	284100.0
2019-10-24	AOA	ETF	55.72	55.72	55.48	55.57	73100.0
2019-10-24	AOK	ETF	35.85	35.89	35.7211	35.74	52487.0
2019-10-24	AOM	ETF	39.42	39.42	39.27	39.34	127670.0
2019-10-24	AOR	ETF	46.35	46.374	46.31	46.37	74091.0
2019-10-24	ARGT	ETF	22.42	22.53	22.36	22.44	99600.0
2019-10-24	ARKF	ETF	21.7	21.995	21.7	21.995	4000.0
2019-10-24	ARKG	ETF	28.57	28.57	28.195	28.46	66800.0
2019-10-24	ARKK	ETF	42.55	42.73	42.19	42.65	239600.0
2019-10-24	ARKQ	ETF	32.96	33.005	32.6	32.96	8000.0
2019-10-24	ARKW	ETF	49.69	50.33	49.641	50.31	37800.0
2019-10-24	ASEA	ETF	15.73	15.73	15.73	15.73	900.0
2019-10-24	ASET	ETF	30.35	30.35	30.35	30.35	182.0

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

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