PREVIEW / etf_daily / 2008-12-29

all etf daily files

  file:    by_date/etf_daily/2008/2008-12-29.parquet
  size:    28 KB
  rows:    633

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
2008-12-29	SPY	ETF	87.24	87.33	85.6	86.91	127795900.0
2008-12-29	QQQ	ETF	29.23	29.24	28.46	28.89	52742522.0
2008-12-29	IWM	ETF	47.36	47.58	45.91	46.82	41442100.0
2008-12-29	DIA	ETF	85.27	85.28	83.59	84.91	10387800.0
2008-12-29	GLD	ETF	86.5	87.0	85.95	86.35	9073100.0
2008-12-29	TLT	ETF	121.43	122.01	120.61	120.75	1416000.0
2008-12-29	AAXJ	ETF	33.28	33.28	32.49	32.93	118000.0
2008-12-29	ACWI	ETF	31.41	31.47	30.67	30.99	697100.0
2008-12-29	ACWX	ETF	29.88	29.98	29.26	29.64	221289.0
2008-12-29	ADRE	ETF	25.86	26.6	25.86	26.29	203999.0
2008-12-29	AFK	ETF	21.3	21.3	21.07	21.07	200.0
2008-12-29	AGG	ETF	103.03	104.19	103.03	104.09	614000.0
2008-12-29	AGQ	ETF	61.92	61.92	57.7	58.0	25500.0
2008-12-29	AGZ	ETF	108.68	108.86	108.64	108.64	2193.0
2008-12-29	AIA	ETF	26.2	26.25	24.75	24.86	10292.0
2008-12-29	AIQ	ETF	35.8	36.3	34.85	36.3	22221.0
2008-12-29	AIS	ETF	0.31	0.3313	0.29	0.33	213520.0
2008-12-29	AIVI	ETF	33.94	33.94	32.72	32.74	106900.0
2008-12-29	AOA	ETF	24.99	24.99	23.34	23.45	9000.0
2008-12-29	AOK	ETF	25.57	25.57	25.57	25.57	300.0
2008-12-29	AOM	ETF	25.11	25.11	24.9599	24.96	2875.0
2008-12-29	AOR	ETF	24.4473	25.05	24.2874	24.96	6375.0
2008-12-29	ARB	ETF	12.17	12.17	11.45	11.62	286209.0
2008-12-29	BAL	ETF	27.09	27.2599	27.09	27.2	300.0
2008-12-29	BBH	ETF	56.5767	56.6767	56.0533	56.2	203400.0
2008-12-29	BIL	ETF	91.6	91.64	91.4	91.46	87100.0
2008-12-29	BITS	ETF	17.6	18.6	16.4	17.6	7881.0
2008-12-29	BIV	ETF	79.07	79.91	78.97	79.58	85600.0
2008-12-29	BKF	ETF	24.06	24.3099	23.46	23.69	35466.0
2008-12-29	BLV	ETF	81.02	81.11	80.61	80.7	12700.0
2008-12-29	BMVP	ETF	10.4	10.43	10.25	10.35	58533.0
2008-12-29	BND	ETF	77.96	78.88	77.85	78.72	278100.0
2008-12-29	BNE	ETF	6.07	6.09	4.76	4.94	201525.0
2008-12-29	BSV	ETF	79.45	80.37	79.4	80.22	145100.0
2008-12-29	BTF	ETF	48.05	48.699999999999996	46.15	46.25	11213.0
2008-12-29	BWX	ETF	27.47	27.55	27.26	27.335	308122.0
2008-12-29	CBON	ETF	2.75	3.22	2.654	3.12	45973.0
2008-12-29	CDL	ETF	0.19	0.19	0.15	0.16	1787916.0
2008-12-29	CEF	ETF	10.87	11.23	10.87	11.18	1318900.0
2008-12-29	CGO	ETF	9.43	10.1384	9.25	9.34	32249.0
2008-12-29	CGW	ETF	14.04	14.04	13.27	13.44	178878.0
2008-12-29	CHB	ETF	0.7	0.7	0.64	0.65	306607.0
2008-12-29	CHI	ETF	8.07	8.14	7.85	7.88	308429.0
2008-12-29	CHIC	ETF	6.29	6.4	5.95	6.11	195321.0
2008-12-29	CHW	ETF	5.42	5.5	5.28	5.44	383931.0
2008-12-29	CHY	ETF	8.13	8.13	7.81	7.9	278302.0
2008-12-29	CMF	ETF	50.49	50.585	50.145	50.54	13470.0
2008-12-29	CNXT	ETF	0.67	0.69	0.65	0.66	330619.0
2008-12-29	COW	ETF	33.29	33.8	33.15	33.2352	14114.0
2008-12-29	CPST	ETF	0.9	0.909	0.81	0.86	1981473.0

> showing 50 of 633 rows — these rows as CSV

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