PREVIEW / etf_daily / 2015-07-01

all etf daily files

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

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-01	SPY	ETF	207.73	208.03	206.56	207.5	135979900.0
2015-07-01	QQQ	ETF	108.13	108.3464	107.42	107.92	21292958.0
2015-07-01	IWM	ETF	125.77	126.16	124.06	125.23	28627700.0
2015-07-01	DIA	ETF	177.57	177.82	176.58	177.4	4135100.0
2015-07-01	GLD	ETF	112.12	112.51	111.94	111.98	4409000.0
2015-07-01	TLT	ETF	115.82	116.36	115.43	115.62	12451500.0
2015-07-01	AADR	ETF	39.21	39.22	39.21	39.21	5900.0
2015-07-01	AAXJ	ETF	63.42	63.57	63.09	63.29	513600.0
2015-07-01	ACTX	ETF	2.36	2.36	2.36	2.36	16.0
2015-07-01	ACWI	ETF	59.95	60.06	59.58	59.81	2046600.0
2015-07-01	ACWV	ETF	70.1	70.34	69.77	69.96	135000.0
2015-07-01	ACWX	ETF	44.64	44.67	44.2702	44.44	3337306.0
2015-07-01	ADRE	ETF	35.39	35.39	34.88	34.94	3953.0
2015-07-01	AFK	ETF	24.31	24.4035	24.22	24.31	16969.0
2015-07-01	AFTY	ETF	19.98	20.05	19.74	19.98	125900.0
2015-07-01	AGG	ETF	108.33	108.38	108.15	108.29	6010300.0
2015-07-01	AGQ	ETF	36.02	36.4	35.77	36.03	167400.0
2015-07-01	AGZ	ETF	112.93	112.93	112.7101	112.79	15500.0
2015-07-01	AGZD	ETF	24.525	24.525	24.285	24.37	32800.0
2015-07-01	AIA	ETF	50.48	50.65	50.315	50.42	59114.0
2015-07-01	AIQ	ETF	19.04	19.04	18.12	18.33	15644.0
2015-07-01	AIRR	ETF	18.14	18.44	18.14	18.39	21000.0
2015-07-01	AIVI	ETF	42.88	42.9	42.5	42.59	15000.0
2015-07-01	ALTL	ETF	36.15	36.3763	36.15	36.3763	1707.0
2015-07-01	AMJ	ETF	39.68	39.9999	38.92	39.01	1909880.0
2015-07-01	AMLP	ETF	78.1	78.15	76.95	77.1	1357080.0
2015-07-01	AMZA	ETF	196.1	197.5	191.1	191.5	2840.0
2015-07-01	ANGL	ETF	27.09	27.15	26.9	26.98	29500.0
2015-07-01	AOA	ETF	47.88	47.88	47.2	47.6	37300.0
2015-07-01	AOK	ETF	32.44	32.55	32.39	32.464	78367.0
2015-07-01	AOM	ETF	35.42	35.42	35.19	35.25	59720.0
2015-07-01	AOR	ETF	40.93	40.94	40.52	40.69	139532.0
2015-07-01	ARGT	ETF	20.15	20.15	19.7	19.71	9200.0
2015-07-01	ARKG	ETF	23.25	23.25	22.87	22.875	2400.0
2015-07-01	ARKK	ETF	21.4	21.4	21.245	21.31	11200.0
2015-07-01	ARKQ	ETF	19.98	19.98	19.784	19.83	1300.0
2015-07-01	ARKW	ETF	23.23	23.25	23.02	23.02	2700.0
2015-07-01	ASEA	ETF	15.12	15.12	14.99	15.04	1900.0
2015-07-01	ASHR	ETF	43.59	44.36	43.49	44.2	4617100.0
2015-07-01	ASHS	ETF	53.01	54.13	53.01	54.1	150900.0
2015-07-01	ATMP	ETF	27.33	27.4	26.93	26.95	1609100.0
2015-07-01	AWAY	ETF	31.27	31.48	31.01	31.19	920253.0
2015-07-01	BAB	ETF	28.69	28.7	28.5	28.55	147053.0
2015-07-01	BAL	ETF	45.17	45.49	44.73	45.49	42491.0
2015-07-01	BALT	ETF	1.6	1.64	1.59	1.61	300814.0
2015-07-01	BBC	ETF	40.0	40.0	35.51	35.84	70539.0
2015-07-01	BBH	ETF	136.28	136.98	134.54	135.35	146200.0
2015-07-01	BBP	ETF	36.29	36.29	34.54	34.73	61200.0
2015-07-01	BCHP	ETF	19.6	19.6	19.6	19.6	141.0
2015-07-01	BCM	ETF	31.365	31.3695	31.3	31.3	2871.0

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

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