PREVIEW / etf_daily / 2018-10-12

all etf daily files

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

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-12	SPY	ETF	276.77	277.09	272.37	275.95	183186500.0
2018-10-12	QQQ	ETF	173.99	174.86	170.9328	174.32	102078388.0
2018-10-12	IWM	ETF	155.56	155.76	151.89	153.6	53492600.0
2018-10-12	DIA	ETF	254.36	254.61	249.93	253.3	8634400.0
2018-10-12	GLD	ETF	115.58	115.71	115.08	115.23	12939300.0
2018-10-12	TLT	ETF	114.39	115.01	114.28	114.47	6794100.0
2018-10-12	AAAU	ETF	12.21	12.21	12.17	12.2	20300.0
2018-10-12	AADR	ETF	49.15	49.15	48.24	48.71	25400.0
2018-10-12	AAXJ	ETF	64.78	65.18	64.16	64.98	2205200.0
2018-10-12	ACES	ETF	23.52	23.73	23.52	23.62	1900.0
2018-10-12	ACSI	ETF	32.6659	32.6659	32.6659	32.6659	997.0
2018-10-12	ACTX	ETF	121.8361	153.4014	121.5411	143.2533	7813.0
2018-10-12	ACWF	ETF	28.74	28.8515	28.59	28.8515	19553.0
2018-10-12	ACWI	ETF	70.49	70.49	69.34	70.23	5689200.0
2018-10-12	ACWV	ETF	84.27	84.4	83.45	84.19	710300.0
2018-10-12	ACWX	ETF	44.96	44.98	44.37	44.83	1471289.0
2018-10-12	ADRE	ETF	38.59	38.85	38.348	38.42	16417.0
2018-10-12	AFIF	ETF	10.02	10.0616	10.02	10.0398	14517.0
2018-10-12	AFK	ETF	20.51	21.24	20.1	20.75	14713.0
2018-10-12	AFTY	ETF	14.46	14.46	14.25	14.37	12900.0
2018-10-12	AGG	ETF	104.71	104.87	104.68	104.75	5017400.0
2018-10-12	AGGY	ETF	47.88	47.939	47.848	47.848	34800.0
2018-10-12	AGNG	ETF	20.68	20.91	20.65	20.687	1700.0
2018-10-12	AGQ	ETF	24.15	24.22	23.79	24.0	112600.0
2018-10-12	AGZ	ETF	110.331	110.4589	110.31	110.3511	5930.0
2018-10-12	AGZD	ETF	23.945	23.97	23.89	23.96	11600.0
2018-10-12	AIA	ETF	57.56	57.65	56.86	57.53	53200.0
2018-10-12	AIEQ	ETF	27.7	27.815	27.207	27.6	77700.0
2018-10-12	AIQ	ETF	14.46	14.5748	14.3899	14.5748	17322.0
2018-10-12	AIRR	ETF	26.21	26.311	25.262	25.482	17700.0
2018-10-12	AIVI	ETF	40.36	40.36	39.82	40.16	7600.0
2018-10-12	ALTY	ETF	14.8	14.8	14.4	14.406	18500.0
2018-10-12	AMJ	ETF	27.49	27.54	26.76	27.06	1639172.0
2018-10-12	AMLP	ETF	53.1	53.55	52.0	52.8	3091460.0
2018-10-12	AMZA	ETF	73.7	74.5	71.9	73.2	121170.0
2018-10-12	ANGL	ETF	28.58	28.7	28.58	28.69	217600.0
2018-10-12	AOA	ETF	52.03	52.07	51.51	51.95	97000.0
2018-10-12	AOK	ETF	33.39	33.45	33.23	33.29	184947.0
2018-10-12	AOM	ETF	36.66	36.75	36.5	36.67	125822.0
2018-10-12	AOR	ETF	43.31	43.4595	42.9699	43.27	195974.0
2018-10-12	ARGT	ETF	24.95	25.24	24.84	25.16	52100.0
2018-10-12	ARKG	ETF	29.15	29.419	28.64	29.1	121500.0
2018-10-12	ARKK	ETF	42.14	42.27	41.11	42.02	391300.0
2018-10-12	ARKQ	ETF	32.24	32.72	32.035	32.6	73900.0
2018-10-12	ARKW	ETF	52.11	52.5	51.01	52.07	149300.0
2018-10-12	ARVR	ETF	19.6408	19.6408	19.49	19.6229	1973.0
2018-10-12	ASEA	ETF	15.54	15.54	15.28	15.35	13500.0
2018-10-12	ASET	ETF	26.51	26.59	26.5	26.5	5062.0
2018-10-12	ASHR	ETF	23.4	23.46	23.13	23.43	2250500.0
2018-10-12	ASHS	ETF	23.0	23.02	22.65	22.85	39400.0

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

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