PREVIEW / etf_daily / 2012-06-25

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-25.parquet
  size:    38 KB
  rows:    937

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
2012-06-25	SPY	ETF	132.05	132.1	130.85	131.32	146375700.0
2012-06-25	QQQ	ETF	62.84	62.85	61.95	62.13	33136337.0
2012-06-25	IWM	ETF	76.4	77.6	76.0	76.28	48620100.0
2012-06-25	DIA	ETF	125.06	125.09	124.32	124.76	5922300.0
2012-06-25	GLD	ETF	152.58	154.16	152.25	153.76	6183600.0
2012-06-25	TLT	ETF	126.36	127.02	126.27	126.84	6113800.0
2012-06-25	AAXJ	ETF	50.37	50.37	49.96	50.15	647400.0
2012-06-25	ACTV	ETF	15.47	15.57	15.35	15.36	443803.0
2012-06-25	ACWI	ETF	42.38	42.38	41.93	42.04	1256100.0
2012-06-25	ACWV	ETF	55.0	55.0	53.32	53.44	14300.0
2012-06-25	ACWX	ETF	35.41	35.47	35.23	35.35	247870.0
2012-06-25	ADRE	ETF	35.93	35.98	35.6318	35.76	64457.0
2012-06-25	AFK	ETF	26.85	27.028	26.774	26.97	59735.0
2012-06-25	AGEM	ETF	19.95	19.95	19.79	19.79	1914.0
2012-06-25	AGG	ETF	111.25	111.4	111.22	111.39	2321900.0
2012-06-25	AGQ	ETF	145.4	154.68	144.76	153.44	380800.0
2012-06-25	AGZ	ETF	113.52	113.58	113.428	113.52	11672.0
2012-06-25	AIA	ETF	39.6	39.61	39.175	39.28	13255.0
2012-06-25	AIQ	ETF	4.3	4.631	4.2	4.631	18367.0
2012-06-25	AIVI	ETF	36.15	36.15	35.88	36.0	46600.0
2012-06-25	AMJ	ETF	36.3	36.4	35.83	36.1	3495914.0
2012-06-25	AMLP	ETF	77.9	77.9	77.05	77.25	522720.0
2012-06-25	ANGL	ETF	25.45	25.45	25.41	25.41	1700.0
2012-06-25	AOA	ETF	34.18	34.18	33.98	34.09	5400.0
2012-06-25	AOK	ETF	29.62	29.66	29.61	29.65	26769.0
2012-06-25	AOM	ETF	30.4	30.42	30.34	30.42	10331.0
2012-06-25	AOR	ETF	31.99	31.99	31.8505	31.935	6573.0
2012-06-25	ARB	ETF	34.12	34.25	33.88	34.2	57011.0
2012-06-25	ARGT	ETF	15.4	15.4	15.24	15.3	1200.0
2012-06-25	ASEA	ETF	14.86	14.97	14.82	14.97	1900.0
2012-06-25	AWAY	ETF	21.09	21.09	20.2	20.5	388710.0
2012-06-25	BAB	ETF	29.74	29.88	29.72	29.85	121230.0
2012-06-25	BAL	ETF	45.7449	46.44	45.28	46.4	8359.0
2012-06-25	BALT	ETF	3.57	3.6	3.19	3.3	164915.0
2012-06-25	BBH	ETF	46.39	46.51	46.02	46.26	10600.0
2012-06-25	BCM	ETF	40.11	40.399	40.11	40.391	1192.0
2012-06-25	BIB	ETF	12.8537	12.8537	11.4525	12.5062	49768.0
2012-06-25	BICK	ETF	21.42	21.42	21.24	21.41	2141.0
2012-06-25	BIL	ETF	91.64	91.66	91.64	91.66	788250.0
2012-06-25	BIS	ETF	3355.2	3355.2	3343.68	3343.68	23.3
2012-06-25	BIV	ETF	88.69	88.82	88.58	88.75	341200.0
2012-06-25	BJK	ETF	31.35	31.38	31.02	31.2	63800.0
2012-06-25	BKF	ETF	33.99	34.03	33.62	33.85	74735.0
2012-06-25	BKLN	ETF	24.24	24.3	24.16	24.2	169700.0
2012-06-25	BLV	ETF	95.34	95.79	95.34	95.54	40700.0
2012-06-25	BMVP	ETF	14.77	14.77	14.67	14.73	6368.0
2012-06-25	BND	ETF	84.33	84.36	84.26	84.35	1189200.0
2012-06-25	BNO	ETF	32.055	32.4	31.5	32.395	54200.0
2012-06-25	BOIL	ETF	866400.0	879000.0	847800.0	849600.0	8.4
2012-06-25	BOND	ETF	105.87	105.9	105.8005	105.88	805031.0

> showing 50 of 937 rows — these rows as CSV

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