PREVIEW / etf_daily / 2015-09-15

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-15.parquet
  size:    49 KB
  rows:    1,208

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-09-15	SPY	ETF	196.61	198.99	195.96	198.46	113806200.0
2015-09-15	QQQ	ETF	105.5	106.82	105.11	106.49	30020216.0
2015-09-15	IWM	ETF	114.86	116.19	114.73	115.94	26745300.0
2015-09-15	DIA	ETF	164.36	166.53	163.97	166.11	6516100.0
2015-09-15	GLD	ETF	105.83	106.06	105.68	105.9	2905000.0
2015-09-15	TLT	ETF	120.89	121.05	119.12	119.25	11895000.0
2015-09-15	AAXJ	ETF	53.27	53.95	53.26	53.81	1374500.0
2015-09-15	ACTX	ETF	3.245	4.72	2.95	4.13	6406.0
2015-09-15	ACWF	ETF	23.2	23.2	23.2	23.2	100.0
2015-09-15	ACWI	ETF	55.15	55.8	55.1	55.7	1331900.0
2015-09-15	ACWV	ETF	67.03	67.6	66.87	67.47	425200.0
2015-09-15	ACWX	ETF	40.02	40.39	39.9875	40.35	853804.0
2015-09-15	ADRE	ETF	29.06	29.26	29.06	29.26	8247.0
2015-09-15	AFK	ETF	20.2	20.48	20.2	20.41	8237.0
2015-09-15	AFTY	ETF	15.15	15.39	15.15	15.35	6200.0
2015-09-15	AGG	ETF	109.0	109.0	108.5	108.6	1541200.0
2015-09-15	AGQ	ETF	29.81	30.18	29.73	30.16	77800.0
2015-09-15	AGZ	ETF	113.5973	113.5999	113.12	113.13	20901.0
2015-09-15	AGZD	ETF	24.065	24.1	24.065	24.1	3000.0
2015-09-15	AIA	ETF	42.26	42.74	42.22	42.67	18827.0
2015-09-15	AIQ	ETF	15.86	16.485	15.86	16.41	11202.0
2015-09-15	AIRR	ETF	16.29	16.525	16.29	16.5	75100.0
2015-09-15	AIVI	ETF	39.39	39.69	39.37	39.69	55800.0
2015-09-15	ALTY	ETF	14.24	14.24	14.24	14.24	200.0
2015-09-15	AMJ	ETF	33.23	33.5495	33.07	33.16	2245594.0
2015-09-15	AMLP	ETF	68.85	69.55	68.55	68.55	948700.0
2015-09-15	AMZA	ETF	155.4	155.9	152.5	152.6	760.0
2015-09-15	ANGL	ETF	26.56	26.63	26.52	26.56	15500.0
2015-09-15	AOA	ETF	44.4	44.75	44.33	44.7	24400.0
2015-09-15	AOK	ETF	31.65	31.704	31.58	31.68	112848.0
2015-09-15	AOM	ETF	34.15	34.164	34.02	34.16	63287.0
2015-09-15	AOR	ETF	38.65	38.8	38.53	38.79	99478.0
2015-09-15	ARGT	ETF	17.66	17.79	17.66	17.7	18900.0
2015-09-15	ARKG	ETF	21.877	21.877	21.877	21.877	100.0
2015-09-15	ARKK	ETF	20.332	20.332	20.33	20.33	1100.0
2015-09-15	ARKQ	ETF	18.324	18.34	18.324	18.34	700.0
2015-09-15	ARKW	ETF	21.897	22.14	21.897	22.14	800.0
2015-09-15	ASEA	ETF	12.55	12.74	12.54	12.69	14800.0
2015-09-15	ASHR	ETF	31.02	31.43	30.83	31.25	1675100.0
2015-09-15	ASHS	ETF	33.08	33.44	32.64	33.32	80300.0
2015-09-15	ATMP	ETF	22.43	22.63	22.43	22.51	25600.0
2015-09-15	AWAY	ETF	28.08	29.18	27.96	28.98	901153.0
2015-09-15	BAB	ETF	28.74	28.74	28.47	28.5063	81980.0
2015-09-15	BAL	ETF	41.801	41.8409	41.65	41.68	2085.0
2015-09-15	BBC	ETF	33.686	33.99	33.686	33.88	4240.0
2015-09-15	BBH	ETF	131.71	133.24	130.77	132.65	71800.0
2015-09-15	BBP	ETF	33.02	33.19	32.78	33.19	7400.0
2015-09-15	BCHP	ETF	17.8601	17.8601	17.8601	17.8601	240.0
2015-09-15	BCM	ETF	26.817	26.8199	26.817	26.8199	710.0
2015-09-15	BFOR	ETF	7.7225	7.7875	7.7225	7.78	148400.0

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

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