PREVIEW / etf_daily / 2012-12-18

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-18.parquet
  size:    40 KB
  rows:    966

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-18	SPY	ETF	144.0	145.5	143.79	145.37	177762800.0
2012-12-18	QQQ	ETF	65.85	66.65	65.7	66.5472	55595997.0
2012-12-18	IWM	ETF	83.71	84.77	83.49	84.66	53500700.0
2012-12-18	DIA	ETF	132.68	133.73	132.38	133.55	6459500.0
2012-12-18	GLD	ETF	164.35	164.43	160.9	162.08	23995000.0
2012-12-18	TLT	ETF	121.4	121.78	119.9	120.51	12024200.0
2012-12-18	AADR	ETF	31.05	31.15	31.05	31.06	900.0
2012-12-18	AAXJ	ETF	59.27	59.58	58.96	59.53	679800.0
2012-12-18	ACTV	ETF	5.0	5.265	4.99	5.09	784297.0
2012-12-18	ACWI	ETF	47.78	48.17	47.67	48.12	943600.0
2012-12-18	ACWV	ETF	56.21	56.4	56.06	56.4	20200.0
2012-12-18	ACWX	ETF	41.44	41.67	41.2768	41.61	597741.0
2012-12-18	ADRE	ETF	39.59	40.0	39.59	40.0	36507.0
2012-12-18	AFK	ETF	31.45	31.6	31.4	31.51	33738.0
2012-12-18	AGEM	ETF	23.16	23.41	22.9175	23.41	10425.0
2012-12-18	AGG	ETF	111.0	111.07	110.74	110.82	1411500.0
2012-12-18	AGQ	ETF	201.76	202.16	189.12	192.84	494600.0
2012-12-18	AGZ	ETF	113.45	113.472	113.35	113.38	11898.0
2012-12-18	AIA	ETF	47.28	47.64	47.26	47.64	41874.0
2012-12-18	AIQ	ETF	6.25	6.45	6.25	6.35	9784.0
2012-12-18	AIVI	ETF	41.8	42.07	41.7	42.07	180500.0
2012-12-18	AMJ	ETF	38.1	38.75	37.82	38.43	3194512.0
2012-12-18	AMLP	ETF	79.0	80.05	78.75	79.65	955120.0
2012-12-18	ANGL	ETF	27.15	27.15	27.1	27.11	38300.0
2012-12-18	AOA	ETF	37.32	37.59	37.32	37.58	27900.0
2012-12-18	AOK	ETF	30.63	30.68	30.56	30.65	19098.0
2012-12-18	AOM	ETF	31.9	32.06	31.85	32.06	76198.0
2012-12-18	AOR	ETF	34.1	34.27	34.07	34.27	82095.0
2012-12-18	ARB	ETF	47.16	47.2	46.82	47.03	15276750.0
2012-12-18	ARGT	ETF	17.52	17.76	17.52	17.74	3600.0
2012-12-18	ASEA	ETF	17.16	17.25	17.12	17.25	26800.0
2012-12-18	AWAY	ETF	21.14	21.56	20.93	21.22	669160.0
2012-12-18	BAB	ETF	30.63	30.63	29.7054	29.89	726011.0
2012-12-18	BAL	ETF	49.2901	49.65	49.2901	49.65	8368.0
2012-12-18	BALT	ETF	3.07	3.15	3.04	3.15	64037.0
2012-12-18	BBH	ETF	55.41	55.41	54.69	55.26	69100.0
2012-12-18	BCM	ETF	44.2	44.2	44.0764	44.12	2600.0
2012-12-18	BIB	ETF	15.155	15.3223	14.9475	15.2175	91344.0
2012-12-18	BICK	ETF	24.77	24.97	24.77	24.97	7018.0
2012-12-18	BIL	ETF	91.62	91.64	91.62	91.64	254200.0
2012-12-18	BIS	ETF	2543.2	2546.4	2524.4	2525.2	406.5
2012-12-18	BIV	ETF	89.78	89.78	89.43	89.57	279700.0
2012-12-18	BJK	ETF	36.58	36.83	36.58	36.83	6700.0
2012-12-18	BKF	ETF	39.6	40.07	39.5795	40.05	88255.0
2012-12-18	BKLN	ETF	24.88	24.94	24.88	24.94	697500.0
2012-12-18	BLV	ETF	95.0	95.08	94.24	94.48	77200.0
2012-12-18	BMVP	ETF	16.36	16.51	16.34	16.51	4991.0
2012-12-18	BND	ETF	84.32	84.38	84.19	84.2	1772600.0
2012-12-18	BNO	ETF	39.84	40.195	39.84	40.195	50000.0
2012-12-18	BOIL	ETF	826600.0	847800.0	813600.0	821200.0	9.0

> showing 50 of 966 rows — these rows as CSV

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