PREVIEW / etf_daily / 2010-01-08

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-08.parquet
  size:    31 KB
  rows:    711

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-01-08	SPY	ETF	113.89	114.62	113.66	114.57	126402800.0
2010-01-08	QQQ	ETF	46.04	46.55	45.93	46.55	88886598.0
2010-01-08	IWM	ETF	63.94	64.52	63.8	64.52	48811500.0
2010-01-08	DIA	ETF	105.67	106.11	105.44	106.11	4912000.0
2010-01-08	GLD	ETF	111.52	111.58	110.26	111.37	15894600.0
2010-01-08	TLT	ETF	89.51	89.56	88.76	89.29	2910700.0
2010-01-08	AAXJ	ETF	57.53	57.89	57.35	57.71	129100.0
2010-01-08	ACWI	ETF	43.54	43.7	43.27	43.57	275100.0
2010-01-08	ACWX	ETF	42.24	42.42	42.09	42.38	40213.0
2010-01-08	ADRE	ETF	45.52	45.6581	45.25	45.62	98636.0
2010-01-08	AFK	ETF	29.74	29.74	29.4401	29.55	8714.0
2010-01-08	AGG	ETF	103.87	103.87	103.54	103.66	412300.0
2010-01-08	AGQ	ETF	134.36	134.9	131.74	134.64	143250.0
2010-01-08	AGZ	ETF	107.995	108.03	107.77	108.01	9983.0
2010-01-08	AIA	ETF	40.88	41.26	40.88	41.23	34694.0
2010-01-08	AIQ	ETF	27.15	27.15	26.25	26.5	30490.0
2010-01-08	AIS	ETF	1.17	1.28	1.07	1.22	2212712.0
2010-01-08	AIVI	ETF	44.2	44.74	44.2	44.74	20700.0
2010-01-08	AMJ	ETF	29.3	29.71	29.1593	29.71	346069.0
2010-01-08	AOA	ETF	30.65	30.82	30.61	30.82	40100.0
2010-01-08	AOK	ETF	27.67	27.67	27.56	27.62	34864.0
2010-01-08	AOM	ETF	28.55	28.62	28.536	28.62	18710.0
2010-01-08	AOR	ETF	29.5	29.55	29.451	29.55	50370.0
2010-01-08	ARB	ETF	27.26	27.7	26.675	26.96	428646.0
2010-01-08	BAB	ETF	24.27	24.27	24.16	24.25	179824.0
2010-01-08	BAL	ETF	35.63	35.835	35.0	35.47	14239.0
2010-01-08	BBH	ETF	32.6767	33.1833	32.6767	33.14	134400.0
2010-01-08	BIL	ETF	91.7	91.7	91.68	91.68	116700.0
2010-01-08	BITS	ETF	32.0	32.0	31.72	31.76	1300.0
2010-01-08	BIV	ETF	79.77	79.79	79.5	79.68	95600.0
2010-01-08	BJK	ETF	24.91	25.06	24.77	25.06	14100.0
2010-01-08	BKF	ETF	47.83	47.83	47.33	47.53	186923.0
2010-01-08	BLV	ETF	76.13	76.43	75.9	76.24	23400.0
2010-01-08	BMVP	ETF	12.8943	12.99	12.8943	12.99	26871.0
2010-01-08	BND	ETF	78.88	78.96	78.76	78.9	1270000.0
2010-01-08	BNE	ETF	7.28	7.34	7.205	7.33	77345.0
2010-01-08	BOSS	ETF	20.75	20.75	20.75	20.75	400.0
2010-01-08	BRF	ETF	50.26	50.6595	49.9	50.43	1274538.0
2010-01-08	BSV	ETF	79.82	79.95	79.75	79.75	360100.0
2010-01-08	BTF	ETF	64.05	64.35	64.0	64.14999999999999	4711.0
2010-01-08	BWX	ETF	28.615	28.635	28.3785	28.58	395592.0
2010-01-08	BWZ	ETF	36.51	36.67	36.35	36.65	55810.0
2010-01-08	BZQ	ETF	3457.6	3468.8	3403.2	3409.6	155.0
2010-01-08	CEF	ETF	14.51	14.6	14.32	14.56	805400.0
2010-01-08	CEW	ETF	22.3	22.38	22.24	22.35	129670.0
2010-01-08	CGO	ETF	14.87	14.95	14.8	14.9	14157.0
2010-01-08	CGW	ETF	18.68	18.94	18.63	18.94	133795.0
2010-01-08	CHI	ETF	12.63	12.74	12.58	12.7	251826.0
2010-01-08	CHIE	ETF	16.05	16.2	16.05	16.2	6300.0
2010-01-08	CHII	ETF	16.2519	16.36	16.19	16.36	19801.0

> showing 50 of 711 rows — these rows as CSV

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