PREVIEW / etf_daily / 2015-07-09

all etf daily files

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

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-09	SPY	ETF	207.04	207.35	204.77	204.9	144113100.0
2015-07-09	QQQ	ETF	107.5	107.5955	106.02	106.03	28381041.0
2015-07-09	IWM	ETF	123.35	123.53	122.27	122.43	29770400.0
2015-07-09	DIA	ETF	177.15	177.47	175.21	175.26	4581400.0
2015-07-09	GLD	ETF	111.8	111.93	111.15	111.36	3802900.0
2015-07-09	TLT	ETF	118.7	119.12	117.85	117.92	11108900.0
2015-07-09	AADR	ETF	38.76	38.76	38.39	38.45	8600.0
2015-07-09	AAXJ	ETF	60.06	60.25	59.59	59.6	1750100.0
2015-07-09	ACTX	ETF	1.77	1.77	1.77	1.77	415.0
2015-07-09	ACWI	ETF	59.09	59.09	58.47	58.48	1137700.0
2015-07-09	ACWV	ETF	69.9	70.13	69.4	69.57	235100.0
2015-07-09	ACWX	ETF	43.33	43.3699	42.95	42.99	235989.0
2015-07-09	ADRE	ETF	33.76	33.8699	33.35	33.36	13273.0
2015-07-09	AFK	ETF	23.02	23.27	23.02	23.26	7966.0
2015-07-09	AFTY	ETF	18.385	20.67	18.385	20.67	711300.0
2015-07-09	AGG	ETF	109.09	109.09	108.82	108.84	1932800.0
2015-07-09	AGGY	ETF	49.95	49.98	49.91	49.91	5000.0
2015-07-09	AGQ	ETF	35.4	35.59	34.75	35.25	173600.0
2015-07-09	AGZ	ETF	113.29	113.34	113.12	113.1751	8581.0
2015-07-09	AGZD	ETF	24.33	24.41	24.285	24.41	21200.0
2015-07-09	AIA	ETF	47.02	47.952	47.02	47.36	23300.0
2015-07-09	AIQ	ETF	17.0	17.715	16.65	16.76	22299.0
2015-07-09	AIRR	ETF	17.9	17.9	17.77	17.795	3200.0
2015-07-09	AIVI	ETF	41.81	41.87	41.54	41.6	26500.0
2015-07-09	AMJ	ETF	39.7	40.06	39.34	39.39	1172162.0
2015-07-09	AMLP	ETF	78.45	78.65	77.6	77.75	731800.0
2015-07-09	AMZA	ETF	192.0	192.1	188.9	188.95	350.0
2015-07-09	ANGL	ETF	27.1	27.1	27.04	27.1	3300.0
2015-07-09	AOA	ETF	46.72	46.93	46.28	46.38	40800.0
2015-07-09	AOK	ETF	32.4	32.4	32.1705	32.229	58710.0
2015-07-09	AOM	ETF	34.94	35.08	34.79	34.79	57108.0
2015-07-09	AOR	ETF	40.12	40.12	39.83	39.85	69180.0
2015-07-09	ARGT	ETF	19.01	19.23	19.01	19.07	2100.0
2015-07-09	ARKG	ETF	22.55	22.55	22.5	22.5	2700.0
2015-07-09	ARKK	ETF	20.95	20.95	20.95	20.95	200.0
2015-07-09	ARKQ	ETF	19.52	19.52	19.52	19.52	100.0
2015-07-09	ARKW	ETF	22.93	22.93	22.71	22.71	6000.0
2015-07-09	ASEA	ETF	14.82	14.82	14.82	14.82	300.0
2015-07-09	ASHR	ETF	38.71	40.87	38.53	40.69	15812400.0
2015-07-09	ASHS	ETF	42.05	45.0	41.5	44.23	447700.0
2015-07-09	ATMP	ETF	27.3	27.3	26.95	27.02	37900.0
2015-07-09	AWAY	ETF	29.57	30.04	29.53	29.61	755212.0
2015-07-09	BAB	ETF	29.06	29.06	28.75	28.85	77492.0
2015-07-09	BAL	ETF	44.06	44.38	44.009	44.18	2235.0
2015-07-09	BALT	ETF	1.52	1.53	1.36	1.45	968970.0
2015-07-09	BBC	ETF	35.44	36.0	35.232	35.82	12555.0
2015-07-09	BBH	ETF	133.75	135.84	133.13	133.42	68300.0
2015-07-09	BBP	ETF	34.5	34.5	34.149	34.23	40900.0
2015-07-09	BCHP	ETF	19.04	19.14	19.03	19.054	2370.0
2015-07-09	BCM	ETF	30.351	30.351	30.33	30.33	6522.0

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

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