PREVIEW / etf_daily / 2015-03-20

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-20.parquet
  size:    48 KB
  rows:    1,166

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-20	SPY	ETF	209.71	211.02	209.49	210.41	177715100.0
2015-03-20	QQQ	ETF	108.72	109.07	108.51	108.53	31761404.0
2015-03-20	IWM	ETF	125.36	126.16	125.31	125.99	34165600.0
2015-03-20	DIA	ETF	180.46	181.67	180.17	180.96	5999200.0
2015-03-20	GLD	ETF	112.71	114.0	112.67	113.57	8033400.0
2015-03-20	TLT	ETF	131.22	131.7	131.14	131.51	5953800.0
2015-03-20	AADR	ETF	39.05	39.59	39.05	39.59	200.0
2015-03-20	AAXJ	ETF	63.51	63.89	63.5	63.76	1607400.0
2015-03-20	ACWI	ETF	60.83	61.29	60.74	61.12	2492400.0
2015-03-20	ACWV	ETF	72.06	72.39	71.66	72.16	139400.0
2015-03-20	ACWX	ETF	45.1	45.47	45.02	45.33	125229.0
2015-03-20	ADRE	ETF	35.15	35.4699	35.15	35.28	14685.0
2015-03-20	AFK	ETF	24.25	24.9099	24.18	24.66	20521.0
2015-03-20	AFTY	ETF	19.42	19.42	19.0	19.175	57000.0
2015-03-20	AGG	ETF	111.23	111.34	111.18	111.32	3833600.0
2015-03-20	AGQ	ETF	40.18	43.02	40.06	42.25	502100.0
2015-03-20	AGZ	ETF	113.86	114.2999	113.86	113.93	161196.0
2015-03-20	AGZD	ETF	24.545	24.575	24.455	24.55	12000.0
2015-03-20	AIA	ETF	49.85	49.98	49.735	49.92	16235.0
2015-03-20	AIQ	ETF	24.4	24.54	23.17	23.19	30724.0
2015-03-20	AIRR	ETF	18.61	18.61	18.418	18.6	278900.0
2015-03-20	AIVI	ETF	44.64	45.11	44.52	44.87	16500.0
2015-03-20	ALTL	ETF	38.04	38.06	38.04	38.06	1087.0
2015-03-20	AMJ	ETF	42.5	42.74	42.33	42.44	1087216.0
2015-03-20	AMLP	ETF	82.35	82.5	81.75	82.1	820780.0
2015-03-20	AMZA	ETF	211.0	211.0	210.0	210.0	410.0
2015-03-20	ANGL	ETF	27.18	27.47	27.18	27.31	10700.0
2015-03-20	AOA	ETF	47.78	48.22	47.78	48.04	24900.0
2015-03-20	AOK	ETF	32.91	33.16	32.91	33.0501	35195.0
2015-03-20	AOM	ETF	35.84	35.93	35.7001	35.91	45724.0
2015-03-20	AOR	ETF	41.1	41.33	41.1	41.2548	26207.0
2015-03-20	ARGT	ETF	21.8	22.04	21.73	21.97	14500.0
2015-03-20	ARKG	ETF	24.24	24.24	23.83	23.88	15300.0
2015-03-20	ARKK	ETF	21.33	21.33	21.33	21.33	200.0
2015-03-20	ARKQ	ETF	20.39	20.41	20.39	20.41	8800.0
2015-03-20	ARKW	ETF	22.0	22.365	22.0	22.34	4800.0
2015-03-20	ASEA	ETF	15.52	15.56	15.49	15.54	58600.0
2015-03-20	ASHR	ETF	40.32	40.64	40.23	40.53	1316000.0
2015-03-20	ASHS	ETF	45.93	46.14	45.92	46.11	21200.0
2015-03-20	ATMP	ETF	29.0	29.13	28.97	29.02	112800.0
2015-03-20	AVIV	ETF	36.12	36.62	35.59	36.54	444510.0
2015-03-20	AWAY	ETF	30.95	31.39	30.875	31.29	1249506.0
2015-03-20	BAB	ETF	30.25	30.321	30.2	30.31	77957.0
2015-03-20	BAL	ETF	42.9199	42.9199	42.32	42.42	10510.0
2015-03-20	BALT	ETF	1.27	1.39	1.27	1.38	617263.0
2015-03-20	BAR	ETF	2.665	2.667	2.657	2.66	20560.0
2015-03-20	BBC	ETF	36.84	37.6685	34.88	35.07	174909.0
2015-03-20	BBH	ETF	140.69	140.72	137.19	138.45	254600.0
2015-03-20	BBP	ETF	33.51	33.51	32.15	32.37	24800.0
2015-03-20	BCM	ETF	30.42	30.67	30.42	30.6184	28418.0

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

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