PREVIEW / etf_daily / 2014-01-15

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-15.parquet
  size:    43 KB
  rows:    1,074

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
2014-01-15	SPY	ETF	184.1	184.94	183.71	184.66	98525800.0
2014-01-15	QQQ	ETF	88.0	88.54	87.94	88.37	39859705.0
2014-01-15	IWM	ETF	115.64	116.29	115.56	116.2	31644100.0
2014-01-15	DIA	ETF	163.66	164.8	163.59	164.57	7780800.0
2014-01-15	GLD	ETF	119.19	119.81	119.11	119.66	5474300.0
2014-01-15	TLT	ETF	104.04	104.51	103.93	104.34	7507500.0
2014-01-15	AADR	ETF	37.46	37.46	37.42	37.42	1200.0
2014-01-15	AAXJ	ETF	58.46	58.49	58.26	58.44	555500.0
2014-01-15	ACWI	ETF	57.16	57.43	57.13	57.38	670300.0
2014-01-15	ACWV	ETF	62.63	62.92	62.59	62.82	21600.0
2014-01-15	ACWX	ETF	46.07	46.2	45.98	46.15	85493.0
2014-01-15	ADRE	ETF	35.81	35.9601	35.79	35.79	22360.0
2014-01-15	AFK	ETF	30.58	30.83	30.58	30.77	29830.0
2014-01-15	AGG	ETF	106.88	106.98	106.82	106.95	1664800.0
2014-01-15	AGQ	ETF	66.36	67.84	66.24	67.44	335925.0
2014-01-15	AGZ	ETF	110.91	110.98	110.86	110.91	9134.0
2014-01-15	AGZD	ETF	25.03	25.03	25.0	25.005	5000.0
2014-01-15	AIA	ETF	46.05	46.056	45.97	46.056	5787.0
2014-01-15	AIQ	ETF	27.45	27.94	27.0	27.61	31104.0
2014-01-15	AIVI	ETF	47.08	47.41	47.08	47.36	16600.0
2014-01-15	AMJ	ETF	45.27	45.48	45.13	45.42	467793.0
2014-01-15	AMLP	ETF	87.55	87.65	87.1	87.4	621980.0
2014-01-15	ANGL	ETF	27.0	27.25	27.0	27.08	4800.0
2014-01-15	AOA	ETF	44.88	44.88	44.57	44.67	30700.0
2014-01-15	AOK	ETF	32.0622	32.12	32.0617	32.11	34507.0
2014-01-15	AOM	ETF	34.55	34.55	34.3501	34.42	30082.0
2014-01-15	AOR	ETF	38.63	38.63	38.4928	38.59	32040.0
2014-01-15	ARGT	ETF	18.8	19.07	18.8	19.01	2200.0
2014-01-15	ASEA	ETF	15.19	15.2	15.15	15.16	6300.0
2014-01-15	ASHR	ETF	23.34	23.4	23.25	23.3	68100.0
2014-01-15	ATMP	ETF	26.74	26.78	26.73	26.78	7800.0
2014-01-15	AVIV	ETF	24.05	24.2	23.87	24.11	72486.0
2014-01-15	AWAY	ETF	41.39	41.7	40.89	41.19	694277.0
2014-01-15	BAB	ETF	27.55	27.64	27.5301	27.63	124692.0
2014-01-15	BAL	ETF	52.83	53.2899	52.65	53.008	6230.0
2014-01-15	BALT	ETF	6.06	6.28	6.02	6.23	1406201.0
2014-01-15	BBH	ETF	94.63	94.63	93.28	94.23	162500.0
2014-01-15	BCM	ETF	38.88	39.15	38.76	39.0	361502.0
2014-01-15	BFOR	ETF	7.4275	7.4525	7.425	7.4525	150000.0
2014-01-15	BIB	ETF	44.5225	44.5225	42.4101	43.2	457364.0
2014-01-15	BICK	ETF	23.96	24.02	23.91	23.91	794.0
2014-01-15	BIL	ETF	91.54	91.56	91.54	91.56	121500.0
2014-01-15	BIS	ETF	718.0	723.2	710.0	716.4	649.5
2014-01-15	BIV	ETF	82.39	82.49	82.33	82.46	245700.0
2014-01-15	BIZD	ETF	21.05	21.27	21.05	21.22	13700.0
2014-01-15	BJK	ETF	54.54	54.71	54.34	54.64	27900.0
2014-01-15	BKF	ETF	36.45	36.49	36.34	36.34	39040.0
2014-01-15	BKLN	ETF	24.91	24.92	24.9	24.92	3143800.0
2014-01-15	BLV	ETF	83.23	83.48	83.15	83.44	87100.0
2014-01-15	BMVP	ETF	22.923	22.923	22.821	22.863	7705.0

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

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