PREVIEW / etf_daily / 2013-07-01

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-01.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-01	SPY	ETF	161.26	162.48	161.08	161.36	131954800.0
2013-07-01	QQQ	ETF	71.76	72.3	71.64	71.71	24951289.0
2013-07-01	IWM	ETF	97.65	99.1	97.64	98.58	37805800.0
2013-07-01	DIA	ETF	149.52	150.5	149.22	149.42	4895800.0
2013-07-01	GLD	ETF	119.94	121.95	119.38	121.13	15945200.0
2013-07-01	TLT	ETF	109.73	110.5	109.43	110.41	5500400.0
2013-07-01	AADR	ETF	33.04	33.04	32.96	32.98	3100.0
2013-07-01	AAXJ	ETF	55.18	55.23	54.73	54.83	455800.0
2013-07-01	ACTV	ETF	7.61	8.44	7.61	7.74	620557.0
2013-07-01	ACWI	ETF	50.3	50.63	50.26	50.32	1916500.0
2013-07-01	ACWV	ETF	59.95	60.41	59.94	60.05	739400.0
2013-07-01	ACWX	ETF	41.05	41.2	40.94	40.98	249421.0
2013-07-01	ADRE	ETF	34.56	34.67	34.36	34.43	25429.0
2013-07-01	AFK	ETF	27.15	27.44	27.041	27.054	61675.0
2013-07-01	AGEM	ETF	20.85	20.85	20.71	20.71	4332.0
2013-07-01	AGG	ETF	106.92	107.21	106.92	107.16	950300.0
2013-07-01	AGQ	ETF	68.24	69.44	67.2	68.12	786425.0
2013-07-01	AGZ	ETF	110.81	111.45	110.77	111.31	229835.0
2013-07-01	AIA	ETF	42.68	42.75	42.4	42.45	57328.0
2013-07-01	AIQ	ETF	15.7	16.02	15.566	15.8	53299.0
2013-07-01	AIVI	ETF	40.36	40.43	40.19	40.22	47600.0
2013-07-01	AMJ	ETF	46.76	48.16	46.76	47.94	730704.0
2013-07-01	AMLP	ETF	89.35	90.35	89.15	90.05	893500.0
2013-07-01	ANGL	ETF	26.24	26.28	26.24	26.28	200.0
2013-07-01	AOA	ETF	40.05	40.28	40.05	40.1	48200.0
2013-07-01	AOK	ETF	30.81	30.87	30.81	30.83	34859.0
2013-07-01	AOM	ETF	32.45	32.5899	32.45	32.51	17796.0
2013-07-01	AOR	ETF	35.61	35.76	35.61	35.65	25075.0
2013-07-01	ARB	ETF	46.47	46.47	46.34	46.37	379645.0
2013-07-01	ARGT	ETF	16.23	16.4	16.23	16.4	400.0
2013-07-01	ASEA	ETF	16.97	16.98	16.83	16.85	22600.0
2013-07-01	ATMP	ETF	26.25	26.34	25.99	26.22	17300.0
2013-07-01	AVIV	ETF	25.47	25.47	24.62	24.89	335575.0
2013-07-01	AWAY	ETF	32.5	32.95	31.81	31.98	813242.0
2013-07-01	BAB	ETF	28.05	28.33	28.015	28.2698	347415.0
2013-07-01	BAL	ETF	53.41	54.8372	53.28	54.83	8389.0
2013-07-01	BALT	ETF	3.79	3.87	3.67	3.7	110076.0
2013-07-01	BBH	ETF	70.74	72.93	70.44	71.5	97300.0
2013-07-01	BCM	ETF	38.74	38.81	38.74	38.79	2465.0
2013-07-01	BFOR	ETF	6.385	6.385	6.2475	6.26	134000.0
2013-07-01	BIB	ETF	23.7	24.875	23.7	23.9725	199052.0
2013-07-01	BICK	ETF	21.28	21.33	21.201	21.201	1016.0
2013-07-01	BIL	ETF	91.6	91.62	91.6	91.62	437200.0
2013-07-01	BIS	ETF	1500.0	1502.0	1387.6	1453.4	904.0
2013-07-01	BIV	ETF	83.25	83.48	83.18	83.41	426800.0
2013-07-01	BIZD	ETF	20.1	20.1	19.77	19.78	6100.0
2013-07-01	BJK	ETF	40.74	40.84	40.59	40.59	10800.0
2013-07-01	BKF	ETF	34.16	34.25	33.96	34.08	51847.0
2013-07-01	BKLN	ETF	24.72	24.75	24.71	24.74	2113400.0
2013-07-01	BLV	ETF	84.85	85.49	84.6	85.46	84900.0

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

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