PREVIEW / etf_daily / 2011-03-30

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-30.parquet
  size:    35 KB
  rows:    831

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-30	SPY	ETF	132.55	133.16	132.36	132.77	135835000.0
2011-03-30	QQQ	ETF	57.36	57.43	57.08	57.35	44935856.0
2011-03-30	IWM	ETF	83.17	83.99	83.04	83.88	42147100.0
2011-03-30	DIA	ETF	123.0	123.58	122.94	123.21	4100800.0
2011-03-30	GLD	ETF	139.07	139.18	137.68	138.67	10749400.0
2011-03-30	TLT	ETF	91.72	92.32	91.56	92.32	5048300.0
2011-03-30	AADR	ETF	30.34	30.5	30.28	30.47	2800.0
2011-03-30	AAXJ	ETF	62.61	62.9	62.43	62.74	192700.0
2011-03-30	ACWI	ETF	48.42	48.56	48.24	48.42	1016800.0
2011-03-30	ACWX	ETF	45.3	45.53	45.24	45.53	155586.0
2011-03-30	ADRE	ETF	47.7	48.1724	47.7	48.06	104167.0
2011-03-30	AFK	ETF	33.18	33.3	33.06	33.2699	25672.0
2011-03-30	AGG	ETF	105.17	105.3	105.1	105.25	791500.0
2011-03-30	AGQ	ETF	448.48	449.28	433.32	443.82	581300.0
2011-03-30	AGZ	ETF	109.19	109.47	109.19	109.25	23140.0
2011-03-30	AIA	ETF	47.34	47.71	47.32	47.66	24084.0
2011-03-30	AIQ	ETF	21.95	21.95	21.4	21.5	10163.0
2011-03-30	AIS	ETF	1.71	1.76	1.62	1.76	661909.0
2011-03-30	AIVI	ETF	46.84	47.13	46.78	46.98	9800.0
2011-03-30	AMJ	ETF	37.74	37.8639	37.54	37.81	500705.0
2011-03-30	AMLP	ETF	81.45	81.6	81.35	81.55	172340.0
2011-03-30	AOA	ETF	35.8	36.03	35.8	35.98	45100.0
2011-03-30	AOK	ETF	29.2	29.24	29.15	29.2208	31282.0
2011-03-30	AOM	ETF	30.49	30.55	30.4508	30.5356	12263.0
2011-03-30	AOR	ETF	32.49	32.58	32.458	32.55	11655.0
2011-03-30	ARB	ETF	39.26	39.45	38.96	39.38	96986.0
2011-03-30	ARGT	ETF	29.92	30.26	29.84	30.08	17950.0
2011-03-30	ASEA	ETF	15.82	15.89	15.82	15.82	11900.0
2011-03-30	BAB	ETF	25.24	25.306	25.17	25.22	95444.0
2011-03-30	BAL	ETF	100.73	101.13	99.2912	100.89	165124.0
2011-03-30	BALT	ETF	8.97	9.03	8.9	9.03	127600.0
2011-03-30	BBH	ETF	35.1733	35.5033	35.1733	35.3567	27900.0
2011-03-30	BIB	ETF	8.375	8.475	8.365	8.4548	11712.0
2011-03-30	BICK	ETF	33.1	33.37	33.0	33.24	18851.0
2011-03-30	BIL	ETF	91.72	91.72	91.7	91.72	589950.0
2011-03-30	BIS	ETF	7115.2	7115.2	7008.0	7008.0	5.0
2011-03-30	BITS	ETF	25.52	25.6	25.44	25.56	175.0
2011-03-30	BIV	ETF	81.93	82.14	81.89	82.1	73700.0
2011-03-30	BJK	ETF	32.13	32.43	32.13	32.38	8400.0
2011-03-30	BKF	ETF	49.61	49.99	49.4203	49.965	205697.0
2011-03-30	BKLN	ETF	25.1	25.11	25.06	25.11	75900.0
2011-03-30	BLV	ETF	78.01	78.61	77.95	78.59	28900.0
2011-03-30	BMVP	ETF	15.62	15.67	15.6	15.65	10586.0
2011-03-30	BND	ETF	80.05	80.14	79.98	80.11	746900.0
2011-03-30	BNO	ETF	38.255	38.34	38.05	38.195	25600.0
2011-03-30	BOSS	ETF	52.63	53.91	52.63	53.91	100.0
2011-03-30	BRF	ETF	54.5	55.86	54.5	55.76	367017.0
2011-03-30	BSCE	ETF	20.83	20.92	20.83	20.92	26463.0
2011-03-30	BSV	ETF	80.22	80.26	80.18	80.21	484700.0
2011-03-30	BTF	ETF	84.94999999999999	85.55	84.3505	84.49	3516.0

> showing 50 of 831 rows — these rows as CSV

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