PREVIEW / etf_daily / 2011-05-26

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-26.parquet
  size:    36 KB
  rows:    844

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
2011-05-26	SPY	ETF	132.03	133.24	131.78	133.0	164850000.0
2011-05-26	QQQ	ETF	56.62	57.3	56.61	57.1415	40564078.0
2011-05-26	IWM	ETF	81.7	83.12	81.65	83.08	51821300.0
2011-05-26	DIA	ETF	123.41	124.17	122.92	123.8	6190400.0
2011-05-26	GLD	ETF	148.45	148.61	147.59	148.22	9785500.0
2011-05-26	TLT	ETF	95.97	96.55	95.89	96.51	8307900.0
2011-05-26	AADR	ETF	30.81	31.07	30.81	31.05	800.0
2011-05-26	AAXJ	ETF	61.61	62.16	61.6	62.14	205500.0
2011-05-26	ACTV	ETF	15.81	16.89	15.3	16.28	611555.0
2011-05-26	ACWI	ETF	48.18	48.6	48.01	48.58	451300.0
2011-05-26	ACWX	ETF	44.9	45.19	44.6159	45.15	88730.0
2011-05-26	ADRE	ETF	45.63	46.039	45.411	45.98	53215.0
2011-05-26	AFK	ETF	32.63	32.8	32.5	32.58	27893.0
2011-05-26	AGG	ETF	107.16	107.39	107.11	107.33	861600.0
2011-05-26	AGQ	ETF	392.06	395.9	376.5	391.4	1197250.0
2011-05-26	AGZ	ETF	110.42	110.6008	110.42	110.6008	8991.0
2011-05-26	AIA	ETF	47.0	47.2	46.89	47.16	33743.0
2011-05-26	AIQ	ETF	20.7	21.3	20.55	21.3	18518.0
2011-05-26	AIS	ETF	1.77	1.83	1.76	1.82	816398.0
2011-05-26	AIVI	ETF	47.37	47.7	47.03	47.59	4100.0
2011-05-26	AMJ	ETF	36.57	36.7	36.37	36.63	1319329.0
2011-05-26	AMLP	ETF	79.45	79.6	79.25	79.55	172220.0
2011-05-26	AOA	ETF	35.72	36.09	35.72	36.09	10800.0
2011-05-26	AOK	ETF	29.38	29.45	29.35	29.446	14893.0
2011-05-26	AOM	ETF	30.7	30.819	30.69	30.818	20776.0
2011-05-26	AOR	ETF	32.631	32.83	32.6001	32.77	29575.0
2011-05-26	ARB	ETF	41.92	42.27	41.34	41.8	90413.0
2011-05-26	ARGT	ETF	29.3	29.42	29.2	29.2	800.0
2011-05-26	BAB	ETF	26.47	26.63	26.47	26.63	115341.0
2011-05-26	BAL	ETF	85.39	85.64	83.5	83.82	40424.0
2011-05-26	BALT	ETF	6.3	6.5	6.18	6.36	322639.0
2011-05-26	BBH	ETF	34.4033	34.7533	34.3733	34.6867	14400.0
2011-05-26	BCM	ETF	47.75	47.75	47.53	47.64	2000.0
2011-05-26	BIB	ETF	9.7338	9.825	9.6837	9.8153	22960.0
2011-05-26	BICK	ETF	31.87	32.16	31.87	32.1	6457.0
2011-05-26	BIL	ETF	91.72	91.72	91.7	91.72	819300.0
2011-05-26	BIS	ETF	6040.0	6040.0	6040.0	6040.0	2.125
2011-05-26	BITS	ETF	24.4	24.64	22.24	23.92	4092.0
2011-05-26	BIV	ETF	84.26	84.5	84.25	84.5	155200.0
2011-05-26	BJK	ETF	34.26	34.38	34.15	34.38	1600.0
2011-05-26	BKF	ETF	46.99	47.41	46.84	47.389	53385.0
2011-05-26	BKLN	ETF	25.05	25.09	25.01	25.05	88700.0
2011-05-26	BLNG	ETF	48.65	48.76	48.65	48.76	400.0
2011-05-26	BLV	ETF	81.7	82.0	81.7	81.99	17100.0
2011-05-26	BMVP	ETF	15.6104	15.7733	15.6104	15.7367	3563.0
2011-05-26	BND	ETF	81.49	81.65	81.45	81.56	1436000.0
2011-05-26	BNO	ETF	38.2	38.4	38.07	38.28	70600.0
2011-05-26	BRF	ETF	55.28	55.81	54.99	55.81	165199.0
2011-05-26	BSCE	ETF	21.16	21.19	21.16	21.18	10956.0
2011-05-26	BSV	ETF	80.97	81.07	80.97	81.07	393600.0

> showing 50 of 844 rows — these rows as CSV

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