PREVIEW / etf_daily / 2010-11-08

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-08.parquet
  size:    34 KB
  rows:    800

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-11-08	SPY	ETF	122.34	122.69	121.94	122.49	156107100.0
2010-11-08	QQQ	ETF	53.57	53.83	53.4499	53.7375	39623425.0
2010-11-08	IWM	ETF	73.53	73.91	73.12	73.71	31656700.0
2010-11-08	DIA	ETF	114.14	114.35	113.78	114.22	4081700.0
2010-11-08	GLD	ETF	135.92	137.79	135.53	137.78	17367400.0
2010-11-08	TLT	ETF	98.59	98.92	97.82	98.42	6795200.0
2010-11-08	AADR	ETF	27.97	29.21	27.97	29.21	2300.0
2010-11-08	AAXJ	ETF	65.48	65.5	65.25	65.5	1198000.0
2010-11-08	ACWI	ETF	46.42	46.42	46.12	46.33	790200.0
2010-11-08	ACWX	ETF	44.31	44.48	44.1699	44.42	39498.0
2010-11-08	ADRE	ETF	48.14	48.38	47.97	48.37	54163.0
2010-11-08	AFK	ETF	34.38	34.52	34.24	34.5	39366.0
2010-11-08	AGG	ETF	108.61	108.75	108.54	108.57	370500.0
2010-11-08	AGQ	ETF	247.06	264.74	244.0	264.74	614150.0
2010-11-08	AGZ	ETF	111.59	111.59	111.468	111.49	17536.0
2010-11-08	AIA	ETF	46.58	46.62	46.329	46.62	43288.0
2010-11-08	AIQ	ETF	21.35	21.7	21.15	21.25	27386.0
2010-11-08	AIS	ETF	1.55	1.58	1.48	1.57	767736.0
2010-11-08	AIVI	ETF	45.97	46.16	45.71	46.03	72900.0
2010-11-08	AMJ	ETF	36.57	36.6	36.4	36.6	1200804.0
2010-11-08	AMLP	ETF	79.9	79.95	79.5	79.75	270300.0
2010-11-08	AOA	ETF	33.64	33.75	33.62	33.71	7700.0
2010-11-08	AOK	ETF	29.07	29.07	29.01	29.04	11624.0
2010-11-08	AOM	ETF	30.08	30.106	30.01	30.106	9981.0
2010-11-08	AOR	ETF	31.37	31.41	31.3377	31.4	4809.0
2010-11-08	ARB	ETF	26.84	27.26	26.6425	26.93	138540.0
2010-11-08	BAB	ETF	26.04	26.11	26.0	26.1	885003.0
2010-11-08	BAL	ETF	72.5	73.47	72.0201	73.4	85204.0
2010-11-08	BALT	ETF	12.05	12.38	12.02	12.35	222069.0
2010-11-08	BBH	ETF	33.2467	33.34	33.12	33.2967	39900.0
2010-11-08	BIB	ETF	6.6875	6.6909	6.6792	6.6909	25008.0
2010-11-08	BICK	ETF	34.38	34.38	34.05	34.17	40107.0
2010-11-08	BIL	ETF	91.7	91.72	91.7	91.7	198350.0
2010-11-08	BIS	ETF	9187.2	9265.6	9187.2	9243.2	13.75
2010-11-08	BITS	ETF	28.84	28.84	28.2	28.64	937.0
2010-11-08	BIV	ETF	87.38	87.43	87.15	87.23	127700.0
2010-11-08	BJK	ETF	32.6	32.84	32.34	32.75	11400.0
2010-11-08	BKF	ETF	51.63	51.75	51.32	51.73	137768.0
2010-11-08	BLV	ETF	82.92	83.16	82.52	82.71	48700.0
2010-11-08	BMVP	ETF	14.27	14.355	14.267	14.333	7163.0
2010-11-08	BND	ETF	82.67	82.72	82.61	82.63	556900.0
2010-11-08	BNE	ETF	11.33	11.35	11.33	11.35	176981.0
2010-11-08	BRF	ETF	62.65	62.73	62.2	62.69	518793.0
2010-11-08	BSCE	ETF	21.2	21.2	21.0492	21.07	20233.0
2010-11-08	BSV	ETF	81.88	81.92	81.85	81.89	373400.0
2010-11-08	BTF	ETF	80.35	80.5	80.1	80.5	4466.2
2010-11-08	BWX	ETF	30.645	30.79	30.6	30.685	253168.0
2010-11-08	BWZ	ETF	37.9	38.07	37.83	37.95	20805.0
2010-11-08	BZQ	ETF	2456.0	2464.0	2412.8	2427.2	653.0
2010-11-08	CEF	ETF	18.77	19.18	18.72	19.04	1837500.0

> showing 50 of 800 rows — these rows as CSV

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