PREVIEW / etf_daily / 2013-10-24

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-24.parquet
  size:    42 KB
  rows:    1,047

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
2013-10-24	SPY	ETF	174.92	175.37	174.51	175.15	70350000.0
2013-10-24	QQQ	ETF	81.99	82.48	81.88	82.31	23155090.0
2013-10-24	IWM	ETF	110.47	111.26	110.33	110.98	24711800.0
2013-10-24	DIA	ETF	154.19	154.95	154.1	154.8	5182600.0
2013-10-24	GLD	ETF	129.41	130.53	129.41	129.9	10221400.0
2013-10-24	TLT	ETF	108.61	108.67	107.87	107.89	7631400.0
2013-10-24	AADR	ETF	37.09	37.09	37.08	37.08	300.0
2013-10-24	AAXJ	ETF	60.32	60.35	59.97	60.0	1029200.0
2013-10-24	ACTV	ETF	14.43	14.43	14.39	14.4	2622660.0
2013-10-24	ACWI	ETF	56.28	56.32	56.1	56.27	502900.0
2013-10-24	ACWV	ETF	64.15	64.15	63.86	63.98	56300.0
2013-10-24	ACWX	ETF	46.69	46.8099	46.67	46.76	130953.0
2013-10-24	ADRE	ETF	38.3	38.4	38.24	38.34	32998.0
2013-10-24	AFK	ETF	32.0	32.0	31.75	31.862	16304.0
2013-10-24	AGG	ETF	108.14	108.14	107.94	107.97	532800.0
2013-10-24	AGQ	ETF	87.32	88.48	87.04	87.04	335300.0
2013-10-24	AGZ	ETF	111.83	112.15	111.64	111.86	142673.0
2013-10-24	AIA	ETF	47.6779	47.6868	47.51	47.57	35945.0
2013-10-24	AIQ	ETF	30.86	32.73	30.86	31.61	32515.0
2013-10-24	AIVI	ETF	47.43	47.99	47.43	47.64	48500.0
2013-10-24	ALTL	ETF	31.25	31.3	31.24	31.3	1000.0
2013-10-24	AMJ	ETF	45.87	46.2999	45.58	46.12	835333.0
2013-10-24	AMLP	ETF	89.45	89.9	89.4	89.75	616880.0
2013-10-24	ANGL	ETF	26.88	26.88	26.85	26.85	200.0
2013-10-24	AOA	ETF	43.39	43.45	43.28	43.43	42300.0
2013-10-24	AOK	ETF	31.91	31.91	31.864	31.87	24474.0
2013-10-24	AOM	ETF	33.941	34.02	33.94	34.01	14617.0
2013-10-24	AOR	ETF	37.76	37.84	37.74	37.83	20749.0
2013-10-24	ARGT	ETF	21.08	21.48	21.08	21.48	7300.0
2013-10-24	ASEA	ETF	17.29	17.29	17.26	17.26	7000.0
2013-10-24	ATMP	ETF	26.91	26.98	26.91	26.98	3500.0
2013-10-24	AVIV	ETF	24.88	25.38	24.83	25.38	249915.0
2013-10-24	AWAY	ETF	29.64	29.95	29.0203	29.56	511753.0
2013-10-24	BAB	ETF	27.96	27.99	27.83	27.83	185070.0
2013-10-24	BAL	ETF	50.7	50.7	50.44	50.53	34524.0
2013-10-24	BALT	ETF	5.16	5.19	4.93	4.96	631858.0
2013-10-24	BBH	ETF	82.89	83.67	82.89	83.23	78300.0
2013-10-24	BCM	ETF	40.13	40.13	40.13	40.13	100.0
2013-10-24	BFOR	ETF	7.0875	7.1225	7.0525	7.1225	440000.0
2013-10-24	BIB	ETF	32.5525	33.1998	32.5078	33.03	279688.0
2013-10-24	BICK	ETF	24.795	24.795	24.75	24.75	551.0
2013-10-24	BIL	ETF	91.56	91.58	91.56	91.56	149050.0
2013-10-24	BIS	ETF	998.8	998.8	970.8	978.0	179.0
2013-10-24	BIV	ETF	84.62	84.69	84.44	84.47	170500.0
2013-10-24	BIZD	ETF	20.84	20.84	20.73	20.83	6300.0
2013-10-24	BJK	ETF	50.34	50.92	50.34	50.83	19200.0
2013-10-24	BKF	ETF	38.33	38.42	38.031	38.16	71512.0
2013-10-24	BKLN	ETF	24.77	24.78	24.75	24.76	5177700.0
2013-10-24	BLNG	ETF	38.68	38.84	38.68	38.84	1850.0
2013-10-24	BLV	ETF	84.98	85.04	84.67	84.67	10000.0

> showing 50 of 1,047 rows — these rows as CSV

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