PREVIEW / etf_daily / 2013-10-02

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-02.parquet
  size:    41 KB
  rows:    1,015

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-10-02	SPY	ETF	168.35	169.34	167.83	169.18	113350000.0
2013-10-02	QQQ	ETF	79.13	79.76	79.06	79.65	25503753.0
2013-10-02	IWM	ETF	107.09	107.75	106.85	107.41	30622900.0
2013-10-02	DIA	ETF	150.9	151.1	150.15	150.98	8895300.0
2013-10-02	GLD	ETF	125.37	127.81	125.34	127.06	11994200.0
2013-10-02	TLT	ETF	105.93	106.48	105.76	105.96	5967200.0
2013-10-02	AAXJ	ETF	59.0	59.42	58.85	59.41	347700.0
2013-10-02	ACTV	ETF	14.38	14.41	14.36	14.4	3241572.0
2013-10-02	ACWI	ETF	54.11	54.35	53.92	54.34	861100.0
2013-10-02	ACWV	ETF	62.14	62.14	61.52	62.09	88000.0
2013-10-02	ACWX	ETF	45.06	45.21	44.85	45.21	105405.0
2013-10-02	ADRE	ETF	37.31	37.64	37.31	37.62	15685.0
2013-10-02	AFK	ETF	30.0	30.25	29.9001	30.09	24650.0
2013-10-02	AGEM	ETF	22.49	22.62	22.38	22.48	22016.0
2013-10-02	AGG	ETF	107.09	107.19	106.99	107.07	576900.0
2013-10-02	AGQ	ETF	77.6	82.56	77.44	80.4	724025.0
2013-10-02	AGZ	ETF	110.91	111.11	110.91	111.096	8185.0
2013-10-02	AIA	ETF	47.04	47.359	47.0	47.35	45907.0
2013-10-02	AIQ	ETF	29.09	30.55	28.44	29.35	78162.0
2013-10-02	AIVI	ETF	45.46	45.7	45.4	45.69	25800.0
2013-10-02	AMJ	ETF	44.7	45.1	44.64	45.0	263253.0
2013-10-02	AMLP	ETF	88.6	88.75	88.2	88.75	439660.0
2013-10-02	ANGL	ETF	26.5	26.5	26.37	26.37	1000.0
2013-10-02	AOA	ETF	42.02	42.17	41.89	42.17	7000.0
2013-10-02	AOK	ETF	31.37	31.39	31.321	31.37	7006.0
2013-10-02	AOM	ETF	33.29	33.34	33.2001	33.34	15765.0
2013-10-02	AOR	ETF	36.7814	36.92	36.7551	36.91	11775.0
2013-10-02	ARGT	ETF	19.91	20.14	19.91	20.03	1800.0
2013-10-02	ASEA	ETF	16.63	16.67	16.61	16.66	8000.0
2013-10-02	ATMP	ETF	26.55	26.55	26.29	26.29	27600.0
2013-10-02	AVIV	ETF	23.33	23.45	22.98	23.13	98086.0
2013-10-02	AWAY	ETF	27.76	27.98	27.27	27.49	1284499.0
2013-10-02	BAB	ETF	27.28	27.39	27.21	27.23	111049.0
2013-10-02	BAL	ETF	55.69	55.77	55.52	55.651	4600.0
2013-10-02	BALT	ETF	5.14	5.295	5.1	5.18	780920.0
2013-10-02	BBH	ETF	83.49	83.9	83.22	83.52	58800.0
2013-10-02	BCM	ETF	40.1901	40.1901	40.19	40.19	1570.0
2013-10-02	BFOR	ETF	6.87	6.8925	6.8475	6.88	182800.0
2013-10-02	BIB	ETF	33.7225	34.04	33.5027	33.8575	101764.0
2013-10-02	BICK	ETF	23.83	23.88	23.6601	23.88	2438.0
2013-10-02	BIL	ETF	91.6	91.6	91.58	91.6	185000.0
2013-10-02	BIS	ETF	985.6	996.18	976.84	986.4	125.5
2013-10-02	BIV	ETF	83.38	83.47	83.28	83.34	260200.0
2013-10-02	BIZD	ETF	20.26	20.26	20.1	20.1	2800.0
2013-10-02	BJK	ETF	47.96	48.21	47.86	48.21	13500.0
2013-10-02	BKF	ETF	37.49	37.86	37.4685	37.86	96540.0
2013-10-02	BKLN	ETF	24.68	24.71	24.65	24.71	1689400.0
2013-10-02	BLV	ETF	82.64	82.91	82.64	82.81	169000.0
2013-10-02	BMVP	ETF	20.3033	20.3634	20.2566	20.3634	451.0
2013-10-02	BND	ETF	80.66	80.78	80.65	80.7	984500.0

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

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