PREVIEW / etf_daily / 2011-04-04

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-04.parquet
  size:    36 KB
  rows:    836

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-04-04	SPY	ETF	133.43	133.67	132.88	133.26	100768900.0
2011-04-04	QQQ	ETF	57.62	57.68	57.02	57.27	48659037.0
2011-04-04	IWM	ETF	84.76	84.97	84.54	84.73	42236600.0
2011-04-04	DIA	ETF	123.64	123.84	123.45	123.76	6278900.0
2011-04-04	GLD	ETF	140.13	140.26	139.45	139.84	9685100.0
2011-04-04	TLT	ETF	92.2	92.58	92.13	92.29	4469100.0
2011-04-04	AADR	ETF	31.08	31.08	31.08	31.08	100.0
2011-04-04	AAXJ	ETF	64.76	64.9	64.48	64.87	1469400.0
2011-04-04	ACWI	ETF	48.91	49.0	48.77	48.87	1461400.0
2011-04-04	ACWX	ETF	45.99	46.12	45.88	46.07	101462.0
2011-04-04	ADRE	ETF	49.3	49.5599	49.26	49.5599	47027.0
2011-04-04	AFK	ETF	33.7	33.95	33.7	33.8	14174.0
2011-04-04	AGG	ETF	105.03	105.25	105.02	105.13	517500.0
2011-04-04	AGQ	ETF	470.12	471.84	464.0	469.94	471100.0
2011-04-04	AGZ	ETF	109.42	109.42	109.26	109.29	8071.0
2011-04-04	AIA	ETF	48.66	48.8136	48.6	48.8136	26582.0
2011-04-04	AIQ	ETF	21.85	22.5	21.7	22.25	35094.0
2011-04-04	AIS	ETF	1.78	1.78	1.71	1.72	295368.0
2011-04-04	AIVI	ETF	47.69	47.84	47.62	47.78	9200.0
2011-04-04	AMJ	ETF	38.09	38.25	38.09	38.19	539818.0
2011-04-04	AMLP	ETF	82.3	82.3	82.05	82.15	99620.0
2011-04-04	AOA	ETF	36.27	36.29	36.17	36.24	6800.0
2011-04-04	AOK	ETF	29.26	29.27	29.2125	29.23	13121.0
2011-04-04	AOM	ETF	30.68	30.68	30.62	30.6428	41452.0
2011-04-04	AOR	ETF	32.77	32.77	32.67	32.74	10296.0
2011-04-04	ARB	ETF	39.28	40.01	39.14	39.94	114354.0
2011-04-04	ARGT	ETF	31.16	31.26	30.98	31.18	13000.0
2011-04-04	ASEA	ETF	16.12	16.16	16.1	16.16	5300.0
2011-04-04	BAB	ETF	25.26	25.41	25.26	25.32	125725.0
2011-04-04	BAL	ETF	100.32	101.48	99.73	101.0	108489.0
2011-04-04	BALT	ETF	9.15	9.33	9.15	9.29	236300.0
2011-04-04	BBH	ETF	35.42	35.69	35.42	35.6367	20700.0
2011-04-04	BIB	ETF	8.955	8.955	8.72	8.75	37000.0
2011-04-04	BICK	ETF	34.49	34.49	34.1	34.2201	64364.0
2011-04-04	BIL	ETF	91.7	91.74	91.7	91.7	144700.0
2011-04-04	BIS	ETF	7208.0	7208.0	6776.16	6832.0	5.0
2011-04-04	BITS	ETF	25.64	25.64	25.32	25.6	1400.0
2011-04-04	BIV	ETF	81.92	82.09	81.86	82.03	135600.0
2011-04-04	BJK	ETF	32.97	33.03	32.92	32.99	5000.0
2011-04-04	BKF	ETF	52.02	52.13	51.57	52.13	348811.0
2011-04-04	BKLN	ETF	25.2	25.2	25.11	25.19	70300.0
2011-04-04	BLV	ETF	78.22	78.6	78.22	78.42	17200.0
2011-04-04	BMVP	ETF	15.79	15.81	15.767	15.792	7586.0
2011-04-04	BND	ETF	79.98	80.09	79.93	79.99	605000.0
2011-04-04	BNO	ETF	39.67	40.22	39.66	40.105	178000.0
2011-04-04	BRF	ETF	58.5	59.15	58.21	59.09	289558.0
2011-04-04	BSCE	ETF	20.88	20.93	20.88	20.9299	8914.0
2011-04-04	BSV	ETF	80.13	80.18	80.1	80.14	285000.0
2011-04-04	BTF	ETF	83.64999999999999	83.8	83.35000000000001	83.35000000000001	1920.6000000000001
2011-04-04	BWX	ETF	29.975	30.025	29.925	29.935	276284.0

> showing 50 of 836 rows — these rows as CSV

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