PREVIEW / etf_daily / 2013-04-01

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-01.parquet
  size:    40 KB
  rows:    979

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-04-01	SPY	ETF	156.59	156.91	155.67	156.05	99194100.0
2013-04-01	QQQ	ETF	69.01	69.09	68.31	68.5	28118835.0
2013-04-01	IWM	ETF	94.27	94.47	92.71	93.16	59660300.0
2013-04-01	DIA	ETF	145.3	145.73	144.97	145.38	8621600.0
2013-04-01	GLD	ETF	154.57	154.93	154.3	154.67	4288100.0
2013-04-01	TLT	ETF	117.52	118.42	117.49	118.39	6113800.0
2013-04-01	AAXJ	ETF	58.97	59.08	58.41	58.54	352000.0
2013-04-01	ACTV	ETF	4.17	4.22	3.83	3.95	944388.0
2013-04-01	ACWI	ETF	50.67	50.71	50.28	50.38	495400.0
2013-04-01	ACWV	ETF	61.89	61.92	61.38	61.57	199000.0
2013-04-01	ACWX	ETF	42.64	42.69	42.34	42.42	252260.0
2013-04-01	ADRE	ETF	38.51	38.63	38.2701	38.29	27385.0
2013-04-01	AFK	ETF	30.36	30.36	30.15	30.23	29055.0
2013-04-01	AGEM	ETF	22.8	22.8	22.512	22.5359	1348.0
2013-04-01	AGG	ETF	110.44	110.58	110.39	110.57	1580800.0
2013-04-01	AGQ	ETF	147.32	148.08	145.64	147.48	304375.0
2013-04-01	AGZ	ETF	113.27	113.386	113.21	113.311	9214.0
2013-04-01	AIA	ETF	46.34	46.34	45.91	45.97	16192.0
2013-04-01	AIQ	ETF	7.5	7.954	7.5	7.75	15430.0
2013-04-01	AIVI	ETF	41.96	42.07	41.67	41.78	33200.0
2013-04-01	AMJ	ETF	45.51	45.702	45.26	45.47	1676163.0
2013-04-01	AMLP	ETF	88.7	88.95	88.35	88.4	544700.0
2013-04-01	AOA	ETF	39.73	39.73	39.47	39.55	25300.0
2013-04-01	AOK	ETF	31.19	31.2	31.111	31.14	20547.0
2013-04-01	AOM	ETF	32.75	32.8	32.68	32.74	32277.0
2013-04-01	AOR	ETF	35.67	35.67	35.4999	35.57	16453.0
2013-04-01	ARB	ETF	46.88	46.95	46.84	46.95	218413.0
2013-04-01	ARGT	ETF	17.8	17.8	17.4	17.4	3600.0
2013-04-01	ASEA	ETF	17.62	17.68	17.46	17.5	10700.0
2013-04-01	ATMP	ETF	26.33	26.33	26.14	26.24	24600.0
2013-04-01	AVIV	ETF	24.24	24.67	24.03	24.21	225450.0
2013-04-01	AWAY	ETF	32.65	32.792	31.0302	31.6	1285725.0
2013-04-01	BAB	ETF	30.14	30.34	30.14	30.32	169503.0
2013-04-01	BAL	ETF	57.17	57.67	56.2611	56.44	38336.0
2013-04-01	BALT	ETF	4.05	4.0501	3.66	3.8	81453.0
2013-04-01	BBH	ETF	65.22	65.53	64.45	64.78	114300.0
2013-04-01	BCM	ETF	42.8074	42.9	42.8074	42.9	5229.0
2013-04-01	BIB	ETF	19.765	19.9473	19.3205	19.4325	152980.0
2013-04-01	BICK	ETF	23.93	23.95	23.858	23.858	2504.0
2013-04-01	BIL	ETF	91.62	91.62	91.6	91.6	182100.0
2013-04-01	BIS	ETF	1896.8	1931.24	1890.4	1931.24	106.0
2013-04-01	BIV	ETF	87.34	87.57	87.33	87.54	260300.0
2013-04-01	BIZD	ETF	20.14	20.25	20.11	20.16	10600.0
2013-04-01	BJK	ETF	39.98	39.98	39.49	39.49	14300.0
2013-04-01	BKF	ETF	38.87	38.8799	38.41	38.47	56887.0
2013-04-01	BKLN	ETF	25.11	25.12	25.08	25.1	2179100.0
2013-04-01	BLV	ETF	91.23	91.52	91.02	91.4	264200.0
2013-04-01	BMVP	ETF	18.68	18.68	18.57	18.59	750.0
2013-04-01	BND	ETF	83.28	83.44	83.28	83.41	1056100.0
2013-04-01	BNO	ETF	41.505	42.1	41.5	41.955	94400.0

> showing 50 of 979 rows — these rows as CSV

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