PREVIEW / etf_daily / 2012-12-26

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-26.parquet
  size:    39 KB
  rows:    953

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-26	SPY	ETF	142.64	142.71	141.35	141.75	106947700.0
2012-12-26	QQQ	ETF	65.08	65.18	64.29	64.5	21760846.0
2012-12-26	IWM	ETF	83.97	84.01	83.08	83.18	24671600.0
2012-12-26	DIA	ETF	131.29	131.48	130.47	130.81	3982900.0
2012-12-26	GLD	ETF	161.36	161.49	160.64	160.78	4961800.0
2012-12-26	TLT	ETF	121.95	122.21	121.81	122.2	2247800.0
2012-12-26	AADR	ETF	30.86	30.97	30.79	30.79	2600.0
2012-12-26	AAXJ	ETF	59.43	59.48	59.14	59.15	481100.0
2012-12-26	ACTV	ETF	4.69	4.8105	4.63	4.78	1047890.0
2012-12-26	ACWI	ETF	47.94	47.95	47.57	47.66	794600.0
2012-12-26	ACWV	ETF	55.44	55.89	55.44	55.66	12700.0
2012-12-26	ACWX	ETF	41.76	41.77	41.4355	41.57	237646.0
2012-12-26	ADRE	ETF	39.5	39.92	39.5	39.671	47648.0
2012-12-26	AFK	ETF	30.77	30.85	30.43	30.46	13273.0
2012-12-26	AGEM	ETF	23.05	23.18	22.8437	23.08	1932.0
2012-12-26	AGG	ETF	110.96	111.07	110.96	111.05	575800.0
2012-12-26	AGQ	ETF	174.32	175.12	170.8	172.24	253200.0
2012-12-26	AGZ	ETF	113.37	113.4	113.32	113.4	11188.0
2012-12-26	AIA	ETF	47.23	47.29	47.0801	47.16	5942.0
2012-12-26	AIQ	ETF	7.4	7.4	6.2	6.5	30853.0
2012-12-26	AIVI	ETF	41.78	41.78	41.38	41.58	8400.0
2012-12-26	AMJ	ETF	38.6	38.63	38.01	38.05	952557.0
2012-12-26	AMLP	ETF	80.05	80.1	79.2	79.4	445940.0
2012-12-26	ANGL	ETF	27.01	27.05	26.95	27.05	3100.0
2012-12-26	AOA	ETF	38.0	38.0	36.92	36.98	38900.0
2012-12-26	AOK	ETF	30.75	30.75	30.58	30.6	11496.0
2012-12-26	AOM	ETF	31.77	31.77	31.5701	31.6	58244.0
2012-12-26	AOR	ETF	34.34	34.35	33.7	33.75	69036.0
2012-12-26	ARB	ETF	46.4	46.62	46.3802	46.58	800289.0
2012-12-26	ARGT	ETF	17.3	17.58	17.24	17.24	650.0
2012-12-26	ASEA	ETF	17.25	17.26	17.07	17.14	93700.0
2012-12-26	AWAY	ETF	21.74	22.3	21.39	21.44	334479.0
2012-12-26	BAB	ETF	30.26	30.38	30.23	30.33	123868.0
2012-12-26	BAL	ETF	49.88	50.3199	49.88	50.28	13815.0
2012-12-26	BALT	ETF	3.12	3.122	2.94	3.03	26970.0
2012-12-26	BBH	ETF	54.03	54.03	53.15	53.37	20200.0
2012-12-26	BCM	ETF	43.9	43.9	43.8099	43.89	2000.0
2012-12-26	BIB	ETF	14.71	14.71	14.25	14.5	59000.0
2012-12-26	BICK	ETF	24.81	25.04	24.78	24.95	20871.0
2012-12-26	BIL	ETF	91.62	91.64	91.62	91.62	85000.0
2012-12-26	BIS	ETF	2687.196	2688.4	2644.396	2678.0	295.0
2012-12-26	BIV	ETF	88.19	88.26	88.12	88.24	308700.0
2012-12-26	BJK	ETF	35.27	35.4	35.17	35.37	5500.0
2012-12-26	BKF	ETF	40.24	40.4899	40.23	40.25	79119.0
2012-12-26	BKLN	ETF	24.93	24.96	24.9	24.92	232300.0
2012-12-26	BLV	ETF	93.33	93.99	93.33	93.88	39500.0
2012-12-26	BMVP	ETF	16.24	16.27	16.13	16.16	2372.0
2012-12-26	BND	ETF	83.95	84.05	83.95	84.02	1009700.0
2012-12-26	BNO	ETF	40.75	41.075	40.735	41.06	91600.0
2012-12-26	BOIL	ETF	810000.0	823200.0	806000.0	806000.0	5.4

> showing 50 of 953 rows — these rows as CSV

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