PREVIEW / etf_daily / 2010-01-04

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-04.parquet
  size:    31 KB
  rows:    712

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-04	SPY	ETF	112.37	113.39	111.51	113.33	118944600.0
2010-01-04	QQQ	ETF	46.32	46.485	46.27	46.42	62822798.0
2010-01-04	IWM	ETF	63.29	64.04	63.27	63.98	42863900.0
2010-01-04	DIA	ETF	104.84	105.87	104.76	105.66	8977300.0
2010-01-04	GLD	ETF	109.82	110.14	109.31	109.8	16224100.0
2010-01-04	TLT	ETF	89.84	90.1	89.58	89.81	2829100.0
2010-01-04	AAXJ	ETF	57.0	57.34	56.77	57.17	273900.0
2010-01-04	ACWI	ETF	43.11	43.27	42.84	43.16	365600.0
2010-01-04	ACWX	ETF	41.69	42.1	41.69	42.06	41985.0
2010-01-04	ADRE	ETF	44.67	45.38	44.67	45.38	187425.0
2010-01-04	AFK	ETF	28.9	29.18	28.73	29.028	12929.0
2010-01-04	AGG	ETF	103.27	103.41	103.15	103.31	987900.0
2010-01-04	AGQ	ETF	119.28	121.82	118.78	121.46	186150.0
2010-01-04	AGZ	ETF	107.68	107.73	107.41	107.62	22964.0
2010-01-04	AIA	ETF	40.56	40.99	40.52	40.91	47289.0
2010-01-04	AIQ	ETF	28.65	28.65	27.45	28.25	63333.0
2010-01-04	AIS	ETF	1.13	1.17	1.1102	1.17	569555.0
2010-01-04	AIVI	ETF	44.58	44.98	44.57	44.82	24800.0
2010-01-04	AMJ	ETF	28.74	29.2	28.6999	29.2	251181.0
2010-01-04	AOA	ETF	30.28	30.49	30.28	30.45	57700.0
2010-01-04	AOK	ETF	27.4601	27.5299	27.4601	27.4995	1419.0
2010-01-04	AOM	ETF	28.45	28.45	28.3501	28.45	21338.0
2010-01-04	AOR	ETF	29.27	29.36	29.2	29.2919	22566.0
2010-01-04	ARB	ETF	23.64	25.33	23.54	25.29	545880.0
2010-01-04	BAB	ETF	24.3	24.33	24.2	24.33	58219.0
2010-01-04	BAL	ETF	37.3399	37.4799	37.3	37.4799	1534.0
2010-01-04	BBH	ETF	32.7267	32.8567	32.7033	32.83	252900.0
2010-01-04	BIL	ETF	91.7	91.72	91.68	91.7	192800.0
2010-01-04	BITS	ETF	30.0	31.0	30.0	30.88	12827.0
2010-01-04	BIV	ETF	79.23	79.44	79.13	79.39	136700.0
2010-01-04	BJK	ETF	23.75	24.38	23.75	24.36	61000.0
2010-01-04	BKF	ETF	47.16	47.48	46.28	47.39	590184.0
2010-01-04	BLV	ETF	76.06	76.54	76.0	76.54	231600.0
2010-01-04	BMVP	ETF	12.75	12.9259	12.75	12.9233	22045.0
2010-01-04	BND	ETF	78.6	78.73	78.54	78.68	1098100.0
2010-01-04	BNE	ETF	6.82	7.16	6.79	7.13	237158.0
2010-01-04	BRF	ETF	50.6	50.67	50.03	50.61	449762.0
2010-01-04	BSV	ETF	79.67	79.67	79.51	79.61	613000.0
2010-01-04	BTF	ETF	63.49999999999999	64.19999999999999	63.49999999999999	64.19999999999999	4810.2
2010-01-04	BWX	ETF	28.635	28.7	28.475	28.495	990956.0
2010-01-04	BWZ	ETF	36.71	36.72	36.4	36.72	33773.0
2010-01-04	BZQ	ETF	3564.8	3571.2	3444.8	3464.0	203.0
2010-01-04	CEF	ETF	14.02	14.15	14.0	14.05	1134200.0
2010-01-04	CEW	ETF	22.14	22.22	22.07	22.21	320466.0
2010-01-04	CGO	ETF	14.53	14.55	14.43	14.45	9509.0
2010-01-04	CGW	ETF	18.48	18.76	18.48	18.72	127444.0
2010-01-04	CHI	ETF	12.34	12.46	12.27	12.42	197031.0
2010-01-04	CHIE	ETF	15.5	15.5	15.2301	15.36	11473.0
2010-01-04	CHII	ETF	15.51	15.94	15.51	15.8699	15316.0
2010-01-04	CHIQ	ETF	17.0	17.1	16.89	17.02	205601.0

> showing 50 of 712 rows — these rows as CSV

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