PREVIEW / etf_daily / 2013-12-18

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-18.parquet
  size:    43 KB
  rows:    1,059

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
2013-12-18	SPY	ETF	178.92	181.73	177.32	181.7	234906000.0
2013-12-18	QQQ	ETF	85.22	86.22	84.05	86.14	68387235.0
2013-12-18	IWM	ETF	111.53	112.9	110.36	112.88	52979000.0
2013-12-18	DIA	ETF	159.16	161.79	158.11	161.76	15330700.0
2013-12-18	GLD	ETF	119.0	120.05	117.29	117.61	16265000.0
2013-12-18	TLT	ETF	102.83	103.72	102.46	102.77	12973200.0
2013-12-18	AADR	ETF	36.56	36.85	36.3	36.82	1500.0
2013-12-18	AAXJ	ETF	59.11	60.19	58.47	59.83	526800.0
2013-12-18	ACWI	ETF	55.45	56.15	54.96	56.13	1249200.0
2013-12-18	ACWV	ETF	62.15	62.72	61.88	62.61	706800.0
2013-12-18	ACWX	ETF	44.91	45.37	44.39	45.27	587155.0
2013-12-18	ADRE	ETF	36.62	37.29	36.39	37.17	18269.0
2013-12-18	AFK	ETF	30.52	31.03	30.47	31.03	29862.0
2013-12-18	AGG	ETF	106.8	107.1	106.5	106.86	1446100.0
2013-12-18	AGQ	ETF	66.68	68.64	64.0	65.6	563825.0
2013-12-18	AGZ	ETF	111.05	111.229	110.98	110.98	14957.0
2013-12-18	AGZD	ETF	25.025	25.03	25.0	25.03	2000.0
2013-12-18	AIA	ETF	47.18	47.69	46.8	47.63	49766.0
2013-12-18	AIQ	ETF	23.76	24.05	22.82	23.94	30370.0
2013-12-18	AIVI	ETF	45.88	46.4	45.73	46.16	32000.0
2013-12-18	ALTL	ETF	32.24	32.24	32.2043	32.2043	850.0
2013-12-18	AMJ	ETF	43.62	43.9375	43.25	43.67	986803.0
2013-12-18	AMLP	ETF	85.6	85.65	84.75	85.35	863980.0
2013-12-18	ANGL	ETF	27.0	27.19	27.0	27.16	1600.0
2013-12-18	AOA	ETF	43.45	43.93	43.3	43.93	37800.0
2013-12-18	AOK	ETF	31.75	31.8699	31.6801	31.832	14492.0
2013-12-18	AOM	ETF	33.91	34.13	33.8599	34.13	42191.0
2013-12-18	AOR	ETF	37.86	38.15	37.71	38.15	123389.0
2013-12-18	ARGT	ETF	20.0	20.0	19.86	20.0	4200.0
2013-12-18	ASEA	ETF	15.75	15.97	15.67	15.96	14300.0
2013-12-18	ASHR	ETF	24.88	25.05	24.55	24.99	264400.0
2013-12-18	ATMP	ETF	25.65	25.94	25.58	25.88	45000.0
2013-12-18	AVIV	ETF	23.87	24.26	23.81	24.12	141438.0
2013-12-18	AWAY	ETF	38.32	39.57	38.2677	39.32	1364955.0
2013-12-18	BAB	ETF	27.4	27.5	27.31	27.36	186987.0
2013-12-18	BAL	ETF	52.16	52.23	52.1	52.11	3477.0
2013-12-18	BALT	ETF	5.33	5.46	5.21	5.42	1034830.0
2013-12-18	BBH	ETF	84.22	85.86	83.21	85.86	75600.0
2013-12-18	BCM	ETF	39.98	39.98	39.4344	39.4344	250326.0
2013-12-18	BFOR	ETF	7.2175	7.295	7.15	7.28	155600.0
2013-12-18	BIB	ETF	33.99	35.3325	33.445	35.05	232060.0
2013-12-18	BICK	ETF	24.17	24.7	24.17	24.69	2390.0
2013-12-18	BIL	ETF	91.56	91.58	91.56	91.58	114400.0
2013-12-18	BIS	ETF	945.2	945.2	884.0	885.2	1117.5
2013-12-18	BIV	ETF	83.14	83.51	82.96	83.21	383600.0
2013-12-18	BIZD	ETF	20.9	21.23	20.9	21.23	5100.0
2013-12-18	BJK	ETF	52.56	52.99	52.08	52.97	18200.0
2013-12-18	BKF	ETF	37.08	37.93	36.86	37.63	310550.0
2013-12-18	BKLN	ETF	24.77	24.82	24.76	24.82	2365200.0
2013-12-18	BLV	ETF	82.29	82.85	82.15	82.36	80400.0

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

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