PREVIEW / etf_daily / 2012-01-23

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-23.parquet
  size:    37 KB
  rows:    900

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-01-23	SPY	ETF	131.51	132.25	130.98	131.61	129295800.0
2012-01-23	QQQ	ETF	59.8	60.21	59.44	59.79	40964630.0
2012-01-23	IWM	ETF	78.26	78.84	77.55	78.15	37481400.0
2012-01-23	DIA	ETF	126.89	127.36	126.38	126.81	5166800.0
2012-01-23	GLD	ETF	162.32	163.47	162.32	163.16	8832100.0
2012-01-23	TLT	ETF	116.13	116.64	115.55	116.24	7274800.0
2012-01-23	AAXJ	ETF	54.65	55.17	54.65	54.84	302300.0
2012-01-23	ACTV	ETF	14.17	15.35	14.01	14.28	155023.0
2012-01-23	ACWI	ETF	44.38	44.66	44.28	44.47	384900.0
2012-01-23	ACWV	ETF	52.46	52.56	52.36	52.37	8100.0
2012-01-23	ACWX	ETF	38.71	38.96	38.66	38.83	394598.0
2012-01-23	ADRE	ETF	41.94	42.27	41.88	42.17	59106.0
2012-01-23	AFK	ETF	26.87	27.3	26.87	27.2	37171.0
2012-01-23	AGEM	ETF	23.01	23.01	22.88	22.88	800.0
2012-01-23	AGG	ETF	109.77	109.99	109.77	109.89	819600.0
2012-01-23	AGQ	ETF	220.72	230.4	220.72	224.48	576225.0
2012-01-23	AGZ	ETF	112.67	112.86	112.625	112.79	47373.0
2012-01-23	AIA	ETF	42.67	43.07	42.67	42.79	44989.0
2012-01-23	AIQ	ETF	5.7	5.85	5.65	5.8	5407.0
2012-01-23	AIS	ETF	2.21	2.23	2.16	2.18	573185.0
2012-01-23	AIVI	ETF	40.49	40.66	40.3	40.5	53000.0
2012-01-23	AMJ	ETF	39.55	39.92	39.5024	39.88	592352.0
2012-01-23	AMLP	ETF	83.8	84.25	83.75	84.2	454680.0
2012-01-23	AOA	ETF	34.55	34.77	34.47	34.53	4300.0
2012-01-23	AOK	ETF	29.55	29.61	29.55	29.57	29971.0
2012-01-23	AOM	ETF	30.36	30.44	30.36	30.41	16767.0
2012-01-23	AOR	ETF	32.04	32.08	31.99	32.06	21163.0
2012-01-23	ARB	ETF	36.72	36.95	35.88	36.2	142943.0
2012-01-23	ARGT	ETF	23.56	23.9	23.56	23.74	2100.0
2012-01-23	ASEA	ETF	15.47	15.59	15.42	15.51	7700.0
2012-01-23	AWAY	ETF	25.5	25.93	25.01	25.815	197632.0
2012-01-23	BAB	ETF	28.63	29.0	28.5	28.61	158999.0
2012-01-23	BAL	ETF	61.16	61.6085	60.75	61.35	21839.0
2012-01-23	BALT	ETF	4.43	4.5	4.4	4.43	89776.0
2012-01-23	BBH	ETF	40.74	40.74	39.9533	40.0367	34800.0
2012-01-23	BCM	ETF	44.56	44.756	44.56	44.7	3941.0
2012-01-23	BIB	ETF	10.2012	10.2402	9.9388	10.0275	98208.0
2012-01-23	BICK	ETF	26.2	26.46	26.145	26.39	19138.0
2012-01-23	BIL	ETF	91.66	91.66	91.64	91.64	224350.0
2012-01-23	BIS	ETF	4446.4	4555.2	4446.4	4523.2	86.0
2012-01-23	BITS	ETF	22.56	22.76	22.52	22.76	771.0
2012-01-23	BIV	ETF	86.8	86.85	86.63	86.82	155700.0
2012-01-23	BJK	ETF	32.24	32.6	32.15	32.4	26000.0
2012-01-23	BKF	ETF	40.58	41.03	40.47	40.84	212130.0
2012-01-23	BKLN	ETF	24.2	24.2	24.12	24.12	52700.0
2012-01-23	BLV	ETF	90.1	90.2	89.62	90.03	136600.0
2012-01-23	BMVP	ETF	14.383	14.51	14.37	14.417	3223.0
2012-01-23	BND	ETF	83.3	83.39	83.22	83.27	885500.0
2012-01-23	BNO	ETF	38.48	38.76	38.415	38.575	68600.0
2012-01-23	BOIL	ETF	1351000.0	1500000.0	1331000.0	1497000.0	6.0

> showing 50 of 900 rows — these rows as CSV

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