PREVIEW / etf_daily / 2009-01-02

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-02.parquet
  size:    28 KB
  rows:    627

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
2009-01-02	SPY	ETF	90.44	93.44	89.85	92.96	227566300.0
2009-01-02	QQQ	ETF	29.77	31.13	29.69	31.03	107920235.0
2009-01-02	IWM	ETF	49.74	50.72	49.22	50.22	51588500.0
2009-01-02	DIA	ETF	87.95	90.62	87.57	90.2	24558800.0
2009-01-02	GLD	ETF	85.93	86.61	85.84	86.23	6411600.0
2009-01-02	TLT	ETF	120.05	120.45	116.35	116.35	3464200.0
2009-01-02	AAXJ	ETF	34.37	35.3	34.21	35.15	45600.0
2009-01-02	ACWI	ETF	32.45	33.21	32.29	33.13	96000.0
2009-01-02	ACWX	ETF	30.55	31.36	30.55	31.21	184187.0
2009-01-02	ADRE	ETF	27.83	28.87	27.5	28.75	163591.0
2009-01-02	AFK	ETF	21.3	22.064	21.3	22.064	400.0
2009-01-02	AGG	ETF	103.75	104.39	103.5	103.55	484600.0
2009-01-02	AGQ	ETF	61.96	65.7	61.58	65.54	22400.0
2009-01-02	AGZ	ETF	107.54	107.54	107.24	107.5	2700.0
2009-01-02	AIA	ETF	25.96	26.79	25.96	26.7899	7616.0
2009-01-02	AIQ	ETF	39.75	40.5	39.29	40.3	103060.0
2009-01-02	AIS	ETF	0.37	0.42	0.3301	0.41	105516.0
2009-01-02	AIVI	ETF	33.74	34.77	33.74	34.71	13900.0
2009-01-02	AOA	ETF	24.3	24.8	24.3	24.76	600.0
2009-01-02	AOK	ETF	25.72	26.037	25.72	25.79	818.0
2009-01-02	AOM	ETF	25.54	25.58	25.53	25.58	13507.0
2009-01-02	AOR	ETF	24.95	25.2	24.95	25.2	1169.0
2009-01-02	ARB	ETF	13.24	13.85	13.14	13.78	512920.0
2009-01-02	BAL	ETF	28.04	28.73	28.04	28.664	5365.0
2009-01-02	BBH	ETF	57.4833	57.98	57.0033	57.98	119100.0
2009-01-02	BIL	ETF	91.7	91.78	91.6	91.6	110100.0
2009-01-02	BITS	ETF	19.76	19.76	18.6	19.56	3014.0
2009-01-02	BIV	ETF	78.87	79.56	78.36	78.36	73700.0
2009-01-02	BJK	ETF	18.21	18.9	18.2	18.32	1200.0
2009-01-02	BKF	ETF	25.33	26.48	25.2482	26.47	37585.0
2009-01-02	BLV	ETF	80.27	80.71	78.2	78.43	40100.0
2009-01-02	BMVP	ETF	10.877	11.093	10.814	11.07	25165.0
2009-01-02	BND	ETF	78.42	79.16	78.37	78.68	269800.0
2009-01-02	BNE	ETF	5.9	6.67	5.9	6.57	141545.0
2009-01-02	BSV	ETF	80.24	80.26	79.25	79.25	82200.0
2009-01-02	BTF	ETF	49.3	51.5	49.24999999999999	51.2425	10611.2
2009-01-02	BWX	ETF	27.175	27.2095	26.925	26.975	371066.0
2009-01-02	CBON	ETF	3.43	3.465	2.98	3.0	48348.0
2009-01-02	CDL	ETF	0.17	0.19	0.16	0.19	535102.0
2009-01-02	CEF	ETF	11.19	11.3	10.79	10.92	834500.0
2009-01-02	CGO	ETF	9.64	10.16	9.54	10.148	14248.0
2009-01-02	CGW	ETF	14.45	14.72	13.85	14.59	59893.0
2009-01-02	CHB	ETF	0.6	0.71	0.6	0.63	586418.0
2009-01-02	CHI	ETF	8.45	9.0	8.4	8.9	278073.0
2009-01-02	CHIC	ETF	6.49	6.89	6.27	6.74	345018.0
2009-01-02	CHW	ETF	5.8	6.1	5.8	6.1	170805.0
2009-01-02	CHY	ETF	8.69	8.836	8.6	8.76	331548.0
2009-01-02	CMF	ETF	50.64	50.73	50.09	50.7	55768.0
2009-01-02	CNXT	ETF	0.7	0.7988	0.7	0.76	323485.0
2009-01-02	COW	ETF	34.25	34.99	33.95	34.8	19377.0

> showing 50 of 627 rows — these rows as CSV

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