PREVIEW / etf_daily / 2013-01-18

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-18.parquet
  size:    40 KB
  rows:    971

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-01-18	SPY	ETF	147.97	148.49	147.43	148.33	169906000.0
2013-01-18	QQQ	ETF	67.01	67.14	66.77	67.07	31991953.0
2013-01-18	IWM	ETF	88.34	88.62	88.11	88.57	23256900.0
2013-01-18	DIA	ETF	135.81	136.16	135.42	136.09	4922500.0
2013-01-18	GLD	ETF	163.95	163.97	163.02	163.09	10038100.0
2013-01-18	TLT	ETF	119.57	120.21	119.46	120.04	4660000.0
2013-01-18	AADR	ETF	32.43	32.43	32.43	32.43	800.0
2013-01-18	AAXJ	ETF	61.13	61.19	60.89	61.06	1025300.0
2013-01-18	ACTV	ETF	5.6	5.61	5.47	5.53	394096.0
2013-01-18	ACWI	ETF	49.54	49.61	49.32	49.59	922300.0
2013-01-18	ACWV	ETF	57.06	57.42	57.06	57.38	32500.0
2013-01-18	ACWX	ETF	42.88	42.88	42.684	42.87	669329.0
2013-01-18	ADRE	ETF	41.2	41.246	41.1	41.23	21588.0
2013-01-18	AFK	ETF	31.18	31.2	31.05	31.2	11871.0
2013-01-18	AGEM	ETF	23.88	23.95	23.8615	23.95	544.0
2013-01-18	AGG	ETF	110.88	110.94	110.83	110.93	654700.0
2013-01-18	AGQ	ETF	195.76	195.96	191.36	193.04	370075.0
2013-01-18	AGZ	ETF	113.2555	113.39	113.2555	113.38	21085.0
2013-01-18	AIA	ETF	48.08	48.2	47.995	48.12	17824.0
2013-01-18	AIQ	ETF	6.7	6.755	6.57	6.66	10711.0
2013-01-18	AIVI	ETF	42.83	42.88	42.66	42.85	27400.0
2013-01-18	AMJ	ETF	41.8	42.02	41.5301	41.92	1666826.0
2013-01-18	AMLP	ETF	84.15	84.6	84.0	84.5	730900.0
2013-01-18	ANGL	ETF	27.28	27.42	27.19	27.19	2800.0
2013-01-18	AOA	ETF	38.28	38.37	38.2	38.37	13700.0
2013-01-18	AOK	ETF	30.8295	30.8755	30.811	30.86	14502.0
2013-01-18	AOM	ETF	32.18	32.22	32.1201	32.22	465672.0
2013-01-18	AOR	ETF	34.69	34.73	34.5926	34.73	39701.0
2013-01-18	ARB	ETF	46.84	47.07	46.79	46.98	887464.0
2013-01-18	ARGT	ETF	18.12	18.32	18.12	18.32	1150.0
2013-01-18	ASEA	ETF	17.13	17.16	17.03	17.12	24500.0
2013-01-18	AWAY	ETF	22.83	23.02	22.51	22.71	324153.0
2013-01-18	BAB	ETF	30.2	30.24	30.11	30.22	188956.0
2013-01-18	BAL	ETF	50.78	51.5	50.78	51.43	27065.0
2013-01-18	BALT	ETF	3.4	3.44	3.34	3.44	11508.0
2013-01-18	BBH	ETF	56.88	56.88	56.45	56.77	17000.0
2013-01-18	BCM	ETF	44.66	44.66	44.6269	44.65	3631.0
2013-01-18	BIB	ETF	16.2475	16.2475	15.905	16.1375	101888.0
2013-01-18	BICK	ETF	25.85	25.99	25.8051	25.92	2731.0
2013-01-18	BIL	ETF	91.62	91.62	91.6	91.6	279400.0
2013-01-18	BIS	ETF	2353.6	2388.0	2353.6	2388.0	28.75
2013-01-18	BIV	ETF	88.04	88.09	87.94	88.07	281000.0
2013-01-18	BJK	ETF	38.13	38.13	37.95	38.07	3900.0
2013-01-18	BKF	ETF	42.01	42.15	41.9	42.08	141457.0
2013-01-18	BKLN	ETF	25.17	25.19	25.14	25.19	2942200.0
2013-01-18	BLV	ETF	92.92	93.46	92.92	93.36	44200.0
2013-01-18	BMVP	ETF	17.1533	17.1533	17.045	17.1434	5218.0
2013-01-18	BND	ETF	83.79	83.92	83.79	83.92	920000.0
2013-01-18	BNO	ETF	41.405	41.705	41.305	41.7	67800.0
2013-01-18	BOIL	ETF	843800.0	875000.0	833400.0	872000.0	19.2

> showing 50 of 971 rows — these rows as CSV

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