PREVIEW / etf_daily / 2015-01-27

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-27.parquet
  size:    47 KB
  rows:    1,163

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-01-27	SPY	ETF	202.97	204.12	201.74	202.74	134044600.0
2015-01-27	QQQ	ETF	102.5	102.56	101.1	101.44	45253205.0
2015-01-27	IWM	ETF	117.86	119.25	117.62	118.69	26919100.0
2015-01-27	DIA	ETF	173.5	174.75	172.59	173.59	11565100.0
2015-01-27	GLD	ETF	123.56	124.64	123.51	124.4	9584800.0
2015-01-27	TLT	ETF	135.73	136.13	134.15	134.57	8079600.0
2015-01-27	AADR	ETF	37.46	37.49	37.46	37.49	300.0
2015-01-27	AAXJ	ETF	63.53	63.72	63.33	63.55	1271400.0
2015-01-27	ACWI	ETF	58.84	59.02	58.48	58.75	1824900.0
2015-01-27	ACWV	ETF	70.55	71.24	70.42	70.96	103200.0
2015-01-27	ACWX	ETF	43.64	43.865	43.52	43.76	836234.0
2015-01-27	ADRE	ETF	36.75	37.26	36.75	37.15	11607.0
2015-01-27	AFK	ETF	25.46	25.6599	25.44	25.64	14797.0
2015-01-27	AGG	ETF	111.97	111.97	111.55	111.6	1635900.0
2015-01-27	AGQ	ETF	49.19	50.66	49.19	50.08	165600.0
2015-01-27	AGZ	ETF	114.44	114.78	114.3	114.45	37966.0
2015-01-27	AGZD	ETF	24.39	24.545	24.39	24.405	10600.0
2015-01-27	AIA	ETF	49.28	49.36	48.81	49.22	31230.0
2015-01-27	AIQ	ETF	23.55	24.68	23.23	24.32	22513.0
2015-01-27	AIRR	ETF	17.08	17.18	16.9	17.1	74200.0
2015-01-27	AIVI	ETF	43.83	44.15	43.82	44.01	15600.0
2015-01-27	AMJ	ETF	44.8	45.28	44.4901	45.06	1067026.0
2015-01-27	AMLP	ETF	86.4	86.8	85.55	86.4	826680.0
2015-01-27	AMZA	ETF	219.4	219.4	218.3	218.3	270.0
2015-01-27	ANGL	ETF	26.99	26.99	26.46	26.57	2800.0
2015-01-27	AOA	ETF	46.65	46.82	46.53	46.69	28800.0
2015-01-27	AOK	ETF	32.85	32.879	32.809	32.83	20366.0
2015-01-27	AOM	ETF	35.45	35.47	35.3301	35.39	94142.0
2015-01-27	AOR	ETF	40.38	40.48	40.28	40.39	70797.0
2015-01-27	ARGT	ETF	18.68	18.85	18.57	18.85	39600.0
2015-01-27	ARKG	ETF	23.21	23.21	22.49	22.657	4800.0
2015-01-27	ARKK	ETF	20.44	20.44	20.44	20.44	1200.0
2015-01-27	ARKQ	ETF	19.1	19.23	19.02	19.18	2700.0
2015-01-27	ARKW	ETF	20.68	20.83	20.539	20.72	5100.0
2015-01-27	ASEA	ETF	15.74	15.79	15.72	15.79	6500.0
2015-01-27	ASHR	ETF	36.43	36.66	36.22	36.56	685400.0
2015-01-27	ASHS	ETF	37.63	37.77	37.59	37.67	9700.0
2015-01-27	ATMP	ETF	29.79	29.94	29.55	29.8	15000.0
2015-01-27	AVIV	ETF	39.54	39.815	39.27	39.55	112068.0
2015-01-27	AWAY	ETF	26.69	27.0	26.52	26.91	1122193.0
2015-01-27	BAB	ETF	31.03	31.14	30.92	30.99	130634.0
2015-01-27	BAL	ETF	39.99	39.99	39.59	39.8	4319.0
2015-01-27	BALT	ETF	1.75	1.75	1.62	1.66	597123.0
2015-01-27	BAR	ETF	3.4455	3.566	3.4455	3.566	29400.0
2015-01-27	BBC	ETF	28.98	30.11	28.98	29.79	17652.0
2015-01-27	BBH	ETF	124.17	125.96	124.12	124.75	192800.0
2015-01-27	BBP	ETF	28.58	28.8	28.381	28.57	13600.0
2015-01-27	BCHP	ETF	18.3201	18.3201	18.3201	18.3201	225.0
2015-01-27	BCM	ETF	30.61	30.8199	30.61	30.74	35954.0
2015-01-27	BFOR	ETF	7.8075	7.86	7.7675	7.82	240400.0

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

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