PREVIEW / etf_daily / 2018-10-29

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-29.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-29	SPY	ETF	268.8	270.25	259.85	263.86	160749100.0
2018-10-29	QQQ	ETF	169.16	169.86	160.09	163.23	111871933.0
2018-10-29	IWM	ETF	149.13	150.63	145.07	146.67	33031300.0
2018-10-29	DIA	ETF	248.72	250.24	241.05	244.47	6833300.0
2018-10-29	GLD	ETF	116.41	116.54	115.84	116.31	8732500.0
2018-10-29	TLT	ETF	114.84	115.02	114.26	114.73	7679900.0
2018-10-29	AAAU	ETF	12.31	12.31	12.25	12.3	13400.0
2018-10-29	AADR	ETF	46.33	46.33	44.82	45.23	25600.0
2018-10-29	AAXJ	ETF	62.41	62.47	60.48	61.12	1547600.0
2018-10-29	ACES	ETF	24.01	24.01	23.46	23.46	600.0
2018-10-29	ACSI	ETF	32.0181	32.06	31.7	31.7	2600.0
2018-10-29	ACTX	ETF	91.4508	97.3509	64.9006	76.7007	4541.0
2018-10-29	ACWF	ETF	27.6996	27.7861	27.13	27.24	17347.0
2018-10-29	ACWI	ETF	68.16	68.48	66.23	67.03	6536500.0
2018-10-29	ACWV	ETF	83.26	83.71	81.89	82.52	162600.0
2018-10-29	ACWX	ETF	43.61	43.715	42.56	42.94	1922525.0
2018-10-29	ADRE	ETF	37.59	37.68	35.8271	36.11	12200.0
2018-10-29	AFIF	ETF	10.02	10.04	9.94	10.0307	9223.0
2018-10-29	AFK	ETF	20.48	20.48	19.87	19.87	5820.0
2018-10-29	AFTY	ETF	14.02	14.02	13.735	13.82	13200.0
2018-10-29	AGG	ETF	104.86	104.89	104.72	104.79	5075100.0
2018-10-29	AGGY	ETF	47.73	47.73	47.66	47.693	33200.0
2018-10-29	AGNG	ETF	19.5	19.603	19.25	19.25	1500.0
2018-10-29	AGQ	ETF	24.07	24.14	23.22	23.38	125000.0
2018-10-29	AGZ	ETF	110.6999	110.6999	110.551	110.69	36687.0
2018-10-29	AGZD	ETF	23.765	23.87	23.745	23.805	14000.0
2018-10-29	AIA	ETF	54.6	54.71	53.045	53.63	31766.0
2018-10-29	AIEQ	ETF	26.22	26.37	25.305	25.623	68300.0
2018-10-29	AIQ	ETF	13.71	13.73	13.0088	13.18	9540.0
2018-10-29	AIRR	ETF	24.491	24.64	23.88	24.09	12700.0
2018-10-29	AIVI	ETF	39.57	39.61	38.93	38.93	5200.0
2018-10-29	ALTY	ETF	14.29	14.455	14.29	14.29	1900.0
2018-10-29	AMJ	ETF	25.69	25.69	24.77	25.29	1751285.0
2018-10-29	AMLP	ETF	49.5	49.65	47.95	48.7	3712660.0
2018-10-29	AMZA	ETF	64.2	64.45	61.22	62.1	193180.0
2018-10-29	ANGL	ETF	28.34	28.42	28.19	28.23	543400.0
2018-10-29	AOA	ETF	50.83	51.0	49.67	50.09	42800.0
2018-10-29	AOK	ETF	33.11	33.26	32.92	32.93	74108.0
2018-10-29	AOM	ETF	36.3	36.4	35.9	36.06	181169.0
2018-10-29	AOR	ETF	42.58	42.6522	41.8801	42.1	93978.0
2018-10-29	ARCM	ETF	100.213	100.213	100.213	100.213	200.0
2018-10-29	ARGT	ETF	24.67	24.87	23.7	23.97	41600.0
2018-10-29	ARKG	ETF	27.0	27.4	25.68	26.1	123500.0
2018-10-29	ARKK	ETF	41.97	42.19	39.75	40.49	254500.0
2018-10-29	ARKQ	ETF	32.03	32.33	30.7	31.21	11900.0
2018-10-29	ARKW	ETF	51.88	52.065	48.78	49.81	129400.0
2018-10-29	ARVR	ETF	18.95	18.96	18.59	18.59	1417.0
2018-10-29	ASEA	ETF	15.04	15.04	14.66	14.66	1900.0
2018-10-29	ASET	ETF	26.5589	26.59	26.2	26.2	23205.0
2018-10-29	ASHR	ETF	22.64	22.72	22.1	22.25	5753100.0

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

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