PREVIEW / etf_daily / 2011-01-13

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-13.parquet
  size:    35 KB
  rows:    821

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
2011-01-13	SPY	ETF	128.63	128.69	128.05	128.37	129048400.0
2011-01-13	QQQ	ETF	56.59	56.73	56.41	56.575	47430380.0
2011-01-13	IWM	ETF	79.99	80.3	79.57	79.94	29687600.0
2011-01-13	DIA	ETF	117.37	117.38	116.82	117.2	6056800.0
2011-01-13	GLD	ETF	135.66	135.68	133.63	134.05	14294600.0
2011-01-13	TLT	ETF	91.62	92.77	91.45	92.43	14502400.0
2011-01-13	AADR	ETF	29.9	29.91	29.9	29.91	1200.0
2011-01-13	AAXJ	ETF	64.25	64.34	63.74	63.88	1371800.0
2011-01-13	ACWI	ETF	47.66	47.7	47.4	47.41	1421000.0
2011-01-13	ACWX	ETF	44.75	44.786	44.41	44.54	57841.0
2011-01-13	ADRE	ETF	48.59	48.68	48.04	48.15	38121.0
2011-01-13	AFK	ETF	36.35	36.35	36.005	36.14	61435.0
2011-01-13	AGG	ETF	105.43	105.95	105.42	105.95	943500.0
2011-01-13	AGQ	ETF	291.16	291.16	268.78	272.04	616500.0
2011-01-13	AGZ	ETF	109.66	110.08	109.5436	109.88	238190.0
2011-01-13	AIA	ETF	48.27	48.325	48.0	48.16	59353.0
2011-01-13	AIQ	ETF	20.85	21.15	20.35	20.7	31929.0
2011-01-13	AIS	ETF	1.72	1.74	1.7	1.71	296806.0
2011-01-13	AIVI	ETF	44.36	44.54	44.17	44.21	77900.0
2011-01-13	AMJ	ETF	37.1	37.23	36.85	37.23	479371.0
2011-01-13	AMLP	ETF	81.25	81.25	81.0	81.15	107620.0
2011-01-13	AOA	ETF	34.97	34.97	34.83	34.89	43500.0
2011-01-13	AOK	ETF	28.93	28.96	28.9	28.93	9019.0
2011-01-13	AOM	ETF	30.15	30.2	30.14	30.15	61048.0
2011-01-13	AOR	ETF	31.83	31.89	31.8105	31.86	37113.0
2011-01-13	ARB	ETF	42.2	42.32	41.84	42.25	143078.0
2011-01-13	BAB	ETF	25.2	25.35	25.1	25.34	331291.0
2011-01-13	BAL	ETF	76.39	76.39	72.76	73.259	46512.0
2011-01-13	BALT	ETF	10.62	10.67	10.32	10.37	177453.0
2011-01-13	BBH	ETF	34.26	34.3867	34.21	34.2633	17100.0
2011-01-13	BIB	ETF	7.9387	7.9387	7.9387	7.9387	800.0
2011-01-13	BICK	ETF	33.16	33.24	32.88	33.026	40791.0
2011-01-13	BIL	ETF	91.7	91.72	91.7	91.7	94600.0
2011-01-13	BIS	ETF	7209.6	7726.4	7209.6	7707.2	3.44
2011-01-13	BITS	ETF	28.68	29.24	28.4	28.4	4405.0
2011-01-13	BIV	ETF	82.56	83.07	82.53	83.01	364300.0
2011-01-13	BJK	ETF	33.29	33.4	32.97	33.11	73900.0
2011-01-13	BKF	ETF	50.28	50.3	49.6702	49.77	120787.0
2011-01-13	BLV	ETF	78.13	78.93	78.01	78.83	15800.0
2011-01-13	BMVP	ETF	14.8	14.84	14.78	14.8	5456.0
2011-01-13	BND	ETF	80.11	80.43	80.11	80.43	1025900.0
2011-01-13	BNO	ETF	32.38	32.5	32.15	32.275	27200.0
2011-01-13	BRF	ETF	58.8	59.0	58.1	58.22	323564.0
2011-01-13	BSCE	ETF	20.79	20.79	20.784	20.79	1935.0
2011-01-13	BSV	ETF	80.5	80.6	80.44	80.57	392100.0
2011-01-13	BTF	ETF	78.803	79.25	78.582	78.89999999999999	1921.8000000000002
2011-01-13	BWX	ETF	28.845	29.0	28.825	28.945	310802.0
2011-01-13	BWZ	ETF	36.78	37.05	36.78	36.87	22733.0
2011-01-13	BZQ	ETF	2316.8	2409.6	2304.0	2388.8	270.0
2011-01-13	CEF	ETF	19.98	20.0	19.3	19.42	1200500.0

> showing 50 of 821 rows — these rows as CSV

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