PREVIEW / etf_daily / 2018-10-16

all etf daily files

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

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-16	SPY	ETF	276.6	280.82	276.07	280.4	118255800.0
2018-10-16	QQQ	ETF	174.02	177.65	173.7	177.22	71979688.0
2018-10-16	IWM	ETF	155.28	158.86	154.04	158.64	35569100.0
2018-10-16	DIA	ETF	254.62	258.11	253.98	257.92	7099800.0
2018-10-16	GLD	ETF	116.49	116.6	115.8	115.8	9531800.0
2018-10-16	TLT	ETF	114.39	114.72	114.16	114.68	4762300.0
2018-10-16	AAAU	ETF	12.31	12.31	12.24	12.24	18700.0
2018-10-16	AADR	ETF	49.2	50.36	49.2	50.33	29500.0
2018-10-16	AAXJ	ETF	64.72	65.57	64.71	65.53	701700.0
2018-10-16	ACES	ETF	24.12	24.12	24.12	24.12	100.0
2018-10-16	ACSI	ETF	32.7501	33.06	32.7501	33.06	1907.0
2018-10-16	ACTX	ETF	165.2015	171.1015	135.7012	145.1413	6259.0
2018-10-16	ACWF	ETF	28.88	29.255	28.875	29.2	58962.0
2018-10-16	ACWI	ETF	70.53	71.39	70.43	71.26	8686000.0
2018-10-16	ACWV	ETF	84.74	85.58	84.53	85.48	159400.0
2018-10-16	ACWX	ETF	45.23	45.58	45.16	45.54	1607954.0
2018-10-16	ADRE	ETF	38.93	39.35	38.9176	39.35	4667.0
2018-10-16	AFIF	ETF	10.05	10.05	10.0	10.0101	112546.0
2018-10-16	AFK	ETF	21.0752	21.2	20.97	21.19	4925.0
2018-10-16	AFTY	ETF	14.324	14.41	14.324	14.41	2500.0
2018-10-16	AGG	ETF	104.69	104.74	104.58	104.74	5750100.0
2018-10-16	AGGY	ETF	47.86	47.86	47.794	47.84	32400.0
2018-10-16	AGNG	ETF	20.9	21.213	20.814	21.213	2100.0
2018-10-16	AGQ	ETF	24.58	24.63	24.06	24.06	89200.0
2018-10-16	AGZ	ETF	110.4	110.44	110.3	110.3789	11201.0
2018-10-16	AGZD	ETF	23.965	23.985	23.885	23.965	4400.0
2018-10-16	AIA	ETF	57.07	57.85	57.07	57.85	179594.0
2018-10-16	AIEQ	ETF	27.7	28.139	27.65	28.11	93300.0
2018-10-16	AIQ	ETF	14.5794	14.82	14.5794	14.82	3231.0
2018-10-16	AIRR	ETF	25.84	26.39	25.62	26.39	14700.0
2018-10-16	AIVI	ETF	40.89	41.07	40.89	41.07	9600.0
2018-10-16	ALTY	ETF	14.595	14.595	14.595	14.595	500.0
2018-10-16	AMJ	ETF	27.0	27.71	26.9	27.57	1318158.0
2018-10-16	AMLP	ETF	52.7	53.95	52.65	53.4	2464660.0
2018-10-16	AMZA	ETF	73.3	74.9	73.2	74.8	90220.0
2018-10-16	ANGL	ETF	28.71	28.79	28.71	28.73	226900.0
2018-10-16	AOA	ETF	52.14	52.64	52.13	52.61	105500.0
2018-10-16	AOK	ETF	33.36	33.5224	33.36	33.47	64431.0
2018-10-16	AOM	ETF	36.75	36.92	36.6331	36.89	112289.0
2018-10-16	AOR	ETF	43.39	43.7199	43.3714	43.66	59865.0
2018-10-16	ARCM	ETF	100.72	100.72	100.18	100.35	400.0
2018-10-16	ARGT	ETF	25.45	25.69	25.33	25.54	20400.0
2018-10-16	ARKG	ETF	29.075	30.24	28.901	30.15	104600.0
2018-10-16	ARKK	ETF	42.15	43.74	41.95	43.63	372400.0
2018-10-16	ARKQ	ETF	32.32	33.39	32.32	33.39	13700.0
2018-10-16	ARKW	ETF	52.3	53.98	52.291	53.87	110400.0
2018-10-16	ARVR	ETF	19.967	19.9671	19.95	19.95	1033.0
2018-10-16	ASEA	ETF	15.59	15.61	15.57	15.61	3200.0
2018-10-16	ASET	ETF	27.0791	27.0791	27.0791	27.0791	161.0
2018-10-16	ASHR	ETF	23.0	23.14	22.96	23.14	1628000.0

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

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