PREVIEW / etf_daily / 2013-01-02

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-02.parquet
  size:    40 KB
  rows:    980

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-02	SPY	ETF	145.11	146.15	144.73	146.06	192059000.0
2013-01-02	QQQ	ETF	66.69	67.23	66.48	67.2	70695891.0
2013-01-02	IWM	ETF	86.34	86.91	86.04	86.8	116410600.0
2013-01-02	DIA	ETF	132.99	133.86	132.89	133.77	9636300.0
2013-01-02	GLD	ETF	163.49	164.14	163.14	163.17	10431800.0
2013-01-02	TLT	ETF	119.76	119.9	119.41	119.56	7472700.0
2013-01-02	AADR	ETF	31.65	31.65	31.5	31.5	1500.0
2013-01-02	AAXJ	ETF	61.44	61.94	61.34	61.76	520200.0
2013-01-02	ACTV	ETF	5.13	5.4	5.05	5.28	846426.0
2013-01-02	ACWI	ETF	48.92	49.07	48.71	49.04	2298300.0
2013-01-02	ACWV	ETF	56.89	57.2	56.23	56.37	30700.0
2013-01-02	ACWX	ETF	42.64	42.7	42.35	42.64	1108562.0
2013-01-02	ADRE	ETF	40.82	41.1586	40.82	41.13	103910.0
2013-01-02	AFK	ETF	31.72	31.79	31.39	31.78	59171.0
2013-01-02	AGEM	ETF	23.5	23.91	23.5	23.8748	1261.0
2013-01-02	AGG	ETF	110.82	111.0	110.82	110.95	1137300.0
2013-01-02	AGQ	ETF	188.68	189.8	182.72	183.16	530575.0
2013-01-02	AGZ	ETF	113.36	114.0399	113.23	113.24	17721.0
2013-01-02	AIA	ETF	48.99	49.46	48.99	49.46	20018.0
2013-01-02	AIQ	ETF	6.5	6.554	6.41	6.5	18743.0
2013-01-02	AIVI	ETF	42.33	42.48	42.13	42.36	38000.0
2013-01-02	AMJ	ETF	39.0	39.98	39.0	39.98	2243577.0
2013-01-02	AMLP	ETF	80.9	81.8	80.6	81.7	983980.0
2013-01-02	ANGL	ETF	27.0	27.13	26.95	26.96	1300.0
2013-01-02	AOA	ETF	37.77	37.88	37.64	37.76	61400.0
2013-01-02	AOK	ETF	30.69	30.75	30.67	30.75	60578.0
2013-01-02	AOM	ETF	31.97	32.11	31.9	32.11	369659.0
2013-01-02	AOR	ETF	34.33	34.44	34.23	34.4399	35948.0
2013-01-02	ARB	ETF	46.73	46.75	46.62	46.69	848045.0
2013-01-02	ARGT	ETF	17.88	17.88	17.72	17.84	4600.0
2013-01-02	ASEA	ETF	17.12	17.27	17.12	17.27	25600.0
2013-01-02	AWAY	ETF	22.36	22.36	21.635	21.99	686627.0
2013-01-02	BAB	ETF	30.02	30.274	30.02	30.22	377297.0
2013-01-02	BAL	ETF	49.98	50.2774	48.9014	49.2299	18717.0
2013-01-02	BALT	ETF	3.07	3.14	2.971	3.11	40729.0
2013-01-02	BBH	ETF	54.85	55.33	54.6	55.33	46100.0
2013-01-02	BCM	ETF	44.46	44.46	44.24	44.25	9345.0
2013-01-02	BIB	ETF	15.125	15.4175	15.07	15.4175	123128.0
2013-01-02	BICK	ETF	25.87	26.04	25.87	26.04	4521.0
2013-01-02	BIL	ETF	91.62	91.64	91.62	91.62	1277900.0
2013-01-02	BIS	ETF	2533.6	2535.2	2478.0	2478.0	507.0
2013-01-02	BIV	ETF	88.14	88.27	88.11	88.17	445200.0
2013-01-02	BJK	ETF	36.5	36.83	36.5	36.79	9400.0
2013-01-02	BKF	ETF	41.48	42.01	41.48	42.01	240733.0
2013-01-02	BKLN	ETF	25.03	25.04	25.03	25.04	1073600.0
2013-01-02	BLV	ETF	92.93	93.18	92.76	92.99	141900.0
2013-01-02	BMVP	ETF	16.6167	16.72	16.5958	16.6567	9598.0
2013-01-02	BND	ETF	83.78	83.94	83.78	83.9	1857300.0
2013-01-02	BNO	ETF	41.55	41.575	41.235	41.425	134200.0
2013-01-02	BOIL	ETF	729200.0	734400.0	705200.0	733000.0	29.0

> showing 50 of 980 rows — these rows as CSV

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