PREVIEW / etf_daily / 2012-04-12

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-12.parquet
  size:    38 KB
  rows:    923

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-04-12	SPY	ETF	137.13	138.9	137.03	138.79	154321500.0
2012-04-12	QQQ	ETF	66.58	67.28	66.4807	67.205	57407345.0
2012-04-12	IWM	ETF	79.54	80.91	79.44	80.6	60728700.0
2012-04-12	DIA	ETF	128.12	129.79	128.04	129.72	7164600.0
2012-04-12	GLD	ETF	160.74	163.2	160.46	162.7	9229900.0
2012-04-12	TLT	ETF	115.67	115.75	114.82	114.98	9008500.0
2012-04-12	AAXJ	ETF	55.72	56.71	55.69	56.7	234100.0
2012-04-12	ACTV	ETF	16.42	16.6485	16.0	16.52	177078.0
2012-04-12	ACWI	ETF	45.79	46.4	45.76	46.38	534400.0
2012-04-12	ACWV	ETF	53.6	53.88	53.6	53.88	3900.0
2012-04-12	ACWX	ETF	39.41	40.05	39.41	40.03	94475.0
2012-04-12	ADRE	ETF	40.98	41.8501	40.98	41.84	30468.0
2012-04-12	AFK	ETF	28.43	28.95	28.43	28.76	2519.0
2012-04-12	AGEM	ETF	22.65	23.0788	22.65	23.0788	1442.0
2012-04-12	AGG	ETF	110.1	110.14	110.0	110.02	505900.0
2012-04-12	AGQ	ETF	208.0	220.56	207.76	217.4	501575.0
2012-04-12	AGZ	ETF	112.8	112.8	112.42	112.49	5786.0
2012-04-12	AIA	ETF	44.28	44.678	44.28	44.62	13777.0
2012-04-12	AIQ	ETF	7.4	7.55	7.35	7.5	21353.0
2012-04-12	AIS	ETF	3.05	3.15	3.01	3.13	551622.0
2012-04-12	AIVI	ETF	39.87	40.41	39.87	40.37	31500.0
2012-04-12	AMJ	ETF	38.24	38.75	38.24	38.7	2137768.0
2012-04-12	AMLP	ETF	81.8	82.45	81.8	82.3	372920.0
2012-04-12	ANGL	ETF	25.15	25.3	25.14	25.3	12500.0
2012-04-12	AOA	ETF	35.54	35.96	35.54	35.96	13000.0
2012-04-12	AOK	ETF	29.93	30.04	29.93	30.03	37708.0
2012-04-12	AOM	ETF	30.93	31.05	30.93	31.04	18868.0
2012-04-12	AOR	ETF	32.72	33.05	32.72	33.0499	30626.0
2012-04-12	ARB	ETF	37.29	37.41	36.9	37.32	293961.0
2012-04-12	ARGT	ETF	19.98	20.12	19.98	20.1	350.0
2012-04-12	ASEA	ETF	15.93	16.24	15.93	16.23	5500.0
2012-04-12	AWAY	ETF	23.62	24.72	23.62	24.47	259786.0
2012-04-12	BAB	ETF	29.44	29.45	29.35	29.38	107536.0
2012-04-12	BAL	ETF	55.37	56.099	55.32	55.93	25685.0
2012-04-12	BALT	ETF	4.04	4.25	3.98	4.22	150656.0
2012-04-12	BBH	ETF	43.23	43.28	43.16	43.16	10600.0
2012-04-12	BIB	ETF	11.23	11.3413	11.23	11.3075	29072.0
2012-04-12	BICK	ETF	25.55	26.081	25.55	26.04	14880.0
2012-04-12	BIL	ETF	91.66	91.66	91.64	91.64	1015400.0
2012-04-12	BIS	ETF	3867.2	3876.16	3835.2	3836.64	5.3
2012-04-12	BIV	ETF	87.5	87.5	87.24	87.32	457900.0
2012-04-12	BJK	ETF	36.18	36.61	36.16	36.45	7200.0
2012-04-12	BKF	ETF	40.25	41.12	40.202	41.04	101936.0
2012-04-12	BKLN	ETF	24.5	24.54	24.5	24.54	127200.0
2012-04-12	BLV	ETF	90.21	90.27	89.77	89.86	60800.0
2012-04-12	BMVP	ETF	15.1867	15.3808	15.1867	15.37	4115.0
2012-04-12	BND	ETF	83.52	83.56	83.44	83.5	876200.0
2012-04-12	BNO	ETF	42.16	42.905	42.155	42.88	57000.0
2012-04-12	BOIL	ETF	654000.0	713000.0	645000.0	651000.0	14.8
2012-04-12	BOND	ETF	102.63	102.63	102.4558	102.4558	217218.0

> showing 50 of 923 rows — these rows as CSV

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