PREVIEW / etf_daily / 2010-07-27

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-27.parquet
  size:    33 KB
  rows:    766

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
2010-07-27	SPY	ETF	112.17	112.29	111.11	111.55	204855600.0
2010-07-27	QQQ	ETF	46.69	46.72	46.21	46.42	67655551.0
2010-07-27	IWM	ETF	67.06	67.27	65.98	66.22	84127100.0
2010-07-27	DIA	ETF	105.75	105.84	105.0	105.44	10259500.0
2010-07-27	GLD	ETF	114.95	114.99	113.21	113.51	29524800.0
2010-07-27	TLT	ETF	98.78	99.18	98.57	98.65	5328000.0
2010-07-27	AADR	ETF	25.25	25.29	25.2	25.29	8200.0
2010-07-27	AAXJ	ETF	56.46	56.6	56.0	56.21	938500.0
2010-07-27	ACWI	ETF	41.58	41.58	41.07	41.27	85000.0
2010-07-27	ACWX	ETF	39.09	39.15	38.78	38.94	117858.0
2010-07-27	ADRE	ETF	42.69	42.83	42.231	42.45	173068.0
2010-07-27	AFK	ETF	30.78	30.79	29.97	30.75	77475.0
2010-07-27	AGG	ETF	107.39	107.49	107.32	107.37	516900.0
2010-07-27	AGQ	ETF	116.08	116.08	110.88	111.96	199600.0
2010-07-27	AGZ	ETF	110.42	110.459	110.24	110.34	18618.0
2010-07-27	AIA	ETF	39.79	39.86	39.77	39.8499	9248.0
2010-07-27	AIQ	ETF	20.05	20.2	18.75	18.9	69693.0
2010-07-27	AIS	ETF	1.78	1.8	1.61	1.64	2032032.0
2010-07-27	AIVI	ETF	40.6	40.66	40.33	40.56	18200.0
2010-07-27	AMJ	ETF	33.6	33.6	32.65	32.65	2654968.0
2010-07-27	AOA	ETF	30.6	30.61	30.29	30.37	9700.0
2010-07-27	AOK	ETF	28.0	28.0	27.83	27.88	1745.0
2010-07-27	AOM	ETF	28.57	28.57	28.4135	28.45	33582.0
2010-07-27	AOR	ETF	29.33	29.36	29.1195	29.138	7747.0
2010-07-27	ARB	ETF	31.05	31.82	30.59	30.71	202169.0
2010-07-27	BAB	ETF	25.85	25.91	25.816	25.89	168775.0
2010-07-27	BAL	ETF	37.4701	37.51	37.25	37.25	2347.0
2010-07-27	BALT	ETF	11.5	11.5	11.31	11.39	64684.0
2010-07-27	BBH	ETF	31.1033	31.24	30.9933	31.1767	178200.0
2010-07-27	BIB	ETF	5.975	5.975	5.71	5.71	19792.0
2010-07-27	BICK	ETF	29.1	29.14	29.057	29.075	717.0
2010-07-27	BIL	ETF	91.7	91.7	91.68	91.68	874800.0
2010-07-27	BIS	ETF	11211.2	11334.4	11211.2	11334.08	4.06
2010-07-27	BITS	ETF	26.76	26.8	26.6	26.8	250.0
2010-07-27	BIV	ETF	83.95	84.01	83.82	83.93	149900.0
2010-07-27	BJK	ETF	25.2	25.33	24.98	25.11	18800.0
2010-07-27	BKF	ETF	44.82	45.0	44.37	44.53	100962.0
2010-07-27	BLV	ETF	81.94	82.06	81.53	81.64	52300.0
2010-07-27	BMVP	ETF	12.6767	12.7021	12.56	12.5967	11324.0
2010-07-27	BND	ETF	81.39	81.56	81.39	81.5	815500.0
2010-07-27	BNE	ETF	11.35	11.35	11.34	11.35	204604.0
2010-07-27	BNO	ETF	25.93	25.93	25.54	25.775	105600.0
2010-07-27	BRF	ETF	48.83	49.17	48.19	48.19	244055.0
2010-07-27	BSCE	ETF	20.65	20.7	20.64	20.643	82808.0
2010-07-27	BSV	ETF	81.06	81.11	81.05	81.05	1241200.0
2010-07-27	BTF	ETF	70.7	71.0005	70.44999999999999	70.6005	1270.6000000000001
2010-07-27	BWX	ETF	28.17	28.17	27.65	28.145	106262.0
2010-07-27	BWZ	ETF	35.28	35.28	35.01	35.119	6656.0
2010-07-27	BZQ	ETF	3404.8	3510.4	3393.6	3494.4	679.5
2010-07-27	CEF	ETF	14.46	14.46	14.1	14.1	1488800.0

> showing 50 of 766 rows — these rows as CSV

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