PREVIEW / etf_daily / 2010-09-07

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-07.parquet
  size:    33 KB
  rows:    775

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-07	SPY	ETF	110.37	110.51	109.55	109.64	141973700.0
2010-09-07	QQQ	ETF	45.82	46.03	45.625	45.7	51195142.0
2010-09-07	IWM	ETF	64.13	64.14	62.91	63.11	48881600.0
2010-09-07	DIA	ETF	104.16	104.29	103.41	103.56	4206700.0
2010-09-07	GLD	ETF	122.91	123.06	122.63	122.7	8777500.0
2010-09-07	TLT	ETF	105.09	105.78	104.81	105.7	6018400.0
2010-09-07	AADR	ETF	26.23	26.23	26.23	26.23	100.0
2010-09-07	AAXJ	ETF	56.8	56.81	56.11	56.17	146400.0
2010-09-07	ACWI	ETF	41.32	41.32	40.85	40.86	110600.0
2010-09-07	ACWX	ETF	39.22	39.22	38.81	38.87	653000.0
2010-09-07	ADRE	ETF	42.59	42.59	42.07	42.08	48666.0
2010-09-07	AFK	ETF	30.43	30.48	29.75	29.9	55838.0
2010-09-07	AGG	ETF	108.14	108.43	108.09	108.33	512400.0
2010-09-07	AGQ	ETF	140.78	140.92	137.6	138.38	204900.0
2010-09-07	AGZ	ETF	110.9932	111.15	110.9335	111.15	7697.0
2010-09-07	AIA	ETF	39.83	39.96	39.65	39.65	26761.0
2010-09-07	AIQ	ETF	22.35	22.35	21.6	21.7	28100.0
2010-09-07	AIS	ETF	1.53	1.61	1.49	1.55	621597.0
2010-09-07	AIVI	ETF	40.83	40.97	40.59	40.62	6900.0
2010-09-07	AMJ	ETF	32.69	32.804	32.5105	32.64	458207.0
2010-09-07	AMLP	ETF	75.85	75.85	75.4	75.65	90960.0
2010-09-07	AOA	ETF	30.23	30.23	30.0	30.0	7600.0
2010-09-07	AOK	ETF	27.98	28.03	27.95	28.0032	5562.0
2010-09-07	AOM	ETF	28.59	28.59	28.52	28.55	7084.0
2010-09-07	AOR	ETF	29.09	29.09	29.09	29.09	225.0
2010-09-07	ARB	ETF	27.42	27.49	26.4	26.49	109044.0
2010-09-07	BAB	ETF	26.83	26.84	26.7	26.83	304543.0
2010-09-07	BAL	ETF	44.48	44.99	44.462	44.63	11507.0
2010-09-07	BALT	ETF	11.43	11.43	11.03	11.08	108658.0
2010-09-07	BBH	ETF	30.92	30.9967	30.7167	30.7667	48900.0
2010-09-07	BIB	ETF	5.84	5.84	5.7062	5.7062	12000.0
2010-09-07	BICK	ETF	29.48	29.48	29.19	29.27	7615.0
2010-09-07	BIL	ETF	91.7	91.72	91.7	91.7	105500.0
2010-09-07	BIS	ETF	10892.8	10966.4	10892.8	10966.4	1.25
2010-09-07	BITS	ETF	24.2	25.12	23.88	24.56	1475.0
2010-09-07	BIV	ETF	85.46	85.76	85.34	85.76	284700.0
2010-09-07	BJK	ETF	26.26	26.28	26.13	26.17	5900.0
2010-09-07	BKF	ETF	44.79	45.0	44.46	44.54	104444.0
2010-09-07	BLV	ETF	85.25	85.78	85.09	85.73	56900.0
2010-09-07	BMVP	ETF	12.52	12.52	12.43	12.43	6501.0
2010-09-07	BND	ETF	82.29	82.46	82.18	82.44	751900.0
2010-09-07	BNE	ETF	10.81	10.87	10.69	10.82	774425.0
2010-09-07	BNO	ETF	25.8	26.215	25.8	26.0	14000.0
2010-09-07	BRF	ETF	52.78	53.096	52.31	52.4	428668.0
2010-09-07	BSCE	ETF	20.8	20.8	20.785	20.8	7800.0
2010-09-07	BSV	ETF	81.46	81.47	81.37	81.38	573800.0
2010-09-07	BTF	ETF	71.9	72.24999999999999	71.9	72.0	7374.400000000001
2010-09-07	BWX	ETF	28.935	28.935	28.765	28.885	279412.0
2010-09-07	BWZ	ETF	35.2901	35.31	35.15	35.288	39429.0
2010-09-07	BZQ	ETF	3284.8	3356.8	3272.0	3353.6	765.0

> showing 50 of 775 rows — these rows as CSV

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