PREVIEW / etf_daily / 2009-03-26

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-26.parquet
  size:    28 KB
  rows:    647

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-03-26	SPY	ETF	82.25	83.3	81.32	83.11	422025200.0
2009-03-26	QQQ	ETF	30.88	31.46	30.417	31.41	182459446.0
2009-03-26	IWM	ETF	43.32	44.47	42.87	44.38	111103100.0
2009-03-26	DIA	ETF	78.18	79.3	77.52	79.1	29403800.0
2009-03-26	GLD	ETF	92.72	92.72	91.84	91.93	12365300.0
2009-03-26	TLT	ETF	102.44	104.06	102.16	103.79	2385300.0
2009-03-26	AAXJ	ETF	34.31	35.19	34.31	35.19	71000.0
2009-03-26	ACWI	ETF	29.45	29.84	29.24	29.8	111700.0
2009-03-26	ACWX	ETF	27.81	28.02	27.568	27.94	68843.0
2009-03-26	ADRE	ETF	29.0	29.29	28.78	29.1	198820.0
2009-03-26	AFK	ETF	21.28	21.28	20.35	20.55	1300.0
2009-03-26	AGG	ETF	100.38	100.47	100.05	100.4	1187900.0
2009-03-26	AGQ	ETF	86.98	88.1	85.16	85.16	55500.0
2009-03-26	AGZ	ETF	107.82	108.02	107.55	107.92	11276.0
2009-03-26	AIA	ETF	26.44	26.87	26.44	26.86	16589.0
2009-03-26	AIQ	ETF	35.25	36.55	34.425	36.55	33360.0
2009-03-26	AIS	ETF	0.414	0.45	0.41	0.45	196727.0
2009-03-26	AIVI	ETF	29.31	29.76	29.11	29.52	18700.0
2009-03-26	AOA	ETF	22.28	22.54	22.28	22.46	2500.0
2009-03-26	AOK	ETF	25.19	25.19	24.9194	25.08	2908.0
2009-03-26	AOM	ETF	24.07	24.24	24.07	24.24	2690.0
2009-03-26	AOR	ETF	23.3561	23.59	23.2961	23.54	5470.0
2009-03-26	ARB	ETF	13.78	14.0	13.48	13.81	215489.0
2009-03-26	BAL	ETF	25.57	25.57	25.25	25.25	200.0
2009-03-26	BBH	ETF	57.8233	58.2233	57.55	58.0833	212700.0
2009-03-26	BIL	ETF	91.72	91.78	91.72	91.76	464750.0
2009-03-26	BITS	ETF	17.64	18.0	17.08	17.64	1966.0
2009-03-26	BIV	ETF	75.88	76.35	75.56	76.33	40800.0
2009-03-26	BJK	ETF	17.44	17.44	15.35	16.37	17600.0
2009-03-26	BKF	ETF	26.95	26.95	25.89	26.66	33354.0
2009-03-26	BLV	ETF	72.5	73.48	72.03	73.0	14400.0
2009-03-26	BMVP	ETF	10.087	10.202	10.027	10.18	40632.0
2009-03-26	BND	ETF	76.62	76.92	76.55	76.78	302200.0
2009-03-26	BNE	ETF	3.57	3.95	3.57	3.83	203037.0
2009-03-26	BSV	ETF	78.32	78.44	78.15	78.27	430200.0
2009-03-26	BTF	ETF	40.199999999999996	41.74999999999999	40.199999999999996	41.3	7154.8
2009-03-26	BWX	ETF	25.94	25.9675	25.8076	25.86	187328.0
2009-03-26	BWZ	ETF	33.22	33.22	33.18	33.19	1413.0
2009-03-26	CBON	ETF	1.94	1.94	1.3419	1.43	25127.0
2009-03-26	CEF	ETF	12.48	12.53	12.07	12.13	1140200.0
2009-03-26	CGO	ETF	9.26	9.49	9.25	9.37	18475.0
2009-03-26	CGW	ETF	12.38	12.55	12.28	12.47	108547.0
2009-03-26	CHB	ETF	0.8032	0.84	0.53	0.63	3587788.0
2009-03-26	CHI	ETF	8.61	8.77	8.53	8.72	119998.0
2009-03-26	CHIC	ETF	7.56	8.27	7.32	8.0	351794.0
2009-03-26	CHW	ETF	5.67	5.6894	5.51	5.65	150337.0
2009-03-26	CHY	ETF	8.24	8.42	8.24	8.37	164322.0
2009-03-26	CMF	ETF	52.0	52.155	51.81	51.825	12828.0
2009-03-26	CNXT	ETF	0.7	0.73	0.6802	0.71	450156.0
2009-03-26	COW	ETF	31.06	31.12	30.75	30.88	10880.0

> showing 50 of 647 rows — these rows as CSV

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