PREVIEW / etf_daily / 2015-07-15

all etf daily files

  file:    by_date/etf_daily/2015/2015-07-15.parquet
  size:    48 KB
  rows:    1,204

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
2015-07-15	SPY	ETF	210.73	211.28	210.04	210.61	97914100.0
2015-07-15	QQQ	ETF	110.47	110.81	110.07	110.38	28631537.0
2015-07-15	IWM	ETF	126.31	126.48	125.27	125.56	22238300.0
2015-07-15	DIA	ETF	180.32	180.72	179.9	180.34	3407900.0
2015-07-15	GLD	ETF	110.0	110.19	109.58	110.16	9286200.0
2015-07-15	TLT	ETF	116.11	117.55	116.04	117.3	8720400.0
2015-07-15	AAXJ	ETF	61.0	61.12	60.66	60.72	702500.0
2015-07-15	ACTX	ETF	1.77	1.77	1.77	1.77	16.0
2015-07-15	ACWI	ETF	60.34	60.56	60.22	60.39	1096400.0
2015-07-15	ACWV	ETF	71.04	71.18	70.76	70.9	123300.0
2015-07-15	ACWX	ETF	44.54	44.65	44.37	44.5	173726.0
2015-07-15	ADRE	ETF	34.29	34.29	33.93	34.0	9496.0
2015-07-15	AFK	ETF	23.33	23.53	23.09	23.15	29408.0
2015-07-15	AFTY	ETF	19.8	19.91	19.62	19.65	136900.0
2015-07-15	AGG	ETF	108.36	108.72	108.36	108.69	1781400.0
2015-07-15	AGQ	ETF	33.45	33.79	33.21	33.64	249200.0
2015-07-15	AGZ	ETF	112.88	113.35	112.88	113.2856	10161.0
2015-07-15	AGZD	ETF	24.37	24.505	24.37	24.49	9400.0
2015-07-15	AIA	ETF	48.41	48.46	48.1401	48.2	43686.0
2015-07-15	AIQ	ETF	17.3	17.425	16.9569	17.12	19682.0
2015-07-15	AIRR	ETF	18.15	18.15	17.87	17.87	4700.0
2015-07-15	AIVI	ETF	43.46	43.48	43.2	43.34	80800.0
2015-07-15	ALTY	ETF	15.14	18.16	15.13	18.16	6300.0
2015-07-15	AMJ	ETF	40.35	40.73	39.85	39.86	1817042.0
2015-07-15	AMLP	ETF	79.85	79.95	78.7	78.7	749880.0
2015-07-15	AMZA	ETF	198.2	198.2	193.6	194.1	3330.0
2015-07-15	ANGL	ETF	27.07	27.08	26.95	27.08	23700.0
2015-07-15	AOA	ETF	47.7	47.7	47.42	47.43	20700.0
2015-07-15	AOK	ETF	32.53	32.53	32.3608	32.44	28094.0
2015-07-15	AOM	ETF	35.25	35.25	35.12	35.21	40747.0
2015-07-15	AOR	ETF	40.62	40.73	40.51	40.52	39295.0
2015-07-15	ARGT	ETF	19.74	19.93	19.74	19.82	8800.0
2015-07-15	ARKG	ETF	23.57	23.79	23.484	23.484	1300.0
2015-07-15	ARKK	ETF	21.71	21.71	21.415	21.415	2200.0
2015-07-15	ARKQ	ETF	19.92	19.97	19.8	19.8	600.0
2015-07-15	ARKW	ETF	23.59	23.59	23.229	23.229	1800.0
2015-07-15	ASEA	ETF	14.87	14.91	14.85	14.91	1300.0
2015-07-15	ASHR	ETF	40.3	40.64	40.05	40.24	4733300.0
2015-07-15	ASHS	ETF	45.08	45.41	43.14	43.62	200700.0
2015-07-15	ATMP	ETF	28.1	29.22	27.08	27.08	110600.0
2015-07-15	AWAY	ETF	31.41	31.72	31.22	31.47	639668.0
2015-07-15	BAB	ETF	28.77	28.77	28.52	28.62	147132.0
2015-07-15	BAL	ETF	44.03	44.15	43.27	43.52	3085.0
2015-07-15	BALT	ETF	1.48	1.65	1.48	1.52	399746.0
2015-07-15	BBC	ETF	39.13	39.49	38.217	38.41	58069.0
2015-07-15	BBH	ETF	141.93	144.3	141.56	141.9	115200.0
2015-07-15	BBP	ETF	36.62	37.3	36.493	36.639	36200.0
2015-07-15	BCHP	ETF	19.4099	19.4099	19.4099	19.4099	100.0
2015-07-15	BCM	ETF	30.05	30.05	29.848	29.93	7892.0
2015-07-15	BFOR	ETF	8.405	8.405	8.345	8.3475	42400.0

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

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