PREVIEW / etf_daily / 2016-08-25

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-25.parquet
  size:    51 KB
  rows:    1,282

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
2016-08-25	SPY	ETF	217.4	218.19	217.22	217.7	69224800.0
2016-08-25	QQQ	ETF	116.48	116.97	116.36	116.61	24266264.0
2016-08-25	IWM	ETF	122.62	123.69	122.61	123.31	17023200.0
2016-08-25	DIA	ETF	184.28	184.79	184.1	184.37	2034900.0
2016-08-25	GLD	ETF	125.98	126.31	125.96	126.23	5926300.0
2016-08-25	TLT	ETF	139.26	139.78	138.96	139.17	5855500.0
2016-08-25	AADR	ETF	40.74	40.76	40.74	40.76	700.0
2016-08-25	AAXJ	ETF	58.98	59.16	58.9	59.13	646500.0
2016-08-25	ACTX	ETF	3.54	3.54	2.891	2.891	508.0
2016-08-25	ACWI	ETF	58.89	59.09	58.79	58.87	1893700.0
2016-08-25	ACWV	ETF	76.78	77.05	76.68	76.76	186200.0
2016-08-25	ACWX	ETF	41.21	41.275	41.1601	41.21	837399.0
2016-08-25	ADRE	ETF	34.0	34.105	33.97	33.97	5133.0
2016-08-25	AFK	ETF	20.33	20.7999	20.1	20.18	9265.0
2016-08-25	AGG	ETF	112.55	112.67	112.52	112.52	1613500.0
2016-08-25	AGGY	ETF	52.13	52.18	52.04	52.11	16500.0
2016-08-25	AGNG	ETF	16.6	16.6	16.6	16.6	100.0
2016-08-25	AGQ	ETF	45.34	45.85	45.34	45.53	101900.0
2016-08-25	AGZ	ETF	115.66	115.73	115.598	115.65	14297.0
2016-08-25	AGZD	ETF	23.92	23.92	23.855	23.855	7200.0
2016-08-25	AIA	ETF	48.52	48.652	48.46	48.56	12359.0
2016-08-25	AIQ	ETF	6.275	6.275	6.15	6.17	6350.0
2016-08-25	AIRR	ETF	19.74	19.95	19.74	19.91	10400.0
2016-08-25	AIVI	ETF	39.21	39.25	39.1	39.1	25100.0
2016-08-25	ALTY	ETF	15.76	15.76	15.65	15.65	1300.0
2016-08-25	AMJ	ETF	30.93	31.09	30.8	30.99	907207.0
2016-08-25	AMLP	ETF	62.55	62.85	62.45	62.75	1173020.0
2016-08-25	AMZA	ETF	114.9	115.1	114.26	115.1	8340.0
2016-08-25	ANGL	ETF	28.8	28.82	28.73	28.8	132400.0
2016-08-25	AOA	ETF	47.36	47.42	47.28	47.32	20500.0
2016-08-25	AOK	ETF	33.47	33.47	33.3601	33.37	47665.0
2016-08-25	AOM	ETF	36.01	36.0899	35.93	36.01	32693.0
2016-08-25	AOR	ETF	41.05	41.09	40.9701	40.99	50532.0
2016-08-25	ARGT	ETF	22.65	22.96	22.65	22.8	23700.0
2016-08-25	ARKG	ETF	18.42	18.42	17.93	17.93	2100.0
2016-08-25	ARKK	ETF	20.97	20.97	20.92	20.92	800.0
2016-08-25	ARKQ	ETF	21.72	21.72	21.62	21.71	1600.0
2016-08-25	ARKW	ETF	24.55	24.55	24.4	24.484	2300.0
2016-08-25	ASEA	ETF	14.22	14.32	14.22	14.29	6500.0
2016-08-25	ASHR	ETF	25.12	25.13	25.02	25.07	727400.0
2016-08-25	ASHS	ETF	34.96	35.05	34.95	35.03	6900.0
2016-08-25	ATMP	ETF	22.53	22.65	22.5	22.58	10800.0
2016-08-25	BAB	ETF	31.65	31.67	31.58	31.6	229077.0
2016-08-25	BAL	ETF	44.78	45.274	44.78	45.08	9644.0
2016-08-25	BBC	ETF	20.1256	20.25	19.54	19.7931	3406.0
2016-08-25	BBH	ETF	115.82	116.56	113.13	114.47	76200.0
2016-08-25	BBP	ETF	30.81	31.02	30.0	30.37	11600.0
2016-08-25	BCM	ETF	26.4	26.4	26.392	26.392	880.0
2016-08-25	BFOR	ETF	8.0825	8.105	8.0775	8.085	44400.0
2016-08-25	BIB	ETF	47.8	48.63	45.27	46.68	1133924.0

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

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