PREVIEW / etf_daily / 2012-01-17

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-17.parquet
  size:    37 KB
  rows:    898

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
2012-01-17	SPY	ETF	130.08	130.32	128.9	129.34	132209200.0
2012-01-17	QQQ	ETF	58.71	58.96	58.49	58.71	41790747.0
2012-01-17	IWM	ETF	77.1	77.27	76.13	76.36	34518400.0
2012-01-17	DIA	ETF	125.04	125.57	124.46	124.62	5348800.0
2012-01-17	GLD	ETF	161.17	161.65	160.42	160.5	8313300.0
2012-01-17	TLT	ETF	120.95	121.63	120.83	121.44	5449900.0
2012-01-17	AADR	ETF	28.44	28.44	28.44	28.44	200.0
2012-01-17	AAXJ	ETF	52.72	52.87	52.44	52.62	440900.0
2012-01-17	ACTV	ETF	15.0	15.28	14.79	15.0	490198.0
2012-01-17	ACWI	ETF	43.28	43.49	43.14	43.18	694900.0
2012-01-17	ACWV	ETF	51.79	51.84	51.79	51.84	1000.0
2012-01-17	ACWX	ETF	37.59	37.612	37.3	37.33	525930.0
2012-01-17	ADRE	ETF	40.79	40.98	40.65	40.74	85350.0
2012-01-17	AFK	ETF	26.76	27.05	26.67	26.67	10393.0
2012-01-17	AGEM	ETF	22.2	22.2	22.2	22.2	200.0
2012-01-17	AGG	ETF	110.68	110.75	110.53	110.58	1272900.0
2012-01-17	AGQ	ETF	197.44	200.52	193.4	194.68	402800.0
2012-01-17	AGZ	ETF	112.825	113.22	112.73	112.82	59908.0
2012-01-17	AIA	ETF	41.2	41.2	40.808	40.93	21036.0
2012-01-17	AIQ	ETF	5.65	5.75	5.4	5.45	17626.0
2012-01-17	AIS	ETF	2.29	2.29	2.2	2.2	820300.0
2012-01-17	AIVI	ETF	39.55	39.88	39.55	39.59	73900.0
2012-01-17	AMJ	ETF	38.94	39.1	38.84	39.03	749554.0
2012-01-17	AMLP	ETF	82.85	83.35	82.7	83.15	596660.0
2012-01-17	AOA	ETF	34.04	34.1	33.88	33.9	25000.0
2012-01-17	AOK	ETF	29.55	29.6	29.51	29.51	57809.0
2012-01-17	AOM	ETF	30.27	30.27	30.16	30.21	34207.0
2012-01-17	AOR	ETF	31.73	31.8	31.68	31.68	23496.0
2012-01-17	ARB	ETF	36.55	36.91	36.31	36.37	155529.0
2012-01-17	ARGT	ETF	22.7	22.9	22.58	22.62	4100.0
2012-01-17	ASEA	ETF	14.9	15.0	14.87	14.93	8600.0
2012-01-17	AWAY	ETF	24.99	25.1	24.22	25.06	152156.0
2012-01-17	BAB	ETF	29.0	29.089	28.978	29.0	397323.0
2012-01-17	BAL	ETF	59.92	61.552	59.92	60.42	22364.0
2012-01-17	BALT	ETF	4.43	4.51	4.06	4.12	175528.0
2012-01-17	BBH	ETF	40.26	40.2867	40.0133	40.1667	35400.0
2012-01-17	BCM	ETF	44.07	44.157	44.03	44.136	1098.0
2012-01-17	BIB	ETF	10.2338	10.2338	10.09	10.12	76920.0
2012-01-17	BICK	ETF	24.99	25.2	24.969	24.971	4624.0
2012-01-17	BIL	ETF	91.64	91.66	91.64	91.64	210850.0
2012-01-17	BIS	ETF	4568.0	4568.0	4448.0	4484.8	35.0
2012-01-17	BIV	ETF	87.4	87.51	87.31	87.36	366400.0
2012-01-17	BJK	ETF	31.42	31.53	31.23	31.25	10400.0
2012-01-17	BKF	ETF	39.24	39.46	39.18	39.3	104560.0
2012-01-17	BKLN	ETF	24.1	24.11	24.07	24.07	82600.0
2012-01-17	BLV	ETF	92.48	92.78	92.11	92.23	105300.0
2012-01-17	BMVP	ETF	14.19	14.24	14.17	14.2	6238.0
2012-01-17	BND	ETF	83.77	83.82	83.62	83.63	878100.0
2012-01-17	BNO	ETF	38.775	38.945	38.5	38.785	105800.0
2012-01-17	BOIL	ETF	1480000.0	1487000.0	1370000.0	1406000.0	2.8

> showing 50 of 898 rows — these rows as CSV

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