PREVIEW / etf_daily / 2012-03-01

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-01.parquet
  size:    38 KB
  rows:    926

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-03-01	SPY	ETF	137.31	137.99	136.93	137.73	145023500.0
2012-03-01	QQQ	ETF	64.66	64.98	64.46	64.92	67558813.0
2012-03-01	IWM	ETF	81.38	82.37	81.36	81.47	69526300.0
2012-03-01	DIA	ETF	129.6	130.16	129.23	129.57	6684300.0
2012-03-01	GLD	ETF	166.1	167.72	165.75	166.61	19200700.0
2012-03-01	TLT	ETF	116.17	116.68	115.54	116.06	12265600.0
2012-03-01	AADR	ETF	30.67	30.68	30.67	30.68	800.0
2012-03-01	AAXJ	ETF	58.08	58.61	58.08	58.44	339300.0
2012-03-01	ACTV	ETF	16.01	16.04	15.88	16.0	564488.0
2012-03-01	ACWI	ETF	46.84	47.1	46.83	47.03	810200.0
2012-03-01	ACWV	ETF	54.15	54.15	53.76	53.8	400.0
2012-03-01	ACWX	ETF	41.27	41.544	41.24	41.5	251748.0
2012-03-01	ADRE	ETF	43.93	44.344	43.882	44.28	57208.0
2012-03-01	AFK	ETF	30.42	30.49	30.23	30.45	12554.0
2012-03-01	AGEM	ETF	24.4331	24.4331	24.32	24.321	862.0
2012-03-01	AGG	ETF	110.23	110.31	110.08	110.26	1242600.0
2012-03-01	AGQ	ETF	254.44	267.72	253.68	264.96	894675.0
2012-03-01	AGZ	ETF	112.83	112.83	112.41	112.69	16408.0
2012-03-01	AIA	ETF	45.65	45.9347	45.55	45.85	41131.0
2012-03-01	AIQ	ETF	6.9	7.2	6.45	6.5	8667.0
2012-03-01	AIS	ETF	2.61	2.61	2.538	2.59	766558.0
2012-03-01	AIVI	ETF	42.39	42.66	42.35	42.54	39000.0
2012-03-01	AMJ	ETF	40.91	41.16	40.78	41.16	1606816.0
2012-03-01	AMLP	ETF	85.3	85.6	85.25	85.6	319960.0
2012-03-01	AOA	ETF	36.05	36.24	36.04	36.1	20000.0
2012-03-01	AOK	ETF	30.15	30.18	30.13	30.18	35047.0
2012-03-01	AOM	ETF	31.16	31.22	31.15	31.22	11459.0
2012-03-01	AOR	ETF	33.1	33.199	33.0812	33.17	36743.0
2012-03-01	ARB	ETF	33.65	34.59	33.5	34.1	174375.0
2012-03-01	ARGT	ETF	22.96	23.14	22.96	23.14	450.0
2012-03-01	ASEA	ETF	16.16	16.17	16.05	16.05	3600.0
2012-03-01	AWAY	ETF	26.45	26.8	26.08	26.74	487265.0
2012-03-01	BAB	ETF	29.25	29.32	29.11	29.23	325562.0
2012-03-01	BAL	ETF	54.61	55.17	54.439	54.81	12703.0
2012-03-01	BALT	ETF	4.59	4.64	4.31	4.39	192998.0
2012-03-01	BBH	ETF	42.25	42.64	42.07	42.54	12300.0
2012-03-01	BCM	ETF	46.58	47.1799	46.58	47.1799	11280.0
2012-03-01	BIB	ETF	11.2363	11.457	11.2363	11.428	12304.0
2012-03-01	BICK	ETF	27.77	27.97	27.77	27.88	12828.0
2012-03-01	BIL	ETF	91.64	91.64	91.62	91.64	218300.0
2012-03-01	BIS	ETF	3964.8	3964.8	3860.8	3872.0	24.7
2012-03-01	BITS	ETF	21.72	21.96	20.9604	21.64	750.0
2012-03-01	BIV	ETF	87.47	87.69	87.44	87.62	291100.0
2012-03-01	BJK	ETF	34.73	34.88	34.65	34.78	13100.0
2012-03-01	BKF	ETF	43.94	44.33	43.83	44.27	926253.0
2012-03-01	BKLN	ETF	24.48	24.55	24.45	24.5	115000.0
2012-03-01	BLV	ETF	90.87	91.13	90.47	90.9	68000.0
2012-03-01	BMVP	ETF	15.18	15.3	15.18	15.26	5492.0
2012-03-01	BND	ETF	83.49	83.64	83.46	83.57	1559000.0
2012-03-01	BNO	ETF	43.06	44.775	43.005	44.29	158000.0

> showing 50 of 926 rows — these rows as CSV

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