PREVIEW / etf_daily / 2015-07-27

all etf daily files

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

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-27	SPY	ETF	206.94	207.55	206.26	206.79	132361100.0
2015-07-27	QQQ	ETF	110.47	110.946	109.94	110.18	35994837.0
2015-07-27	IWM	ETF	121.13	121.32	120.27	120.57	35627200.0
2015-07-27	DIA	ETF	174.47	174.78	173.78	174.23	5370200.0
2015-07-27	GLD	ETF	104.94	105.68	104.66	104.86	10690100.0
2015-07-27	TLT	ETF	122.19	122.29	121.48	122.04	8172000.0
2015-07-27	AADR	ETF	39.38	39.38	39.23	39.23	900.0
2015-07-27	AAXJ	ETF	58.42	58.69	58.2	58.4	3083800.0
2015-07-27	ACTX	ETF	1.18	1.18	1.18	1.18	361.0
2015-07-27	ACWI	ETF	59.23	59.23	58.73	58.83	3109600.0
2015-07-27	ACWV	ETF	69.88	70.08	69.64	69.76	60700.0
2015-07-27	ACWX	ETF	43.38	43.38	43.08	43.15	334716.0
2015-07-27	ADRE	ETF	32.28	32.4427	32.1	32.13	22662.0
2015-07-27	AFK	ETF	22.54	22.5445	22.27	22.29	30118.0
2015-07-27	AFTY	ETF	17.9	18.77	17.17	18.08	92000.0
2015-07-27	AGG	ETF	109.25	109.35	109.21	109.26	2666000.0
2015-07-27	AGQ	ETF	31.58	31.96	31.08	31.18	111000.0
2015-07-27	AGZ	ETF	113.5203	113.72	113.15	113.34	567653.0
2015-07-27	AGZD	ETF	24.335	24.335	24.26	24.28	6200.0
2015-07-27	AIA	ETF	46.68	46.8899	46.48	46.56	30878.0
2015-07-27	AIQ	ETF	15.51	16.27	15.5	15.74	19523.0
2015-07-27	AIRR	ETF	17.1	17.1	16.87	16.93	56700.0
2015-07-27	AIVI	ETF	42.41	42.42	42.09	42.14	43800.0
2015-07-27	ALTY	ETF	14.616	14.616	14.608	14.608	1300.0
2015-07-27	AMJ	ETF	36.9	37.64	36.62	37.46	3163375.0
2015-07-27	AMLP	ETF	75.0	75.95	74.5	75.75	1084280.0
2015-07-27	AMZA	ETF	175.3	181.2	174.7	179.62	6970.0
2015-07-27	ANGL	ETF	27.16	27.16	26.95	26.95	26400.0
2015-07-27	AOA	ETF	46.73	46.77	46.53	46.67	71300.0
2015-07-27	AOK	ETF	32.31	32.3616	32.25	32.34	30645.0
2015-07-27	AOM	ETF	34.95	35.0	34.871	34.97	24676.0
2015-07-27	AOR	ETF	40.15	40.15	40.0	40.12	33316.0
2015-07-27	ARGT	ETF	18.39	18.48	18.09	18.19	12000.0
2015-07-27	ARKG	ETF	22.89	22.89	22.55	22.55	500.0
2015-07-27	ARKK	ETF	21.57	21.65	21.57	21.65	300.0
2015-07-27	ARKQ	ETF	19.574	19.64	19.57	19.64	1900.0
2015-07-27	ARKW	ETF	23.94	23.94	23.595	23.595	1900.0
2015-07-27	ASEA	ETF	14.47	14.47	14.39	14.45	6200.0
2015-07-27	ASHR	ETF	38.78	39.37	38.56	39.16	7124100.0
2015-07-27	ASHS	ETF	46.44	47.88	46.03	46.8	201100.0
2015-07-27	ATMP	ETF	25.3	25.64	24.99	25.55	136900.0
2015-07-27	AWAY	ETF	29.88	30.29	28.93	29.11	1829731.0
2015-07-27	BAB	ETF	29.02	29.21	29.02	29.06	164761.0
2015-07-27	BAL	ETF	42.91	43.14	42.63	42.68	4977.0
2015-07-27	BBC	ETF	36.48	36.785	35.56	36.18	56219.0
2015-07-27	BBH	ETF	136.2	137.08	134.58	136.01	246700.0
2015-07-27	BBP	ETF	35.32	35.68	34.98	35.48	37000.0
2015-07-27	BCHP	ETF	18.73	18.73	18.621	18.64	5145.0
2015-07-27	BCM	ETF	28.022	28.03	27.94	27.94	9514.0
2015-07-27	BFOR	ETF	8.1125	8.1125	8.0275	8.0575	119600.0

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

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