PREVIEW / etf_daily / 2012-12-12

all etf daily files

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

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-12	SPY	ETF	144.0	144.55	143.31	143.51	145880100.0
2012-12-12	QQQ	ETF	66.29	66.32	65.65	65.83	45917674.0
2012-12-12	IWM	ETF	83.67	83.8	82.77	82.94	40570000.0
2012-12-12	DIA	ETF	132.98	133.34	132.33	132.51	9551800.0
2012-12-12	GLD	ETF	166.2	166.94	165.36	165.77	14164700.0
2012-12-12	TLT	ETF	123.83	124.34	122.57	122.59	7119700.0
2012-12-12	AADR	ETF	30.95	30.99	30.95	30.99	1100.0
2012-12-12	AAXJ	ETF	59.92	60.11	59.67	59.78	273100.0
2012-12-12	ACTV	ETF	4.95	5.32	4.81	5.09	2104675.0
2012-12-12	ACWI	ETF	48.01	48.31	47.97	48.02	754700.0
2012-12-12	ACWV	ETF	57.25	57.38	56.94	57.12	19200.0
2012-12-12	ACWX	ETF	41.5	41.719	41.41	41.5	124807.0
2012-12-12	ADRE	ETF	39.53	39.71	39.42	39.51	21757.0
2012-12-12	AFK	ETF	31.02	31.3935	31.02	31.22	17977.0
2012-12-12	AGEM	ETF	23.71	23.71	23.0332	23.13	6955.0
2012-12-12	AGG	ETF	111.59	111.66	111.33	111.33	1448600.0
2012-12-12	AGQ	ETF	212.8	220.0	210.24	215.28	477500.0
2012-12-12	AGZ	ETF	113.64	113.86	113.57	113.7	12561.0
2012-12-12	AIA	ETF	47.71	47.95	47.65	47.7	76555.0
2012-12-12	AIQ	ETF	6.415	6.95	6.1	6.1	6343.0
2012-12-12	AIVI	ETF	41.4	41.62	41.31	41.35	17100.0
2012-12-12	ALTL	ETF	25.98	25.98	25.95	25.95	370.0
2012-12-12	AMJ	ETF	38.79	38.79	38.15	38.26	1488419.0
2012-12-12	AMLP	ETF	80.05	80.15	79.15	79.35	526200.0
2012-12-12	ANGL	ETF	27.49	27.49	27.2	27.25	4500.0
2012-12-12	AOA	ETF	37.27	37.4	37.16	37.16	20900.0
2012-12-12	AOK	ETF	30.7	30.71	30.6201	30.64	6889.0
2012-12-12	AOM	ETF	31.95	31.95	31.85	31.87	14114.0
2012-12-12	AOR	ETF	34.0506	34.1799	34.03	34.03	14526.0
2012-12-12	ARB	ETF	38.31	38.45	37.72	37.82	96277.0
2012-12-12	ARGT	ETF	17.0	17.42	17.0	17.24	8200.0
2012-12-12	ASEA	ETF	17.06	17.12	17.04	17.06	49400.0
2012-12-12	AWAY	ETF	20.47	20.6	20.09	20.54	550750.0
2012-12-12	BAB	ETF	30.5	30.56	30.35	30.4	245769.0
2012-12-12	BAL	ETF	48.82	49.19	48.7985	49.05	15021.0
2012-12-12	BALT	ETF	2.77	2.94	2.77	2.9	113407.0
2012-12-12	BBH	ETF	55.93	55.93	55.4	55.4	28500.0
2012-12-12	BCM	ETF	44.62	44.64	44.5537	44.639	4598.0
2012-12-12	BIB	ETF	15.5625	15.5625	15.18	15.25	102932.0
2012-12-12	BICK	ETF	24.69	24.75	24.68	24.75	3426.0
2012-12-12	BIL	ETF	91.62	91.64	91.62	91.62	269950.0
2012-12-12	BIS	ETF	2513.6	2547.6	2512.0	2547.6	23.4
2012-12-12	BIV	ETF	90.31	90.35	90.08	90.12	614400.0
2012-12-12	BJK	ETF	35.98	36.31	35.98	36.18	10400.0
2012-12-12	BKF	ETF	39.93	40.1099	39.73	39.82	115327.0
2012-12-12	BKLN	ETF	24.94	24.94	24.9	24.93	696000.0
2012-12-12	BLV	ETF	96.3	96.65	95.72	95.72	42600.0
2012-12-12	BMVP	ETF	16.3633	16.4473	16.32	16.32	13198.0
2012-12-12	BND	ETF	84.8	84.82	84.61	84.66	1105800.0
2012-12-12	BNO	ETF	39.985	40.105	39.66	39.865	211200.0

> showing 50 of 958 rows — these rows as CSV

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