PREVIEW / etf_daily / 2018-10-26

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-26.parquet
  size:    64 KB
  rows:    1,658

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
2018-10-26	SPY	ETF	265.92	271.0	262.29	265.33	201574600.0
2018-10-26	QQQ	ETF	165.24	169.96	164.23	166.66	130970908.0
2018-10-26	IWM	ETF	147.54	149.42	144.7	147.48	36986100.0
2018-10-26	DIA	ETF	247.38	249.04	244.31	246.53	5882900.0
2018-10-26	GLD	ETF	116.83	117.65	116.46	116.77	15733100.0
2018-10-26	TLT	ETF	114.93	115.32	114.79	114.99	18582500.0
2018-10-26	AAAU	ETF	12.34	12.42	12.32	12.35	216400.0
2018-10-26	AADR	ETF	46.06	46.22	45.3	45.8	27900.0
2018-10-26	AAXJ	ETF	61.55	62.59	61.31	62.0	1922800.0
2018-10-26	ACES	ETF	23.57	23.78	23.57	23.78	3500.0
2018-10-26	ACSI	ETF	31.59	31.88	31.59	31.66	2104.0
2018-10-26	ACTX	ETF	95.2859	100.8909	85.5508	88.5008	1722.0
2018-10-26	ACWF	ETF	27.43	27.6101	27.1207	27.43	10800.0
2018-10-26	ACWI	ETF	67.36	68.15	66.63	67.47	9071100.0
2018-10-26	ACWV	ETF	82.82	83.17	82.06	82.73	206400.0
2018-10-26	ACWX	ETF	42.87	43.47	42.6	43.21	1596379.0
2018-10-26	ADRE	ETF	36.74	37.549	36.6101	37.35	3613.0
2018-10-26	AFIF	ETF	10.04	10.06	9.97	10.03	63585.0
2018-10-26	AFK	ETF	20.18	20.1999	19.92	20.1054	4987.0
2018-10-26	AFTY	ETF	14.47	14.58	14.361	14.55	9100.0
2018-10-26	AGG	ETF	104.88	105.05	104.87	104.9	5811400.0
2018-10-26	AGGY	ETF	47.74	47.795	47.7	47.71	55600.0
2018-10-26	AGNG	ETF	19.29	19.44	19.0	19.44	2500.0
2018-10-26	AGQ	ETF	24.11	24.43	24.07	24.18	369700.0
2018-10-26	AGZ	ETF	110.66	110.77	110.66	110.77	12483.0
2018-10-26	AGZD	ETF	23.875	23.88	23.785	23.805	5600.0
2018-10-26	AIA	ETF	53.8	54.5959	53.55	54.22	65511.0
2018-10-26	AIEQ	ETF	26.01	26.255	25.6	25.86	96700.0
2018-10-26	AIQ	ETF	13.42	13.75	13.35	13.6318	9954.0
2018-10-26	AIRR	ETF	24.02	24.513	23.86	24.19	33600.0
2018-10-26	AIVI	ETF	38.86	39.35	38.67	39.05	10000.0
2018-10-26	ALTY	ETF	14.4	14.4	14.25	14.287	8600.0
2018-10-26	AMJ	ETF	25.79	25.79	25.1	25.4	1855109.0
2018-10-26	AMLP	ETF	49.75	49.85	48.6	49.0	4018000.0
2018-10-26	AMZA	ETF	65.1	65.3	62.75	64.0	162020.0
2018-10-26	ANGL	ETF	28.36	28.46	28.3	28.33	778800.0
2018-10-26	AOA	ETF	50.29	50.74	49.91	50.35	87500.0
2018-10-26	AOK	ETF	33.0	33.0999	32.91	33.06	85805.0
2018-10-26	AOM	ETF	36.08	36.3	36.006	36.17	143386.0
2018-10-26	AOR	ETF	42.27	42.54	42.05	42.33	73805.0
2018-10-26	ARGT	ETF	23.96	24.76	23.82	24.47	40400.0
2018-10-26	ARKG	ETF	26.18	27.0	25.98	26.6	122400.0
2018-10-26	ARKK	ETF	39.98	41.76	39.86	40.9	327700.0
2018-10-26	ARKQ	ETF	30.97	32.19	30.97	31.6	31100.0
2018-10-26	ARKW	ETF	49.97	51.51	49.31	50.34	232100.0
2018-10-26	ARVR	ETF	19.78	19.78	18.1	18.42	1282.0
2018-10-26	ASEA	ETF	15.0	15.0	14.92	14.99	600.0
2018-10-26	ASET	ETF	26.09	26.3801	26.08	26.1701	17338.0
2018-10-26	ASHR	ETF	23.16	23.42	23.04	23.28	3213200.0
2018-10-26	ASHS	ETF	22.17	22.44	22.17	22.3	11700.0

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

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