PREVIEW / etf_daily / 2013-08-08

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-08.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-08-08	SPY	ETF	169.98	170.18	168.93	169.8	102181300.0
2013-08-08	QQQ	ETF	76.84	76.98	76.3	76.8	19993946.0
2013-08-08	IWM	ETF	104.3	104.6	103.58	104.15	27640300.0
2013-08-08	DIA	ETF	155.33	155.45	153.99	154.69	5071200.0
2013-08-08	GLD	ETF	124.78	126.99	124.77	126.86	8653600.0
2013-08-08	TLT	ETF	106.98	107.6	106.79	107.09	5510900.0
2013-08-08	AAXJ	ETF	55.64	55.97	55.24	55.84	334100.0
2013-08-08	ACTV	ETF	10.07	10.17	9.92	10.02	514134.0
2013-08-08	ACWI	ETF	52.89	53.05	52.63	53.0	1324700.0
2013-08-08	ACWV	ETF	62.15	62.17	61.71	62.1	32300.0
2013-08-08	ACWX	ETF	43.0	43.41	43.0	43.31	273105.0
2013-08-08	ADRE	ETF	35.4	35.83	35.31	35.76	11022.0
2013-08-08	AFK	ETF	29.46	29.71	29.46	29.7	48655.0
2013-08-08	AGEM	ETF	21.4123	21.4123	21.4123	21.4123	192.0
2013-08-08	AGG	ETF	107.1	107.21	107.02	107.08	848700.0
2013-08-08	AGQ	ETF	69.12	72.48	69.12	72.28	625450.0
2013-08-08	AGZ	ETF	111.241	111.29	111.1	111.19	6981.0
2013-08-08	AIA	ETF	43.56	43.8899	43.381	43.8	30629.0
2013-08-08	AIQ	ETF	21.72	22.39	21.6	22.26	142408.0
2013-08-08	AIVI	ETF	43.03	43.31	42.98	43.22	53600.0
2013-08-08	AMJ	ETF	47.42	47.7999	46.8	46.8	288352.0
2013-08-08	AMLP	ETF	88.05	88.5	87.45	87.55	655600.0
2013-08-08	ANGL	ETF	26.51	26.51	26.39	26.39	2400.0
2013-08-08	AOA	ETF	41.63	41.7	41.44	41.66	19900.0
2013-08-08	AOK	ETF	31.2	31.2696	31.1901	31.25	18267.0
2013-08-08	AOM	ETF	33.15	33.17	33.05	33.16	51988.0
2013-08-08	AOR	ETF	36.58	36.679	36.4995	36.66	109923.0
2013-08-08	ARB	ETF	46.19	46.19	46.01	46.14	99349.0
2013-08-08	ARGT	ETF	18.07	18.15	18.07	18.15	400.0
2013-08-08	ASEA	ETF	16.92	17.05	16.85	17.05	13600.0
2013-08-08	ATMP	ETF	26.85	26.85	26.49	26.57	21000.0
2013-08-08	AVIV	ETF	25.08	25.08	24.45	24.62	168565.0
2013-08-08	AWAY	ETF	29.54	30.23	29.44	29.64	802157.0
2013-08-08	BAB	ETF	27.75	27.85	27.67	27.692	1041345.0
2013-08-08	BAL	ETF	57.25	57.36	56.52	57.2	43032.0
2013-08-08	BALT	ETF	3.98	3.99	3.85	3.99	91767.0
2013-08-08	BBH	ETF	79.69	79.69	78.33	78.48	98200.0
2013-08-08	BCM	ETF	39.502	39.502	39.3193	39.3193	282.0
2013-08-08	BFOR	ETF	6.645	6.6675	6.6275	6.6575	123600.0
2013-08-08	BIB	ETF	29.6175	29.6175	28.525	28.7275	195332.0
2013-08-08	BICK	ETF	21.75	21.75	21.7	21.75	1150.0
2013-08-08	BIL	ETF	91.58	91.6	91.58	91.58	112050.0
2013-08-08	BIS	ETF	1185.2	1197.2	1173.6	1188.44	27.5
2013-08-08	BIV	ETF	83.5	83.59	83.48	83.52	179600.0
2013-08-08	BIZD	ETF	20.19	20.27	20.1	20.14	5800.0
2013-08-08	BJK	ETF	42.81	43.15	42.81	43.01	7900.0
2013-08-08	BKF	ETF	34.42	34.88	34.26	34.75	39044.0
2013-08-08	BKLN	ETF	24.88	24.89	24.85	24.85	3197300.0
2013-08-08	BLV	ETF	83.85	84.08	83.65	83.72	21600.0
2013-08-08	BMVP	ETF	20.0573	20.1621	20.0573	20.1621	3757.0

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

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