PREVIEW / etf_daily / 2011-07-19

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-19.parquet
  size:    36 KB
  rows:    864

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-19	SPY	ETF	131.34	132.89	131.31	132.73	166554900.0
2011-07-19	QQQ	ETF	58.13	58.9	58.09	58.85	73904275.0
2011-07-19	IWM	ETF	82.23	83.41	82.18	83.32	56060800.0
2011-07-19	DIA	ETF	124.4	125.82	124.32	125.63	5848000.0
2011-07-19	GLD	ETF	156.32	156.32	154.1	154.66	22871500.0
2011-07-19	TLT	ETF	95.32	97.27	95.17	97.22	15249400.0
2011-07-19	AADR	ETF	30.29	30.8	30.29	30.8	2800.0
2011-07-19	AAXJ	ETF	61.27	61.7	61.25	61.6	231900.0
2011-07-19	ACTV	ETF	18.45	18.59	18.27	18.58	100114.0
2011-07-19	ACWI	ETF	47.2	47.72	47.2	47.69	442000.0
2011-07-19	ACWX	ETF	43.46	43.74	43.4	43.69	196142.0
2011-07-19	ADRE	ETF	45.31	45.546	45.18	45.51	19448.0
2011-07-19	AFK	ETF	31.47	31.7475	31.3901	31.66	7267.0
2011-07-19	AGEM	ETF	25.51	25.774	25.51	25.68	1002.0
2011-07-19	AGG	ETF	107.37	107.66	107.33	107.66	780100.0
2011-07-19	AGQ	ETF	441.04	441.04	400.3	408.66	1391650.0
2011-07-19	AGZ	ETF	110.79	111.02	110.76	110.9	8402.0
2011-07-19	AIA	ETF	45.9	46.1	45.77	46.1	45032.0
2011-07-19	AIQ	ETF	17.8	17.9	17.35	17.4	42085.0
2011-07-19	AIS	ETF	2.3	2.38	2.25	2.38	875875.0
2011-07-19	AIVI	ETF	44.72	45.05	44.72	45.0	21700.0
2011-07-19	AMJ	ETF	37.34	37.48	37.28	37.35	279101.0
2011-07-19	AMLP	ETF	80.3	80.45	80.25	80.3	130160.0
2011-07-19	AOA	ETF	35.58	35.85	35.54	35.82	41200.0
2011-07-19	AOK	ETF	29.43	29.46	29.39	29.45	62002.0
2011-07-19	AOM	ETF	30.53	30.7	30.53	30.7	58315.0
2011-07-19	AOR	ETF	32.546	32.633	32.451	32.633	6774.0
2011-07-19	ARB	ETF	40.11	40.85	40.11	40.65	138764.0
2011-07-19	ARGT	ETF	29.6	29.6	29.38	29.44	2500.0
2011-07-19	ASEA	ETF	16.88	16.95	16.88	16.93	3200.0
2011-07-19	AWAY	ETF	42.0	42.26	41.0	41.41	65464.0
2011-07-19	BAB	ETF	26.54	26.77	26.52	26.77	146304.0
2011-07-19	BAL	ETF	61.54	63.636	61.54	63.09	113647.0
2011-07-19	BALT	ETF	4.82	5.02	4.75	5.01	250692.0
2011-07-19	BBH	ETF	34.9967	35.2967	34.95	35.2133	181200.0
2011-07-19	BIB	ETF	9.4675	9.8303	9.4675	9.8238	80000.0
2011-07-19	BICK	ETF	31.45	31.57	31.384	31.57	11867.0
2011-07-19	BIL	ETF	91.72	91.72	91.7	91.72	790000.0
2011-07-19	BITS	ETF	22.76	23.432	22.04	22.4	2094.0
2011-07-19	BIV	ETF	84.91	85.34	84.91	85.33	104800.0
2011-07-19	BJK	ETF	35.4	35.4	35.13	35.4	11800.0
2011-07-19	BKF	ETF	46.35	46.68	46.2	46.63	112762.0
2011-07-19	BKLN	ETF	24.73	24.81	24.73	24.81	78200.0
2011-07-19	BLNG	ETF	51.49	51.49	51.49	51.49	600.0
2011-07-19	BLV	ETF	80.9	82.09	80.75	82.08	49000.0
2011-07-19	BMVP	ETF	15.53	15.7067	15.53	15.697	12009.0
2011-07-19	BND	ETF	81.64	81.94	81.63	81.93	799000.0
2011-07-19	BNO	ETF	39.225	39.545	39.09	39.185	209600.0
2011-07-19	BRF	ETF	52.73	52.999	52.48	52.83	208436.0
2011-07-19	BSCE	ETF	21.18	21.21	21.18	21.208	14168.0

> showing 50 of 864 rows — these rows as CSV

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