PREVIEW / etf_daily / 2013-12-19

all etf daily files

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

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-19	SPY	ETF	181.18	181.7	180.71	181.49	136531200.0
2013-12-19	QQQ	ETF	85.99	86.01	85.52	85.9	46489555.0
2013-12-19	IWM	ETF	112.72	112.85	111.89	112.04	32871100.0
2013-12-19	DIA	ETF	161.48	162.01	161.28	161.88	8018300.0
2013-12-19	GLD	ETF	115.97	116.06	114.5	114.82	15955400.0
2013-12-19	TLT	ETF	102.86	103.01	102.45	102.67	6708400.0
2013-12-19	AADR	ETF	36.83	36.83	36.82	36.82	400.0
2013-12-19	AAXJ	ETF	58.79	58.91	58.32	58.69	1396500.0
2013-12-19	ACWI	ETF	55.97	56.09	55.77	56.06	1389200.0
2013-12-19	ACWV	ETF	62.55	62.55	62.15	62.48	46200.0
2013-12-19	ACWX	ETF	45.03	45.22	44.9136	45.17	364363.0
2013-12-19	ADRE	ETF	36.71	36.929	36.52	36.85	24531.0
2013-12-19	AFK	ETF	31.05	31.05	30.8	30.96	21640.0
2013-12-19	AGG	ETF	106.58	106.75	106.47	106.68	2011400.0
2013-12-19	AGQ	ETF	61.76	62.12	61.08	61.52	673725.0
2013-12-19	AGZ	ETF	110.9485	111.14	110.8	110.8824	98726.0
2013-12-19	AGZD	ETF	25.105	25.105	25.035	25.035	2000.0
2013-12-19	AIA	ETF	46.86	46.8672	46.45	46.852	25173.0
2013-12-19	AIQ	ETF	23.88	24.99	23.53	24.72	25410.0
2013-12-19	AIVI	ETF	46.2	46.42	46.08	46.36	25400.0
2013-12-19	ALTL	ETF	32.18	32.25	32.17	32.25	765.0
2013-12-19	AMJ	ETF	43.47	44.03	43.41	44.03	629498.0
2013-12-19	AMLP	ETF	85.55	85.7	84.9	85.7	566900.0
2013-12-19	ANGL	ETF	27.09	27.09	27.09	27.09	300.0
2013-12-19	AOA	ETF	43.81	43.85	43.74	43.83	26100.0
2013-12-19	AOK	ETF	31.77	31.84	31.766	31.81	25170.0
2013-12-19	AOM	ETF	34.07	34.08	34.0	34.05	84011.0
2013-12-19	AOR	ETF	38.05	38.09	37.9917	38.08	44410.0
2013-12-19	ARGT	ETF	20.02	20.03	19.93	19.93	1300.0
2013-12-19	ASEA	ETF	15.69	15.77	15.61	15.77	33300.0
2013-12-19	ASHR	ETF	24.54	24.59	24.31	24.53	350100.0
2013-12-19	ATMP	ETF	25.97	26.09	25.97	26.09	40000.0
2013-12-19	AVIV	ETF	23.98	24.16	23.38	23.5	248458.0
2013-12-19	AWAY	ETF	39.18	40.22	39.01	40.0	944093.0
2013-12-19	BAB	ETF	27.44	27.44	27.294	27.37	437175.0
2013-12-19	BAL	ETF	52.24	52.4701	52.1701	52.1701	12102.0
2013-12-19	BALT	ETF	5.4	5.8	5.39	5.72	1133938.0
2013-12-19	BBH	ETF	86.0	86.25	85.34	85.83	42200.0
2013-12-19	BCM	ETF	39.32	39.4	39.25	39.321	355866.0
2013-12-19	BFOR	ETF	7.2675	7.295	7.26	7.2725	125200.0
2013-12-19	BIB	ETF	35.11	35.5725	34.875	35.29	128460.0
2013-12-19	BICK	ETF	24.13	24.13	23.961	24.1221	2305.0
2013-12-19	BIL	ETF	91.56	91.58	91.56	91.58	1356750.0
2013-12-19	BIS	ETF	884.8	901.96	884.0	899.2	332.0
2013-12-19	BIV	ETF	82.92	83.01	82.81	83.01	340500.0
2013-12-19	BIZD	ETF	21.17	21.19	20.94	20.94	14200.0
2013-12-19	BJK	ETF	52.43	52.43	52.0	52.31	37700.0
2013-12-19	BKF	ETF	37.08	37.15	36.68	36.99	142615.0
2013-12-19	BKLN	ETF	24.79	24.81	24.76	24.78	3169200.0
2013-12-19	BLV	ETF	82.27	82.38	82.16	82.26	40400.0

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

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