PREVIEW / etf_daily / 2015-03-25

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-25.parquet
  size:    47 KB
  rows:    1,162

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-03-25	SPY	ETF	209.07	209.35	205.71	205.76	159521700.0
2015-03-25	QQQ	ETF	108.1	108.2	105.42	105.46	41581435.0
2015-03-25	IWM	ETF	125.53	125.6	122.38	122.47	42514000.0
2015-03-25	DIA	ETF	179.95	180.16	176.88	176.92	8474700.0
2015-03-25	GLD	ETF	115.11	115.14	114.65	114.73	3021400.0
2015-03-25	TLT	ETF	132.72	132.76	131.46	131.5	5635800.0
2015-03-25	AADR	ETF	38.72	38.87	38.59	38.77	10600.0
2015-03-25	AAXJ	ETF	63.76	63.9	63.09	63.09	605300.0
2015-03-25	ACWI	ETF	61.18	61.22	60.33	60.36	1254500.0
2015-03-25	ACWV	ETF	72.64	72.68	71.73	71.81	85200.0
2015-03-25	ACWX	ETF	45.69	45.69	45.2	45.24	301093.0
2015-03-25	ADRE	ETF	35.25	35.32	34.7301	34.8099	16042.0
2015-03-25	AFK	ETF	24.94	24.9891	24.73	24.73	32452.0
2015-03-25	AFTY	ETF	18.98	18.98	18.71	18.74	39500.0
2015-03-25	AGG	ETF	111.75	111.75	111.43	111.43	1612300.0
2015-03-25	AGQ	ETF	44.11	44.23	43.29	43.37	147700.0
2015-03-25	AGZ	ETF	114.32	114.455	114.14	114.36	50699.0
2015-03-25	AGZD	ETF	24.365	24.475	24.365	24.405	6800.0
2015-03-25	AIA	ETF	49.92	49.92	49.33	49.45	26177.0
2015-03-25	AIQ	ETF	22.76	22.76	21.45	21.46	15377.0
2015-03-25	AIRR	ETF	18.65	18.65	18.45	18.5	7700.0
2015-03-25	AIVI	ETF	45.34	45.34	44.91	44.92	172500.0
2015-03-25	AMJ	ETF	42.5	43.0398	42.22	42.74	934931.0
2015-03-25	AMLP	ETF	82.6	82.9	82.3	82.55	700640.0
2015-03-25	AMZA	ETF	213.1	213.9	212.2	212.2	250.0
2015-03-25	ANGL	ETF	27.22	27.31	27.21	27.27	2300.0
2015-03-25	AOA	ETF	48.29	48.29	47.63	47.67	57100.0
2015-03-25	AOK	ETF	33.14	33.2435	32.96	33.05	49290.0
2015-03-25	AOM	ETF	36.01	36.01	35.7	35.76	93317.0
2015-03-25	AOR	ETF	41.26	41.46	41.0	41.01	39818.0
2015-03-25	ARGT	ETF	21.52	21.72	21.52	21.63	6300.0
2015-03-25	ARKG	ETF	23.3	23.3	22.55	22.55	7900.0
2015-03-25	ARKK	ETF	20.81	20.81	20.81	20.81	200.0
2015-03-25	ARKQ	ETF	19.989	19.989	19.912	19.912	200.0
2015-03-25	ARKW	ETF	21.75	21.75	21.69	21.69	400.0
2015-03-25	ASEA	ETF	15.58	15.61	15.45	15.51	35600.0
2015-03-25	ASHR	ETF	40.46	40.69	40.13	40.17	1155300.0
2015-03-25	ASHS	ETF	47.26	47.44	47.08	47.14	38600.0
2015-03-25	ATMP	ETF	29.21	29.6	29.04	29.06	64900.0
2015-03-25	AVIV	ETF	36.9	37.18	36.17	36.35	213645.0
2015-03-25	AWAY	ETF	31.77	31.8	30.41	30.43	792645.0
2015-03-25	BAB	ETF	30.47	30.4799	30.32	30.3694	57313.0
2015-03-25	BAL	ETF	43.06	43.29	42.68	42.68	1950.0
2015-03-25	BALT	ETF	1.49	1.52	1.43	1.45	178401.0
2015-03-25	BAR	ETF	2.735	2.834	2.735	2.753	61870.0
2015-03-25	BBC	ETF	33.76	33.76	31.25	31.39	105962.0
2015-03-25	BBH	ETF	134.66	135.62	129.39	129.51	263800.0
2015-03-25	BBP	ETF	32.04	32.04	30.328	30.328	79400.0
2015-03-25	BCHP	ETF	19.5299	19.5299	19.24	19.31	2453.0
2015-03-25	BCM	ETF	30.86	31.05	30.69	30.98	17652.0

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

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