PREVIEW / etf_daily / 2012-01-10

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-10.parquet
  size:    37 KB
  rows:    896

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-10	SPY	ETF	129.39	129.65	128.95	129.13	115282000.0
2012-01-10	QQQ	ETF	58.26	58.405	57.6398	58.04	35949856.0
2012-01-10	IWM	ETF	76.16	76.43	75.96	76.27	42977600.0
2012-01-10	DIA	ETF	124.88	125.0	124.27	124.38	5274400.0
2012-01-10	GLD	ETF	158.97	159.47	158.47	158.64	8371400.0
2012-01-10	TLT	ETF	117.73	118.87	117.68	118.32	8932500.0
2012-01-10	AADR	ETF	28.03	28.4	28.03	28.4	300.0
2012-01-10	AAXJ	ETF	51.79	52.03	51.61	51.88	327900.0
2012-01-10	ACTV	ETF	13.52	13.7	13.4	13.57	516603.0
2012-01-10	ACWI	ETF	43.25	43.29	43.0	43.0	716000.0
2012-01-10	ACWV	ETF	51.63	51.65	51.63	51.65	200.0
2012-01-10	ACWX	ETF	37.49	37.63	37.37	37.4	350463.0
2012-01-10	ADRE	ETF	40.13	40.37	40.13	40.15	57165.0
2012-01-10	AFK	ETF	26.19	26.47	26.12	26.42	31471.0
2012-01-10	AGEM	ETF	21.75	21.943	21.75	21.943	658.0
2012-01-10	AGG	ETF	110.03	110.17	109.94	110.0	1002100.0
2012-01-10	AGQ	ETF	195.76	197.64	192.64	193.44	424000.0
2012-01-10	AGZ	ETF	112.93	112.93	112.59	112.71	26204.0
2012-01-10	AIA	ETF	40.46	40.6	40.389	40.455	16323.0
2012-01-10	AIQ	ETF	5.75	5.85	5.6	5.75	8658.0
2012-01-10	AIS	ETF	2.17	2.3	2.17	2.25	1264500.0
2012-01-10	AIVI	ETF	39.83	39.89	39.73	39.82	60000.0
2012-01-10	AMJ	ETF	39.23	39.6	38.77	38.99	2431947.0
2012-01-10	AMLP	ETF	83.5	83.5	82.5	82.9	540960.0
2012-01-10	AOA	ETF	33.82	33.91	33.78	33.78	10500.0
2012-01-10	AOK	ETF	29.47	29.52	29.44	29.44	57766.0
2012-01-10	AOM	ETF	30.17	30.17	30.1044	30.11	28975.0
2012-01-10	AOR	ETF	31.57	31.644	31.54	31.59	94735.0
2012-01-10	ARB	ETF	35.72	36.31	35.635	36.02	198035.0
2012-01-10	ARGT	ETF	22.64	22.64	22.54	22.54	200.0
2012-01-10	ASEA	ETF	14.89	14.89	14.82	14.82	2400.0
2012-01-10	AWAY	ETF	23.34	23.99	23.25	23.55	212162.0
2012-01-10	BAB	ETF	28.49	28.66	28.49	28.6	119828.0
2012-01-10	BAL	ETF	59.7496	60.11	59.47	59.93	37906.0
2012-01-10	BALT	ETF	4.4	4.5	4.3506	4.5	72940.0
2012-01-10	BBH	ETF	38.9433	39.2367	38.8067	39.2067	38400.0
2012-01-10	BCM	ETF	44.5336	44.5336	44.38	44.38	531.0
2012-01-10	BIB	ETF	9.6687	9.7625	9.5476	9.7495	82240.0
2012-01-10	BICK	ETF	24.12	24.24	24.08	24.15	13854.0
2012-01-10	BIL	ETF	91.64	91.66	91.64	91.66	352250.0
2012-01-10	BIS	ETF	4764.8	4764.8	4659.2	4662.4	14.5
2012-01-10	BITS	ETF	22.64	22.8	22.4	22.44	1821.0
2012-01-10	BIV	ETF	86.96	87.05	86.73	86.95	216700.0
2012-01-10	BJK	ETF	30.58	30.75	30.5	30.63	12500.0
2012-01-10	BKF	ETF	38.5	38.58	38.25	38.28	289436.0
2012-01-10	BKLN	ETF	24.1	24.19	24.1	24.18	149700.0
2012-01-10	BLV	ETF	90.68	91.29	90.62	91.11	24900.0
2012-01-10	BMVP	ETF	13.95	14.0	13.94	13.94	12755.0
2012-01-10	BND	ETF	83.42	83.5	83.34	83.37	964100.0
2012-01-10	BNO	ETF	39.405	39.43	39.17	39.34	49400.0

> showing 50 of 896 rows — these rows as CSV

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