PREVIEW / etf_daily / 2011-07-12

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-12.parquet
  size:    36 KB
  rows:    863

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
2011-07-12	SPY	ETF	131.69	132.78	131.36	131.4	214675700.0
2011-07-12	QQQ	ETF	57.94	58.07	57.46	57.52	84000656.0
2011-07-12	IWM	ETF	82.88	83.77	82.78	82.85	65322100.0
2011-07-12	DIA	ETF	124.86	125.54	124.31	124.33	12501300.0
2011-07-12	GLD	ETF	151.24	153.32	150.77	152.77	24033700.0
2011-07-12	TLT	ETF	97.3	97.31	96.56	97.13	9083900.0
2011-07-12	AADR	ETF	30.92	30.92	30.92	30.92	200.0
2011-07-12	AAXJ	ETF	60.96	61.32	60.75	60.77	290200.0
2011-07-12	ACTV	ETF	18.63	18.94	18.45	18.58	87592.0
2011-07-12	ACWI	ETF	47.12	47.62	47.09	47.11	564900.0
2011-07-12	ACWX	ETF	43.42	43.774	43.3	43.35	39656.0
2011-07-12	ADRE	ETF	45.15	45.45	45.06	45.07	37180.0
2011-07-12	AFK	ETF	31.02	31.25	30.98	31.05	20468.0
2011-07-12	AGEM	ETF	25.49	25.52	25.45	25.47	2000.0
2011-07-12	AGG	ETF	107.51	107.61	107.33	107.5	681500.0
2011-07-12	AGQ	ETF	338.62	360.9	336.38	355.36	810000.0
2011-07-12	AGZ	ETF	110.89	111.009	110.8	110.9	12627.0
2011-07-12	AIA	ETF	45.77	45.9	45.54	45.55	30168.0
2011-07-12	AIQ	ETF	18.35	18.55	17.9	18.25	84131.0
2011-07-12	AIS	ETF	2.4	2.44	2.37	2.39	862884.0
2011-07-12	AIVI	ETF	44.55	44.82	44.36	44.4	11800.0
2011-07-12	AMJ	ETF	37.09	37.25	37.0	37.14	534132.0
2011-07-12	AMLP	ETF	80.15	80.25	80.0	80.15	95420.0
2011-07-12	AOA	ETF	35.65	35.88	35.65	35.67	13400.0
2011-07-12	AOK	ETF	29.42	29.42	29.36	29.36	26856.0
2011-07-12	AOM	ETF	30.59	30.64	30.55	30.5799	30748.0
2011-07-12	AOR	ETF	32.47	32.57	32.45	32.45	20042.0
2011-07-12	ARB	ETF	40.67	41.12	40.65	40.75	92773.0
2011-07-12	ARGT	ETF	29.58	29.64	29.58	29.64	100.0
2011-07-12	ASEA	ETF	16.61	16.75	16.61	16.64	48700.0
2011-07-12	AWAY	ETF	41.83	43.0	40.856	41.5	126034.0
2011-07-12	BAB	ETF	26.65	26.7	26.51	26.7	176548.0
2011-07-12	BAL	ETF	64.83	65.52	64.29	64.99	119238.0
2011-07-12	BALT	ETF	5.26	5.29	5.2	5.2	157547.0
2011-07-12	BBH	ETF	35.2567	35.44	35.1867	35.1867	21300.0
2011-07-12	BCM	ETF	46.99	46.99	46.99	46.99	200.0
2011-07-12	BIB	ETF	9.7925	9.92	9.6575	9.7587	149728.0
2011-07-12	BICK	ETF	31.3	31.33	31.03	31.1	21977.0
2011-07-12	BIL	ETF	91.72	91.72	91.7	91.7	1150000.0
2011-07-12	BIS	ETF	5966.4	5966.4	5775.36	5872.0	25.35
2011-07-12	BITS	ETF	21.24	21.36	21.2	21.36	356.0
2011-07-12	BIV	ETF	85.05	85.18	84.91	85.09	99800.0
2011-07-12	BJK	ETF	34.67	35.08	34.67	34.75	65700.0
2011-07-12	BKF	ETF	46.19	46.65	46.08	46.09	108116.0
2011-07-12	BKLN	ETF	24.78	24.85	24.78	24.84	34700.0
2011-07-12	BLNG	ETF	48.79	49.5301	48.79	49.5301	2200.0
2011-07-12	BLV	ETF	82.01	82.05	81.54	81.84	81000.0
2011-07-12	BMVP	ETF	15.7333	15.8374	15.67	15.6833	38339.0
2011-07-12	BND	ETF	81.89	81.92	81.7	81.87	882600.0
2011-07-12	BNO	ETF	38.565	39.12	38.485	38.89	133200.0

> showing 50 of 863 rows — these rows as CSV

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