PREVIEW / etf_daily / 2013-03-12

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-12.parquet
  size:    40 KB
  rows:    973

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-03-12	SPY	ETF	155.92	156.1	155.21	155.68	105755800.0
2013-03-12	QQQ	ETF	68.79	68.9299	68.39	68.72	27579252.0
2013-03-12	IWM	ETF	93.48	93.75	93.18	93.51	21489000.0
2013-03-12	DIA	ETF	144.29	144.7	144.03	144.4	5166400.0
2013-03-12	GLD	ETF	154.07	154.69	153.9	154.19	7265700.0
2013-03-12	TLT	ETF	115.25	115.79	115.23	115.69	9264200.0
2013-03-12	AADR	ETF	33.37	33.37	33.37	33.37	100.0
2013-03-12	AAXJ	ETF	60.14	60.14	59.63	59.75	1879300.0
2013-03-12	ACTV	ETF	4.94	4.94	4.78	4.79	583667.0
2013-03-12	ACWI	ETF	51.01	51.01	50.69	50.78	911500.0
2013-03-12	ACWV	ETF	60.35	60.39	60.2	60.33	125800.0
2013-03-12	ACWX	ETF	43.37	43.41	43.0955	43.16	244323.0
2013-03-12	ADRE	ETF	39.83	39.95	39.58	39.68	21415.0
2013-03-12	AFK	ETF	30.71	30.9	30.6845	30.7	34529.0
2013-03-12	AGG	ETF	109.94	110.08	109.93	110.08	1656200.0
2013-03-12	AGQ	ETF	160.52	162.08	159.72	160.08	259550.0
2013-03-12	AGZ	ETF	112.89	112.92	112.81	112.92	8005.0
2013-03-12	AIA	ETF	46.99	46.99	46.57	46.61	25804.0
2013-03-12	AIQ	ETF	7.15	7.25	7.0	7.24	3281.0
2013-03-12	AIVI	ETF	42.8	42.88	42.5	42.56	46500.0
2013-03-12	ALTL	ETF	28.9199	28.9199	28.9199	28.9199	275.0
2013-03-12	AMJ	ETF	43.72	43.81	43.43	43.53	2434356.0
2013-03-12	AMLP	ETF	86.1	86.4	85.75	86.0	974360.0
2013-03-12	ANGL	ETF	27.12	27.12	27.03	27.06	1300.0
2013-03-12	AOA	ETF	39.79	39.79	39.44	39.49	55200.0
2013-03-12	AOK	ETF	30.9	31.11	30.9	31.06	26926.0
2013-03-12	AOM	ETF	32.67	32.6887	32.6	32.65	20826.0
2013-03-12	AOR	ETF	35.37	35.5226	35.37	35.44	43326.0
2013-03-12	ARB	ETF	46.88	46.93	46.88	46.88	184981.0
2013-03-12	ARGT	ETF	17.9	18.02	17.86	17.88	1600.0
2013-03-12	ASEA	ETF	17.39	17.51	17.39	17.42	9800.0
2013-03-12	AWAY	ETF	30.33	30.5	29.86	30.15	431631.0
2013-03-12	BAB	ETF	30.1	30.14	30.031	30.07	1300249.0
2013-03-12	BAL	ETF	55.96	56.69	55.84	56.38	11790.0
2013-03-12	BALT	ETF	4.03	4.05	3.88	3.95	38960.0
2013-03-12	BBH	ETF	62.93	62.93	62.43	62.93	19400.0
2013-03-12	BCM	ETF	43.34	43.34	43.16	43.2	2325.0
2013-03-12	BIB	ETF	18.5575	18.85	18.5102	18.8275	63476.0
2013-03-12	BICK	ETF	25.0	25.03	24.98	25.03	13600.0
2013-03-12	BIL	ETF	91.6	91.62	91.6	91.6	159950.0
2013-03-12	BIS	ETF	2026.4	2026.4	2008.8	2008.8	130.0
2013-03-12	BIV	ETF	87.23	87.24	87.14	87.21	348800.0
2013-03-12	BIZD	ETF	20.77	20.78	20.71	20.74	3700.0
2013-03-12	BJK	ETF	38.67	38.71	38.38	38.43	7300.0
2013-03-12	BKF	ETF	40.55	40.59	40.1	40.22	128420.0
2013-03-12	BKLN	ETF	25.11	25.12	25.09	25.12	2426500.0
2013-03-12	BLV	ETF	90.59	90.71	90.47	90.68	75000.0
2013-03-12	BMVP	ETF	18.21	18.27	18.21	18.24	700.0
2013-03-12	BND	ETF	83.07	83.18	83.07	83.18	1214000.0
2013-03-12	BNO	ETF	41.75	41.85	41.285	41.345	240200.0

> showing 50 of 973 rows — these rows as CSV

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