PREVIEW / etf_daily / 2013-07-24

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-24.parquet
  size:    41 KB
  rows:    1,008

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-07-24	SPY	ETF	169.79	169.86	168.18	168.52	112914000.0
2013-07-24	QQQ	ETF	74.99	75.02	74.33	74.5	24426805.0
2013-07-24	IWM	ETF	104.91	104.98	103.44	103.59	31809700.0
2013-07-24	DIA	ETF	155.61	155.7	154.61	155.1	3894500.0
2013-07-24	GLD	ETF	129.17	129.4	126.87	127.48	9979100.0
2013-07-24	TLT	ETF	107.65	107.89	106.79	107.52	8853100.0
2013-07-24	AADR	ETF	33.85	33.85	33.49	33.49	9000.0
2013-07-24	AAXJ	ETF	57.17	57.17	56.39	56.66	320300.0
2013-07-24	ACTV	ETF	8.7	8.91	8.64	8.68	398469.0
2013-07-24	ACWI	ETF	52.96	52.97	52.48	52.61	1985000.0
2013-07-24	ACWV	ETF	62.46	62.5	61.75	61.89	72000.0
2013-07-24	ACWX	ETF	43.39	43.45	43.005	43.13	753648.0
2013-07-24	ADRE	ETF	35.81	35.81	35.3	35.46	53649.0
2013-07-24	AFK	ETF	29.35	29.35	28.72	28.8301	29610.0
2013-07-24	AGEM	ETF	21.6	21.62	21.4509	21.4509	2020.0
2013-07-24	AGG	ETF	107.24	107.33	107.03	107.25	956800.0
2013-07-24	AGQ	ETF	72.52	72.88	70.48	71.64	461225.0
2013-07-24	AGZ	ETF	111.58	111.58	111.05	111.05	15011.0
2013-07-24	AIA	ETF	44.48	44.48	44.0444	44.21	50453.0
2013-07-24	AIQ	ETF	19.14	19.14	18.0101	18.85	71875.0
2013-07-24	AIVI	ETF	43.0	43.0	42.61	42.77	17300.0
2013-07-24	AMJ	ETF	48.05	48.05	46.96	47.31	611212.0
2013-07-24	AMLP	ETF	90.35	90.6	89.35	89.75	579880.0
2013-07-24	ANGL	ETF	27.06	27.08	26.97	27.03	2400.0
2013-07-24	AOA	ETF	41.63	41.67	41.3	41.39	20200.0
2013-07-24	AOK	ETF	31.258	31.26	31.1576	31.22	15159.0
2013-07-24	AOM	ETF	33.19	33.19	32.98	33.0001	31934.0
2013-07-24	AOR	ETF	36.62	36.62	36.401	36.43	106216.0
2013-07-24	ARB	ETF	46.39	46.47	46.36	46.45	129084.0
2013-07-24	ARGT	ETF	17.51	17.51	17.4	17.4	800.0
2013-07-24	ASEA	ETF	17.43	17.43	17.27	17.28	16700.0
2013-07-24	ATMP	ETF	26.56	26.56	26.35	26.43	20200.0
2013-07-24	AVIV	ETF	26.2	26.29	25.5	25.67	102347.0
2013-07-24	AWAY	ETF	31.67	31.68	31.13	31.37	620393.0
2013-07-24	BAB	ETF	27.8	27.95	27.681	27.76	219825.0
2013-07-24	BAL	ETF	55.08	55.12	54.46	54.9901	5900.0
2013-07-24	BALT	ETF	3.83	3.99	3.83	3.88	154574.0
2013-07-24	BBH	ETF	77.66	77.87	77.12	77.5	41400.0
2013-07-24	BCM	ETF	40.06	40.06	39.973	40.0299	2629.0
2013-07-24	BFOR	ETF	6.575	6.59	6.5175	6.53	309600.0
2013-07-24	BIB	ETF	28.2025	28.2772	27.595	27.85	102496.0
2013-07-24	BICK	ETF	22.08	22.08	21.86	21.8601	431.0
2013-07-24	BIL	ETF	91.6	91.62	91.58	91.62	747200.0
2013-07-24	BIS	ETF	1216.8	1243.2	1216.8	1228.8	156.0
2013-07-24	BIV	ETF	83.8	83.8	83.51	83.66	350700.0
2013-07-24	BIZD	ETF	20.52	20.52	20.35	20.39	9600.0
2013-07-24	BJK	ETF	42.45	42.45	42.04	42.04	2900.0
2013-07-24	BKF	ETF	35.7	35.7	35.11	35.32	79053.0
2013-07-24	BKLN	ETF	24.98	24.98	24.95	24.96	2131100.0
2013-07-24	BLV	ETF	84.61	84.79	84.0	84.56	95500.0

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

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