PREVIEW / etf_daily / 2018-10-31

all etf daily files

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

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-31	SPY	ETF	270.65	273.23	270.12	270.63	128296300.0
2018-10-31	QQQ	ETF	168.55	171.25	168.54	169.82	73828635.0
2018-10-31	IWM	ETF	151.26	151.86	150.03	150.03	36785400.0
2018-10-31	DIA	ETF	250.94	253.22	250.39	251.19	5376400.0
2018-10-31	GLD	ETF	114.89	115.17	114.66	115.15	11409300.0
2018-10-31	TLT	ETF	113.74	113.96	113.21	113.58	8706400.0
2018-10-31	AAAU	ETF	12.15	12.17	12.12	12.17	16900.0
2018-10-31	AADR	ETF	46.13	46.81	46.13	46.41	15800.0
2018-10-31	AAXJ	ETF	63.07	63.33	62.77	62.99	865900.0
2018-10-31	ACES	ETF	24.36	24.36	24.19	24.27	13000.0
2018-10-31	ACSI	ETF	32.4043	32.4043	32.4	32.4	853.0
2018-10-31	ACTX	ETF	64.9006	87.3208	63.7206	74.3407	2698.0
2018-10-31	ACWF	ETF	28.1026	28.29	28.1	28.27	14632.0
2018-10-31	ACWI	ETF	68.72	69.19	68.58	68.74	3397900.0
2018-10-31	ACWV	ETF	84.06	84.36	83.73	83.76	168500.0
2018-10-31	ACWX	ETF	43.89	44.0701	43.82	43.89	1413893.0
2018-10-31	ADRE	ETF	37.5	37.6	37.2904	37.46	7205.0
2018-10-31	AFIF	ETF	10.0468	10.06	10.02	10.02	9205.0
2018-10-31	AFK	ETF	20.12	20.12	20.09	20.09	1382.0
2018-10-31	AFTY	ETF	14.32	14.36	14.25	14.305	16400.0
2018-10-31	AGG	ETF	104.5	104.7	104.5	104.59	14880500.0
2018-10-31	AGGY	ETF	47.52	47.589	47.49	47.52	124700.0
2018-10-31	AGNG	ETF	19.711	19.711	19.711	19.711	200.0
2018-10-31	AGQ	ETF	22.85	22.96	22.71	22.77	322100.0
2018-10-31	AGZ	ETF	110.4	110.5575	110.39	110.53	33015.0
2018-10-31	AGZD	ETF	23.84	23.84	23.735	23.785	14600.0
2018-10-31	AIA	ETF	54.99	55.32	54.89	55.05	23077.0
2018-10-31	AIEQ	ETF	26.42	26.78	26.35	26.54	61100.0
2018-10-31	AIQ	ETF	13.91	13.91	13.82	13.9099	2881.0
2018-10-31	AIRR	ETF	24.68	24.68	24.32	24.32	45800.0
2018-10-31	AIVI	ETF	39.66	39.77	39.63	39.63	18000.0
2018-10-31	ALTY	ETF	14.3	14.509	14.3	14.39	5400.0
2018-10-31	AMJ	ETF	25.25	25.7	24.99	24.99	1963405.0
2018-10-31	AMLP	ETF	49.2	50.05	48.95	49.1	4717620.0
2018-10-31	AMZA	ETF	64.0	65.5	63.5	64.2	106480.0
2018-10-31	ANGL	ETF	28.21	28.35	28.19	28.2	1135500.0
2018-10-31	AOA	ETF	51.11	51.33	51.03	51.03	59900.0
2018-10-31	AOK	ETF	33.11	33.19	33.1	33.12	42679.0
2018-10-31	AOM	ETF	36.36	36.4898	36.311	36.33	209001.0
2018-10-31	AOR	ETF	42.75	42.9	42.652	42.74	122965.0
2018-10-31	ARGT	ETF	24.9	25.35	24.74	25.32	21800.0
2018-10-31	ARKG	ETF	27.44	27.995	27.44	27.64	70200.0
2018-10-31	ARKK	ETF	42.28	43.151	42.28	42.58	327600.0
2018-10-31	ARKQ	ETF	32.02	32.745	32.02	32.45	8500.0
2018-10-31	ARKW	ETF	52.29	53.89	52.29	53.42	281300.0
2018-10-31	ARVR	ETF	18.6956	18.7634	18.67	18.7634	1853.0
2018-10-31	ASEA	ETF	15.34	15.34	15.13	15.3	1200.0
2018-10-31	ASET	ETF	26.5	26.57	26.5	26.5402	1302.0
2018-10-31	ASHR	ETF	23.04	23.26	23.03	23.23	4730000.0
2018-10-31	ASHS	ETF	22.67	22.68	22.51	22.6	7500.0

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

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