PREVIEW / etf_daily / 2011-08-19

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-19.parquet
  size:    36 KB
  rows:    865

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-08-19	SPY	ETF	112.96	115.88	112.5	112.64	428281300.0
2011-08-19	QQQ	ETF	50.43	51.67	49.99	50.03	96674508.0
2011-08-19	IWM	ETF	65.01	67.41	64.9	65.28	99196100.0
2011-08-19	DIA	ETF	108.29	110.63	107.77	107.91	15277500.0
2011-08-19	GLD	ETF	181.64	181.67	178.91	179.95	34398100.0
2011-08-19	TLT	ETF	110.65	111.41	110.23	111.2	15708400.0
2011-08-19	AAXJ	ETF	52.74	53.89	52.67	52.72	398100.0
2011-08-19	ACTV	ETF	15.9	16.35	15.72	16.23	166940.0
2011-08-19	ACWI	ETF	40.89	41.79	40.55	40.56	825100.0
2011-08-19	ACWX	ETF	37.7	38.56	37.44	37.51	120843.0
2011-08-19	ADRE	ETF	39.34	40.28	39.19	39.29	67250.0
2011-08-19	AFK	ETF	28.5	29.029	28.26	28.37	12964.0
2011-08-19	AGEM	ETF	22.12	22.25	22.04	22.04	2413.0
2011-08-19	AGG	ETF	109.98	110.06	109.81	110.03	1271800.0
2011-08-19	AGQ	ETF	473.98	484.0	453.36	483.14	817450.0
2011-08-19	AGZ	ETF	112.6	112.72	112.33	112.55	95296.0
2011-08-19	AIA	ETF	38.73	39.59	38.73	38.84	52469.0
2011-08-19	AIQ	ETF	6.65	7.05	6.6	6.9	22881.0
2011-08-19	AIS	ETF	2.11	2.26	2.11	2.16	810215.0
2011-08-19	AIVI	ETF	39.95	40.86	39.68	39.78	18500.0
2011-08-19	AMJ	ETF	34.51	35.302	34.02	34.15	3845481.0
2011-08-19	AMLP	ETF	76.5	76.6	74.4	74.9	501440.0
2011-08-19	AOA	ETF	31.04	31.05	30.66	30.77	3100.0
2011-08-19	AOK	ETF	28.69	28.89	28.68	28.76	44727.0
2011-08-19	AOM	ETF	29.21	29.44	29.14	29.2	15427.0
2011-08-19	AOR	ETF	29.69	30.05	29.682	29.682	11885.0
2011-08-19	ARB	ETF	31.07	32.8	30.46	31.92	200730.0
2011-08-19	ARGT	ETF	24.72	24.72	24.38	24.38	2000.0
2011-08-19	ASEA	ETF	15.77	16.01	15.74	15.81	28400.0
2011-08-19	AWAY	ETF	34.8	35.86	33.97	34.98	90782.0
2011-08-19	BAB	ETF	27.71	27.9281	27.65	27.85	130201.0
2011-08-19	BAL	ETF	66.2	67.23	65.02	65.41	60868.0
2011-08-19	BALT	ETF	4.12	4.19	4.04	4.09	184801.0
2011-08-19	BBH	ETF	30.4867	31.47	30.4867	31.1	132000.0
2011-08-19	BIB	ETF	6.1063	6.5758	6.1063	6.3925	164216.0
2011-08-19	BICK	ETF	25.34	25.7	25.05	25.1893	9385.0
2011-08-19	BIL	ETF	91.72	91.72	91.7	91.72	941750.0
2011-08-19	BIS	ETF	8080.0	8080.0	7884.784	7977.6	6.9
2011-08-19	BITS	ETF	21.04	22.64	20.12	20.68	3250.0
2011-08-19	BIV	ETF	88.12	88.29	87.82	88.22	135900.0
2011-08-19	BJK	ETF	31.49	31.81	30.99	31.11	24000.0
2011-08-19	BKF	ETF	39.01	40.18	39.01	39.19	175300.0
2011-08-19	BKLN	ETF	23.22	23.22	23.05	23.16	51000.0
2011-08-19	BLNG	ETF	58.44	58.44	58.3	58.3224	1575.0
2011-08-19	BLV	ETF	88.8	89.35	88.63	89.09	43400.0
2011-08-19	BMVP	ETF	12.6	12.9	12.58	12.58	13015.0
2011-08-19	BND	ETF	83.92	84.03	83.82	83.99	1547900.0
2011-08-19	BNO	ETF	35.675	36.54	35.675	36.395	270600.0
2011-08-19	BOSS	ETF	59.5	59.5	56.95	56.95	300.0
2011-08-19	BRF	ETF	47.03	48.04	47.03	47.24	92765.0

> showing 50 of 865 rows — these rows as CSV

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