PREVIEW / etf_daily / 2019-10-31

all etf daily files

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

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-31	SPY	ETF	304.13	304.13	301.73	303.33	69053800.0
2019-10-31	QQQ	ETF	197.56	197.65	195.94	197.08	26801803.0
2019-10-31	IWM	ETF	156.1	156.1	154.24	155.45	17344200.0
2019-10-31	DIA	ETF	271.57	271.66	269.07	270.48	3021000.0
2019-10-31	GLD	ETF	141.98	142.69	141.89	142.43	7050900.0
2019-10-31	TLT	ETF	140.48	141.68	140.43	141.24	15834100.0
2019-10-31	AAAU	ETF	15.04	15.11	15.03	15.08	126900.0
2019-10-31	AADR	ETF	50.65	50.65	50.21	50.43	3800.0
2019-10-31	AAXJ	ETF	69.52	69.54	68.93	69.3	588900.0
2019-10-31	ACES	ETF	31.285	31.299	31.07	31.227	8100.0
2019-10-31	ACSI	ETF	34.432	34.432	34.21	34.4228	6351.0
2019-10-31	ACTX	ETF	8.3191	10.0301	8.3191	10.0301	161.0
2019-10-31	ACWF	ETF	29.71	29.79	29.6236	29.6792	103388.0
2019-10-31	ACWI	ETF	75.86	75.93	75.4	75.77	3823800.0
2019-10-31	ACWV	ETF	95.65	95.66	95.31	95.66	103100.0
2019-10-31	ACWX	ETF	47.57	47.57	47.3039	47.47	1588586.0
2019-10-31	ADRE	ETF	40.71	40.71	40.33	40.33	3520.0
2019-10-31	AFIF	ETF	9.73	9.745	9.72	9.745	9275.0
2019-10-31	AFK	ETF	20.25	20.2851	20.25	20.2851	829.0
2019-10-31	AFTY	ETF	17.32	17.36	17.32	17.358	300.0
2019-10-31	AGG	ETF	112.98	113.3	112.89	113.15	5399100.0
2019-10-31	AGGY	ETF	52.23	52.33	52.19	52.33	1450400.0
2019-10-31	AGNG	ETF	22.4	22.51	22.4	22.51	800.0
2019-10-31	AGQ	ETF	32.88	33.36	32.66	33.04	306200.0
2019-10-31	AGZ	ETF	116.31	116.5	116.24	116.43	27459.0
2019-10-31	AGZD	ETF	23.92	23.945	23.865	23.865	4000.0
2019-10-31	AIA	ETF	61.37	61.37	60.8623	61.15	33585.0
2019-10-31	AIEQ	ETF	26.7	26.747	26.5	26.54	11600.0
2019-10-31	AIQ	ETF	16.44	16.44	16.2	16.3198	4465.0
2019-10-31	AIRR	ETF	28.11	28.11	27.786	27.91	2500.0
2019-10-31	AIVI	ETF	41.85	41.85	41.59	41.71	5300.0
2019-10-31	ALTY	ETF	14.82	14.85	14.802	14.85	5100.0
2019-10-31	AMJ	ETF	21.81	21.89	21.61	21.75	1556294.0
2019-10-31	AMLP	ETF	42.75	42.85	42.3	42.7	4155040.0
2019-10-31	AMUB	ETF	13.7106	13.7106	13.7106	13.7106	0.0
2019-10-31	AMZA	ETF	44.9	45.0	44.0	44.6	90340.0
2019-10-31	ANGL	ETF	29.41	29.41	29.26	29.27	378000.0
2019-10-31	AOA	ETF	56.05	56.05	55.71	55.88	42800.0
2019-10-31	AOK	ETF	35.96	35.96	35.8	35.89	45563.0
2019-10-31	AOM	ETF	39.39	39.4962	39.39	39.45	87207.0
2019-10-31	AOR	ETF	46.66	46.66	46.46	46.57	58792.0
2019-10-31	ARCM	ETF	100.17	100.245	100.17	100.245	2400.0
2019-10-31	ARGT	ETF	21.95	22.09	21.71	21.88	40500.0
2019-10-31	ARKF	ETF	22.27	22.27	22.11	22.231	5100.0
2019-10-31	ARKG	ETF	29.92	30.38	29.721	29.96	230500.0
2019-10-31	ARKK	ETF	44.28	44.66	43.841	44.23	157000.0
2019-10-31	ARKQ	ETF	33.44	33.44	33.15	33.38	7500.0
2019-10-31	ARKW	ETF	51.61	51.708	50.903	51.47	222400.0
2019-10-31	ASEA	ETF	15.89	15.94	15.84	15.9	8000.0
2019-10-31	ASET	ETF	30.3236	30.3236	30.27	30.27	599.0

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

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