PREVIEW / etf_daily / 2010-09-27

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-27.parquet
  size:    34 KB
  rows:    793

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-09-27	SPY	ETF	114.86	114.99	114.16	114.27	128761800.0
2010-09-27	QQQ	ETF	49.65	49.75	49.35	49.39	43883412.0
2010-09-27	IWM	ETF	67.01	67.16	66.51	66.82	48357100.0
2010-09-27	DIA	ETF	108.57	108.73	108.08	108.19	3989800.0
2010-09-27	GLD	ETF	126.9	126.91	126.48	126.72	6679700.0
2010-09-27	TLT	ETF	104.53	105.45	104.48	105.3	7061600.0
2010-09-27	AADR	ETF	28.1	28.16	28.08	28.16	10900.0
2010-09-27	AAXJ	ETF	59.93	60.08	59.74	59.8	618700.0
2010-09-27	ACWI	ETF	43.37	43.39	43.11	43.17	220000.0
2010-09-27	ACWX	ETF	41.44	41.44	41.15	41.21	93855.0
2010-09-27	ADRE	ETF	44.21	44.2894	43.86	44.13	370128.0
2010-09-27	AFK	ETF	31.9	31.99	31.6301	31.7	35106.0
2010-09-27	AGG	ETF	108.39	108.58	108.3	108.51	956800.0
2010-09-27	AGQ	ETF	162.72	162.94	160.46	161.96	152950.0
2010-09-27	AGZ	ETF	111.19	111.49	111.19	111.42	10955.0
2010-09-27	AIA	ETF	42.01	42.08	41.85	41.9	8616.0
2010-09-27	AIQ	ETF	22.5	22.85	22.1505	22.55	8701.0
2010-09-27	AIS	ETF	1.43	1.45	1.4	1.41	251605.0
2010-09-27	AIVI	ETF	43.31	43.32	42.99	43.03	23600.0
2010-09-27	AMJ	ETF	33.29	33.38	33.2	33.32	508656.0
2010-09-27	AMLP	ETF	76.75	76.75	76.45	76.6	78660.0
2010-09-27	AOA	ETF	31.5	31.51	31.37	31.4	28200.0
2010-09-27	AOK	ETF	28.44	28.44	28.35	28.38	25312.0
2010-09-27	AOM	ETF	29.08	29.1155	29.0245	29.0599	26743.0
2010-09-27	AOR	ETF	29.99	30.0	29.89	30.0	55081.0
2010-09-27	ARB	ETF	27.04	27.16	26.83	26.97	314154.0
2010-09-27	BAB	ETF	26.72	26.79	26.61	26.79	152170.0
2010-09-27	BAL	ETF	50.19	52.22	49.64	51.78	57689.0
2010-09-27	BALT	ETF	11.48	11.48	11.04	11.13	218094.0
2010-09-27	BBH	ETF	32.4133	32.4133	32.0433	32.0433	28800.0
2010-09-27	BIB	ETF	6.5163	6.52	6.4225	6.4225	16000.0
2010-09-27	BICK	ETF	31.36	31.36	31.13	31.27	19413.0
2010-09-27	BIL	ETF	91.7	91.72	91.7	91.72	283250.0
2010-09-27	BIS	ETF	9577.408	9702.4	9577.408	9702.4	7.0
2010-09-27	BITS	ETF	26.72	27.68	26.64	26.96	1944.0
2010-09-27	BIV	ETF	86.35	86.62	86.33	86.51	179000.0
2010-09-27	BJK	ETF	27.75	27.92	27.65	27.82	14400.0
2010-09-27	BKF	ETF	47.15	47.2495	46.8301	47.025	165796.0
2010-09-27	BLV	ETF	85.31	85.88	85.31	85.72	47800.0
2010-09-27	BMVP	ETF	12.9833	13.0628	12.9833	12.9933	3825.0
2010-09-27	BND	ETF	82.45	82.64	82.38	82.61	785900.0
2010-09-27	BNE	ETF	10.97	11.06	10.96	11.0	502308.0
2010-09-27	BRF	ETF	55.42	55.71	55.26	55.71	324189.0
2010-09-27	BSCE	ETF	20.92	20.93	20.9004	20.916	6678.0
2010-09-27	BSV	ETF	81.67	81.7	81.63	81.7	393700.0
2010-09-27	BTF	ETF	75.99999999999999	76.1	75.75	75.75	3315.6000000000004
2010-09-27	BWX	ETF	29.925	29.995	29.7152	29.87	416072.0
2010-09-27	BWZ	ETF	36.61	36.8	36.5701	36.6056	34544.0
2010-09-27	BZQ	ETF	2952.0	2992.0	2897.6	2928.0	899.0
2010-09-27	CEF	ETF	16.57	16.66	16.4	16.46	685800.0

> showing 50 of 793 rows — these rows as CSV

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