PREVIEW / etf_daily / 2011-10-18

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-18.parquet
  size:    37 KB
  rows:    881

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-10-18	SPY	ETF	120.14	123.5	119.2	122.58	318857900.0
2011-10-18	QQQ	ETF	57.19	58.29	56.66	57.99	91434322.0
2011-10-18	IWM	ETF	69.21	71.29	67.85	70.81	98948000.0
2011-10-18	DIA	ETF	113.54	116.42	112.83	115.51	11694400.0
2011-10-18	GLD	ETF	159.96	162.03	158.3	161.84	15390800.0
2011-10-18	TLT	ETF	116.14	116.82	114.3	115.2	12495600.0
2011-10-18	AAXJ	ETF	50.36	51.67	49.81	51.48	450600.0
2011-10-18	ACTV	ETF	14.36	15.87	14.0	15.51	105790.0
2011-10-18	ACWI	ETF	41.99	43.07	41.55	42.78	1352200.0
2011-10-18	ACWX	ETF	37.5	38.437	37.18	38.19	90452.0
2011-10-18	ADRE	ETF	38.13	39.05	37.798	38.91	29827.0
2011-10-18	AFK	ETF	27.1	27.75	26.92	27.61	7213.0
2011-10-18	AGEM	ETF	20.96	21.583	20.77	21.4	23418.0
2011-10-18	AGG	ETF	109.32	109.54	109.12	109.25	958800.0
2011-10-18	AGQ	ETF	222.44	240.8	215.0	239.2	439800.0
2011-10-18	AGZ	ETF	112.25	112.33	111.96	112.2199	32283.0
2011-10-18	AIA	ETF	39.04	39.91	38.5712	39.76	70977.0
2011-10-18	AIQ	ETF	5.75	5.75	5.5	5.75	29062.0
2011-10-18	AIS	ETF	2.25	2.26	2.19	2.22	814894.0
2011-10-18	AIVI	ETF	41.0	41.91	40.58	41.69	216000.0
2011-10-18	AMJ	ETF	35.53	36.04	35.53	35.85	2237887.0
2011-10-18	AMLP	ETF	78.3	78.7	77.75	78.5	572540.0
2011-10-18	AOA	ETF	31.96	32.59	31.86	32.59	8300.0
2011-10-18	AOK	ETF	28.92	29.04	28.872	29.04	40708.0
2011-10-18	AOM	ETF	29.42	29.69	29.37	29.67	44620.0
2011-10-18	AOR	ETF	30.38	30.77	30.3	30.76	20339.0
2011-10-18	ARB	ETF	36.45	37.63	35.5148	37.26	199018.0
2011-10-18	ARGT	ETF	21.6	21.6	21.6	21.6	100.0
2011-10-18	ASEA	ETF	14.6	14.85	14.47	14.85	5900.0
2011-10-18	AWAY	ETF	37.26	37.55	35.94	36.12	137342.0
2011-10-18	BAB	ETF	28.07	28.1923	27.92	27.93	121661.0
2011-10-18	BAL	ETF	61.69	62.24	61.58	62.14	24547.0
2011-10-18	BALT	ETF	5.46	5.6592	5.4	5.63	137101.0
2011-10-18	BBH	ETF	33.6833	34.36	33.5533	34.2733	84600.0
2011-10-18	BCM	ETF	43.71	43.85	43.71	43.85	1300.0
2011-10-18	BIB	ETF	7.305	7.4125	7.225	7.4125	20912.0
2011-10-18	BICK	ETF	24.37	24.8564	24.15	24.73	3924.0
2011-10-18	BIL	ETF	91.68	91.7	91.68	91.7	350650.0
2011-10-18	BIS	ETF	6720.0	6720.0	6416.0	6416.0	7.2
2011-10-18	BITS	ETF	22.4	23.36	21.56	21.56	9775.0
2011-10-18	BIV	ETF	86.8	86.95	86.57	86.75	369100.0
2011-10-18	BJK	ETF	30.74	31.46	30.15	31.25	20000.0
2011-10-18	BKF	ETF	36.73	37.67	36.14	37.52	204967.0
2011-10-18	BKLN	ETF	23.44	23.51	23.29	23.47	57100.0
2011-10-18	BLNG	ETF	50.67	50.67	50.67	50.67	100.0
2011-10-18	BLV	ETF	89.99	90.41	89.14	89.74	64700.0
2011-10-18	BMVP	ETF	12.9733	13.5072	12.9733	13.4133	5078.0
2011-10-18	BND	ETF	83.18	83.27	83.01	83.05	844700.0
2011-10-18	BNO	ETF	37.59	38.265	37.19	38.155	263600.0
2011-10-18	BRF	ETF	43.08	43.98	42.19	43.65	160834.0

> showing 50 of 881 rows — these rows as CSV

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