PREVIEW / etf_daily / 2011-04-01

all etf daily files

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

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-01	SPY	ETF	133.41	133.77	132.83	133.15	153850100.0
2011-04-01	QQQ	ETF	57.72	57.9	57.29	57.46	68031747.0
2011-04-01	IWM	ETF	84.77	85.02	84.25	84.54	49160200.0
2011-04-01	DIA	ETF	123.59	123.95	123.14	123.46	5203200.0
2011-04-01	GLD	ETF	138.65	139.55	137.72	139.2	15738300.0
2011-04-01	TLT	ETF	91.5	92.27	91.42	92.19	7860400.0
2011-04-01	AADR	ETF	30.93	31.04	30.9	31.04	1600.0
2011-04-01	AAXJ	ETF	63.5	64.28	63.48	64.13	2699500.0
2011-04-01	ACWI	ETF	48.48	48.91	48.47	48.73	1044000.0
2011-04-01	ACWX	ETF	45.6	46.02	45.5099	45.92	122174.0
2011-04-01	ADRE	ETF	48.88	49.2838	48.86	49.14	52659.0
2011-04-01	AFK	ETF	33.55	33.78	33.4112	33.605	6874.0
2011-04-01	AGG	ETF	104.71	105.03	104.68	104.96	983700.0
2011-04-01	AGQ	ETF	441.12	453.96	435.28	451.6	596500.0
2011-04-01	AGZ	ETF	109.15	109.23	109.03	109.23	11361.0
2011-04-01	AIA	ETF	48.3	48.6	48.27	48.41	31534.0
2011-04-01	AIQ	ETF	22.15	22.2	21.5	21.8	16075.0
2011-04-01	AIS	ETF	1.84	1.84	1.7	1.76	815723.0
2011-04-01	AIVI	ETF	47.1	47.66	46.94	47.56	10800.0
2011-04-01	AMJ	ETF	38.27	38.27	38.055	38.17	1087529.0
2011-04-01	AMLP	ETF	82.05	82.2	81.85	82.05	78460.0
2011-04-01	AOA	ETF	36.2	36.29	36.09	36.11	16900.0
2011-04-01	AOK	ETF	29.24	29.3	29.24	29.298	3713.0
2011-04-01	AOM	ETF	30.54	30.65	30.54	30.63	45863.0
2011-04-01	AOR	ETF	32.68	32.74	32.619	32.69	20964.0
2011-04-01	ARB	ETF	40.16	40.47	38.92	39.1	196031.0
2011-04-01	ARGT	ETF	30.62	30.78	30.6	30.76	5900.0
2011-04-01	ASEA	ETF	16.13	16.16	16.08	16.08	1500.0
2011-04-01	BAB	ETF	25.18	25.36	25.18	25.3	323766.0
2011-04-01	BAL	ETF	101.99	103.16	100.82	101.32	84791.0
2011-04-01	BALT	ETF	9.2	9.2	9.1	9.17	81258.0
2011-04-01	BBH	ETF	35.5067	35.5067	35.2833	35.3367	54600.0
2011-04-01	BIB	ETF	8.6	8.6	8.6	8.6	3960.0
2011-04-01	BICK	ETF	33.76	34.21	33.76	34.1499	21210.0
2011-04-01	BIL	ETF	91.72	91.72	91.7	91.7	148850.0
2011-04-01	BITS	ETF	25.6	25.6	25.36	25.4	3460.0
2011-04-01	BIV	ETF	81.3	81.88	81.3	81.87	75900.0
2011-04-01	BJK	ETF	32.32	32.8	32.32	32.68	7300.0
2011-04-01	BKF	ETF	50.97	51.52	50.8	51.44	512171.0
2011-04-01	BKLN	ETF	25.11	25.11	25.05	25.1	83400.0
2011-04-01	BLV	ETF	77.88	78.36	77.66	78.36	12100.0
2011-04-01	BMVP	ETF	15.76	15.81	15.73	15.76	5224.0
2011-04-01	BND	ETF	79.69	79.93	79.66	79.89	953300.0
2011-04-01	BNO	ETF	38.96	39.485	38.77	39.43	446600.0
2011-04-01	BRF	ETF	57.53	58.36	56.89	58.27	296105.0
2011-04-01	BSCE	ETF	20.74	20.9	20.74	20.89	14101.0
2011-04-01	BSV	ETF	79.94	80.08	79.88	80.03	1099700.0
2011-04-01	BTF	ETF	83.9	84.0	83.64999999999999	83.8	1485.0
2011-04-01	BWX	ETF	29.83	29.985	29.655	29.905	374984.0
2011-04-01	BWZ	ETF	37.55	38.5599	37.53	38.47	73513.0

> showing 50 of 835 rows — these rows as CSV

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