PREVIEW / etf_daily / 2017-11-29

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-29.parquet
  size:    59 KB
  rows:    1,515

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
2017-11-29	SPY	ETF	263.02	263.63	262.2	262.71	77512100.0
2017-11-29	QQQ	ETF	156.45	156.45	153.12	153.86	71986338.0
2017-11-29	IWM	ETF	153.34	154.21	152.95	153.37	38234200.0
2017-11-29	DIA	ETF	239.15	239.65	238.77	239.42	3376100.0
2017-11-29	GLD	ETF	122.24	122.33	121.74	122.04	6138900.0
2017-11-29	TLT	ETF	125.56	125.68	125.1	125.54	14547100.0
2017-11-29	AADR	ETF	56.84	56.84	55.6	55.76	24400.0
2017-11-29	AAXJ	ETF	77.13	77.13	76.06	76.33	1489200.0
2017-11-29	ACSI	ETF	30.679	30.7699	30.679	30.7451	1906.0
2017-11-29	ACTX	ETF	80.2407	80.2407	56.0505	62.1276	1931.0
2017-11-29	ACWF	ETF	30.7	30.7	30.5	30.5024	4477.0
2017-11-29	ACWI	ETF	71.66	71.71	71.26	71.38	1623800.0
2017-11-29	ACWV	ETF	84.33	84.43	84.2	84.34	145200.0
2017-11-29	ACWX	ETF	49.94	49.94	49.4954	49.58	2116414.0
2017-11-29	ADRE	ETF	43.33	43.33	42.3429	42.49	13798.0
2017-11-29	AFK	ETF	24.59	24.59	24.3849	24.44	10304.0
2017-11-29	AFTY	ETF	18.64	18.64	18.5	18.505	9900.0
2017-11-29	AGG	ETF	109.27	109.32	109.18	109.26	2423700.0
2017-11-29	AGGY	ETF	50.6	50.62	50.54	50.602	39700.0
2017-11-29	AGNG	ETF	19.67	19.678	19.547	19.547	4000.0
2017-11-29	AGQ	ETF	33.07	33.18	32.35	32.55	206700.0
2017-11-29	AGZ	ETF	113.44	113.44	113.4	113.4	5915.0
2017-11-29	AGZD	ETF	24.095	24.095	24.095	24.095	400.0
2017-11-29	AIA	ETF	66.98	67.05	66.1716	66.39	876401.0
2017-11-29	AIEQ	ETF	25.47	25.65	25.415	25.47	167100.0
2017-11-29	AIRR	ETF	26.65	27.19	26.65	27.15	54000.0
2017-11-29	AIVI	ETF	43.34	43.39	43.21	43.25	24400.0
2017-11-29	ALTY	ETF	15.45	15.45	15.409	15.409	2300.0
2017-11-29	AMJ	ETF	25.36	25.43	24.93	25.19	5943613.0
2017-11-29	AMLP	ETF	49.9	49.95	48.95	49.5	4405060.0
2017-11-29	AMZA	ETF	77.7	77.8	76.1	77.2	224280.0
2017-11-29	ANGL	ETF	30.15	30.16	30.11	30.12	598500.0
2017-11-29	AOA	ETF	55.13	55.18	54.97	54.98	124200.0
2017-11-29	AOK	ETF	34.84	34.87	34.74	34.74	550777.0
2017-11-29	AOM	ETF	38.53	38.53	38.37	38.38	247257.0
2017-11-29	AOR	ETF	45.8	45.8853	45.6343	45.66	141834.0
2017-11-29	ARCM	ETF	100.23	100.23	100.23	100.23	600.0
2017-11-29	ARGT	ETF	32.27	32.27	32.03	32.07	148600.0
2017-11-29	ARKG	ETF	25.48	25.51	24.824	25.0	34400.0
2017-11-29	ARKK	ETF	37.94	38.2	36.51	36.98	354600.0
2017-11-29	ARKQ	ETF	35.09	35.09	33.789	34.01	70200.0
2017-11-29	ARKW	ETF	46.97	46.99	44.8	45.2	326000.0
2017-11-29	ASEA	ETF	16.71	16.71	16.54	16.58	5000.0
2017-11-29	ASET	ETF	28.48	28.51	28.48	28.49	3380.0
2017-11-29	ASHR	ETF	31.03	31.06	30.75	30.78	1018000.0
2017-11-29	ASHS	ETF	34.63	34.64	34.52	34.53	2800.0
2017-11-29	ASHX	ETF	22.85	22.85	22.68	22.68	350.0
2017-11-29	ATMP	ETF	19.24	19.24	18.91	19.07	35800.0
2017-11-29	BAB	ETF	30.54	30.6299	30.42	30.48	187863.0
2017-11-29	BAL	ETF	47.617	48.58	47.617	48.51	3224.0

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

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