PREVIEW / etf_daily / 2018-10-08

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-08.parquet
  size:    63 KB
  rows:    1,624

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-08	SPY	ETF	287.05	288.22	285.5	287.82	87742200.0
2018-10-08	QQQ	ETF	179.37	180.6427	176.93	179.05	66864481.0
2018-10-08	IWM	ETF	161.77	162.4	160.55	161.82	21330700.0
2018-10-08	DIA	ETF	263.25	265.21	262.08	264.83	6236400.0
2018-10-08	GLD	ETF	112.25	112.59	111.9	112.54	12111600.0
2018-10-08	TLT	ETF	112.99	113.11	112.64	112.66	5855900.0
2018-10-08	AAAU	ETF	11.86	11.87	11.83	11.86	168200.0
2018-10-08	AADR	ETF	50.81	50.81	49.75	50.24	27000.0
2018-10-08	AAXJ	ETF	65.68	66.31	65.58	66.19	536200.0
2018-10-08	ACES	ETF	24.63	24.63	24.63	24.63	100.0
2018-10-08	ACSI	ETF	33.6599	33.6894	33.6599	33.67	1282.0
2018-10-08	ACTX	ETF	88.5008	139.8313	85.5508	134.5212	17018.0
2018-10-08	ACWF	ETF	29.96	30.01	29.72	29.96	4845.0
2018-10-08	ACWI	ETF	72.56	72.88	72.2	72.83	2684300.0
2018-10-08	ACWV	ETF	86.21	86.7	86.2	86.66	152700.0
2018-10-08	ACWX	ETF	46.03	46.26	45.84	46.25	588159.0
2018-10-08	ADRE	ETF	39.2	39.47	39.039	39.46	42644.0
2018-10-08	AFIF	ETF	10.05	10.07	10.03	10.0501	8401.0
2018-10-08	AFK	ETF	20.6	20.7501	20.6	20.68	19160.0
2018-10-08	AFTY	ETF	14.49	14.59	14.4	14.46	6300.0
2018-10-08	AGG	ETF	104.38	104.4	104.29	104.29	2268000.0
2018-10-08	AGGY	ETF	47.71	47.743	47.66	47.66	147900.0
2018-10-08	AGNG	ETF	21.63	21.63	21.43	21.43	1000.0
2018-10-08	AGQ	ETF	23.07	23.3	22.88	23.29	188700.0
2018-10-08	AGZ	ETF	109.98	110.0989	109.961	110.005	6788.0
2018-10-08	AGZD	ETF	23.97	23.97	23.925	23.925	3600.0
2018-10-08	AIA	ETF	58.51	58.98	58.45	58.935	36825.0
2018-10-08	AIEQ	ETF	28.77	28.86	28.494	28.71	89400.0
2018-10-08	AIQ	ETF	15.24	15.3	14.9501	15.13	241063.0
2018-10-08	AIRR	ETF	27.115	27.31	27.09	27.31	2500.0
2018-10-08	AIVI	ETF	41.04	41.14	40.87	41.14	10400.0
2018-10-08	ALTY	ETF	14.7	14.85	14.7	14.79	5000.0
2018-10-08	AMJ	ETF	27.81	28.045	27.675	27.84	820522.0
2018-10-08	AMLP	ETF	53.95	54.3	53.6	54.0	2107260.0
2018-10-08	AMZA	ETF	75.5	75.7	75.0	75.5	62020.0
2018-10-08	ANGL	ETF	28.64	28.69	28.57	28.58	309600.0
2018-10-08	AOA	ETF	53.38	53.52	53.18	53.5	45600.0
2018-10-08	AOK	ETF	33.62	33.69	33.58	33.64	96984.0
2018-10-08	AOM	ETF	37.12	37.19	37.05	37.14	87851.0
2018-10-08	AOR	ETF	44.14	44.2421	44.02	44.17	86792.0
2018-10-08	ARGT	ETF	25.87	26.51	25.87	26.37	203400.0
2018-10-08	ARKG	ETF	30.18	30.3	29.43	29.74	193500.0
2018-10-08	ARKK	ETF	43.76	44.078	42.55	43.16	534200.0
2018-10-08	ARKQ	ETF	34.25	34.34	33.43	33.78	87100.0
2018-10-08	ARKW	ETF	54.55	54.9	52.96	53.76	323000.0
2018-10-08	ARVR	ETF	20.375	20.41	20.2529	20.41	1111.0
2018-10-08	ASEA	ETF	15.73	15.74	15.56	15.56	1500.0
2018-10-08	ASET	ETF	27.35	27.53	27.35	27.53	1592.0
2018-10-08	ASHR	ETF	23.89	24.11	23.87	24.06	1700700.0
2018-10-08	ASHS	ETF	24.39	24.43	24.29	24.4	4700.0

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

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