PREVIEW / etf_daily / 2011-03-28

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-28.parquet
  size:    36 KB
  rows:    834

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-03-28	SPY	ETF	131.58	131.92	130.94	130.98	109762400.0
2011-03-28	QQQ	ETF	57.09	57.1	56.5	56.53	37823728.0
2011-03-28	IWM	ETF	82.49	82.76	81.97	82.04	42798300.0
2011-03-28	DIA	ETF	122.11	122.46	121.7	121.76	2663400.0
2011-03-28	GLD	ETF	137.82	138.83	137.78	138.54	7656000.0
2011-03-28	TLT	ETF	92.12	92.67	92.0	92.3	3996800.0
2011-03-28	AADR	ETF	30.33	30.33	30.12	30.12	200.0
2011-03-28	AAXJ	ETF	61.5	61.76	61.42	61.51	304600.0
2011-03-28	ACWI	ETF	47.9	48.05	47.61	47.63	311000.0
2011-03-28	ACWX	ETF	44.77	44.905	44.604	44.63	52091.0
2011-03-28	ADRE	ETF	47.01	47.25	46.89	46.89	45852.0
2011-03-28	AFK	ETF	32.22	32.46	32.22	32.39	10775.0
2011-03-28	AGG	ETF	105.13	105.26	105.08	105.2	1443600.0
2011-03-28	AGQ	ETF	426.1	439.7	425.48	436.0	420250.0
2011-03-28	AGZ	ETF	109.37	109.37	109.0814	109.29	27221.0
2011-03-28	AIA	ETF	46.32	46.5599	46.32	46.37	27072.0
2011-03-28	AIQ	ETF	21.75	22.15	21.5	22.1	12723.0
2011-03-28	AIS	ETF	1.65	1.66	1.63	1.66	180677.0
2011-03-28	AIVI	ETF	46.19	46.3	46.08	46.09	5300.0
2011-03-28	AMJ	ETF	37.77	38.11	37.59	37.67	682238.0
2011-03-28	AMLP	ETF	81.8	81.9	81.25	81.4	119040.0
2011-03-28	AOA	ETF	35.59	35.67	35.42	35.42	14900.0
2011-03-28	AOK	ETF	29.15	29.16	29.1101	29.1101	22629.0
2011-03-28	AOM	ETF	30.33	30.4	30.33	30.35	14086.0
2011-03-28	AOR	ETF	32.33	32.36	32.22	32.2399	8715.0
2011-03-28	ARB	ETF	38.56	38.7	38.27	38.47	85220.0
2011-03-28	ARGT	ETF	29.52	29.68	29.32	29.5	2550.0
2011-03-28	ASEA	ETF	15.61	15.61	15.58	15.59	5400.0
2011-03-28	BAB	ETF	25.2	25.32	25.2	25.29	91329.0
2011-03-28	BAL	ETF	102.36	102.758	100.225	100.57	150957.0
2011-03-28	BALT	ETF	8.99	9.1	8.96	8.98	97698.0
2011-03-28	BBH	ETF	34.9433	34.9967	34.6733	34.7533	36900.0
2011-03-28	BIB	ETF	7.94	7.94	7.94	7.94	800.0
2011-03-28	BICK	ETF	32.39	32.458	32.26	32.2904	23684.0
2011-03-28	BIL	ETF	91.7	91.72	91.7	91.72	733950.0
2011-03-28	BIS	ETF	7777.6	7777.6	7537.6	7539.2	4.375
2011-03-28	BITS	ETF	25.84	25.84	25.2	25.44	1750.0
2011-03-28	BIV	ETF	82.09	82.16	81.93	82.02	260100.0
2011-03-28	BJK	ETF	32.03	32.17	31.91	31.93	9200.0
2011-03-28	BKF	ETF	48.69	49.08	48.61	48.63	131056.0
2011-03-28	BKLN	ETF	25.04	25.05	25.01	25.04	146600.0
2011-03-28	BLV	ETF	78.22	78.61	78.22	78.41	25100.0
2011-03-28	BMVP	ETF	15.47	15.53	15.42	15.42	6794.0
2011-03-28	BND	ETF	80.06	80.18	80.04	80.11	810700.0
2011-03-28	BNO	ETF	38.085	38.475	38.045	38.045	62600.0
2011-03-28	BRF	ETF	53.68	53.8	53.01	53.08	91247.0
2011-03-28	BSCE	ETF	20.82	20.91	20.82	20.9099	4163.0
2011-03-28	BSV	ETF	80.23	80.27	80.19	80.25	629700.0
2011-03-28	BTF	ETF	84.0	84.15050000000001	83.9	84.1	1292.4
2011-03-28	BWX	ETF	30.015	30.055	29.965	30.025	198440.0

> showing 50 of 834 rows — these rows as CSV

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