PREVIEW / etf_daily / 2012-01-26

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-26.parquet
  size:    38 KB
  rows:    905

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-26	SPY	ETF	133.15	133.4	131.36	131.88	184880500.0
2012-01-26	QQQ	ETF	60.67	60.8	59.93	60.22	37852655.0
2012-01-26	IWM	ETF	79.86	79.91	78.75	79.18	52755700.0
2012-01-26	DIA	ETF	127.85	128.13	126.65	127.06	5902300.0
2012-01-26	GLD	ETF	168.05	168.31	167.05	167.27	19143800.0
2012-01-26	TLT	ETF	116.65	117.71	116.59	117.71	7638500.0
2012-01-26	AADR	ETF	29.46	29.46	29.19	29.39	32700.0
2012-01-26	AAXJ	ETF	55.79	56.01	55.19	55.38	890700.0
2012-01-26	ACTV	ETF	14.55	14.6	14.47	14.58	70035.0
2012-01-26	ACWI	ETF	44.99	45.16	44.52	44.7	463400.0
2012-01-26	ACWV	ETF	52.62	52.83	52.39	52.39	2100.0
2012-01-26	ACWX	ETF	39.49	39.514	39.07	39.15	419761.0
2012-01-26	ADRE	ETF	43.0	43.212	42.3786	42.516	57978.0
2012-01-26	AFK	ETF	28.12	28.37	27.86	27.99	22844.0
2012-01-26	AGEM	ETF	23.33	23.33	23.22	23.22	4673.0
2012-01-26	AGG	ETF	110.39	110.5	110.33	110.36	1231700.0
2012-01-26	AGQ	ETF	244.68	244.76	237.04	238.4	688850.0
2012-01-26	AGZ	ETF	113.33	113.33	113.08	113.28	28924.0
2012-01-26	AIA	ETF	43.57	43.759	43.24	43.31	173517.0
2012-01-26	AIQ	ETF	5.9	5.9	5.7	5.7	4548.0
2012-01-26	AIS	ETF	2.48	2.48	2.36	2.41	887017.0
2012-01-26	AIVI	ETF	41.03	41.03	40.55	40.7	200900.0
2012-01-26	AMJ	ETF	40.32	40.33	40.0	40.07	928187.0
2012-01-26	AMLP	ETF	84.55	84.85	84.25	84.4	353720.0
2012-01-26	AOA	ETF	35.12	35.12	34.64	34.76	16000.0
2012-01-26	AOK	ETF	29.77	29.8493	29.698	29.77	105915.0
2012-01-26	AOM	ETF	30.6	30.67	30.5	30.56	137768.0
2012-01-26	AOR	ETF	32.36	32.36	32.11	32.21	8885.0
2012-01-26	ARB	ETF	37.04	37.21	36.48	36.59	149575.0
2012-01-26	ARGT	ETF	24.16	24.16	24.16	24.16	200.0
2012-01-26	ASEA	ETF	15.75	15.82	15.52	15.6	24000.0
2012-01-26	AWAY	ETF	26.57	28.0	26.18	27.19	341429.0
2012-01-26	BAB	ETF	28.76	28.769	28.6	28.71	180585.0
2012-01-26	BAL	ETF	60.13	60.22	58.99	59.07	25062.0
2012-01-26	BALT	ETF	4.28	4.28	4.04	4.09	173654.0
2012-01-26	BBH	ETF	42.6667	42.97	41.48	41.5733	18600.0
2012-01-26	BCM	ETF	45.55	45.55	45.369	45.369	3224.0
2012-01-26	BIB	ETF	10.6825	10.6825	10.3663	10.3684	64752.0
2012-01-26	BICK	ETF	26.86	26.983	26.5736	26.5935	21225.0
2012-01-26	BIL	ETF	91.66	91.66	91.64	91.64	182200.0
2012-01-26	BIS	ETF	4283.2	4342.4	4195.2	4320.0	51.5
2012-01-26	BITS	ETF	22.2	22.68	22.2	22.68	900.0
2012-01-26	BIV	ETF	87.51	87.69	87.38	87.65	240900.0
2012-01-26	BJK	ETF	33.23	33.51	32.82	32.98	19500.0
2012-01-26	BKF	ETF	41.79	41.943	41.1529	41.37	186962.0
2012-01-26	BKLN	ETF	24.4	24.4	24.22	24.23	109300.0
2012-01-26	BLV	ETF	90.5	91.08	90.48	91.08	74900.0
2012-01-26	BMVP	ETF	14.58	14.58	14.3	14.3	4599.0
2012-01-26	BND	ETF	83.67	83.77	83.59	83.75	2096700.0
2012-01-26	BNO	ETF	38.805	38.895	38.475	38.635	27000.0

> showing 50 of 905 rows — these rows as CSV

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