PREVIEW / etf_daily / 2012-12-19

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-19.parquet
  size:    40 KB
  rows:    969

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-12-19	SPY	ETF	145.53	145.58	144.24	144.29	150895400.0
2012-12-19	QQQ	ETF	66.72	66.76	66.22	66.2605	34832444.0
2012-12-19	IWM	ETF	84.08	84.52	83.76	84.12	49010900.0
2012-12-19	DIA	ETF	133.67	133.7	132.6	132.62	5511500.0
2012-12-19	GLD	ETF	161.31	162.22	161.11	161.69	12991600.0
2012-12-19	TLT	ETF	120.97	121.65	120.72	120.91	4880500.0
2012-12-19	AADR	ETF	31.19	31.22	31.19	31.22	200.0
2012-12-19	AAXJ	ETF	59.64	59.65	59.36	59.37	484100.0
2012-12-19	ACTV	ETF	5.17	5.175	4.97	4.99	528311.0
2012-12-19	ACWI	ETF	48.29	48.32	47.91	47.94	3766200.0
2012-12-19	ACWV	ETF	56.12	56.66	56.11	56.15	22300.0
2012-12-19	ACWX	ETF	41.99	41.99	41.7	41.73	311247.0
2012-12-19	ADRE	ETF	40.12	40.34	40.1	40.2	39969.0
2012-12-19	AFK	ETF	31.65	31.84	31.61	31.7899	41584.0
2012-12-19	AGEM	ETF	23.43	23.47	23.3001	23.4599	2721.0
2012-12-19	AGG	ETF	110.92	111.1	110.92	111.01	1114000.0
2012-12-19	AGQ	ETF	186.72	189.84	185.16	186.24	398475.0
2012-12-19	AGZ	ETF	113.3	113.45	113.3	113.38	19639.0
2012-12-19	AIA	ETF	47.66	47.66	47.4105	47.46	27847.0
2012-12-19	AIQ	ETF	6.4	6.55	6.35	6.4	13064.0
2012-12-19	AIVI	ETF	42.28	42.35	42.01	42.01	32500.0
2012-12-19	AMJ	ETF	38.63	39.07	38.39	38.86	2984173.0
2012-12-19	AMLP	ETF	79.9	80.5	79.75	80.3	749980.0
2012-12-19	ANGL	ETF	27.15	27.19	27.09	27.09	23800.0
2012-12-19	AOA	ETF	37.68	37.68	37.48	37.48	44000.0
2012-12-19	AOK	ETF	30.68	30.71	30.64	30.641	23411.0
2012-12-19	AOM	ETF	31.991	32.05	31.95	31.98	13474.0
2012-12-19	AOR	ETF	34.28	34.32	34.2	34.21	38649.0
2012-12-19	ARB	ETF	47.0	47.05	46.43	46.52	4200791.0
2012-12-19	ARGT	ETF	17.84	17.84	17.48	17.64	6000.0
2012-12-19	ASEA	ETF	17.27	17.27	17.13	17.19	35300.0
2012-12-19	AWAY	ETF	21.31	21.67	21.0028	21.56	419688.0
2012-12-19	BAB	ETF	29.8	30.1	29.8	30.0	197758.0
2012-12-19	BAL	ETF	49.44	49.6299	49.398	49.55	7369.0
2012-12-19	BALT	ETF	3.14	3.14	3.0846	3.1	69971.0
2012-12-19	BBH	ETF	55.42	55.42	54.7	54.78	16700.0
2012-12-19	BIB	ETF	15.4025	15.5	14.832	14.9375	111488.0
2012-12-19	BICK	ETF	25.06	25.3	25.06	25.13	19118.0
2012-12-19	BIL	ETF	91.62	91.64	91.62	91.62	150550.0
2012-12-19	BIS	ETF	2583.604	2586.404	2570.4	2586.4	85.0
2012-12-19	BIV	ETF	89.7	89.82	89.61	89.75	240700.0
2012-12-19	BJK	ETF	37.02	37.03	36.91	36.98	6500.0
2012-12-19	BKF	ETF	40.23	40.32	40.07	40.12	61043.0
2012-12-19	BKLN	ETF	24.92	24.94	24.9	24.93	820600.0
2012-12-19	BLV	ETF	94.69	95.09	94.58	94.76	59400.0
2012-12-19	BMVP	ETF	16.5833	16.6167	16.54	16.5839	15744.0
2012-12-19	BND	ETF	84.26	84.44	84.26	84.38	2254500.0
2012-12-19	BNO	ETF	40.44	40.745	40.31	40.655	43200.0
2012-12-19	BOIL	ETF	780800.0	806000.0	773000.0	798200.0	8.8
2012-12-19	BOND	ETF	108.76	108.85	108.7	108.77	559289.0

> showing 50 of 969 rows — these rows as CSV

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