PREVIEW / etf_daily / 2009-02-26

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-26.parquet
  size:    28 KB
  rows:    634

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-02-26	SPY	ETF	77.82	79.67	75.53	75.62	363353900.0
2009-02-26	QQQ	ETF	28.78	28.95	27.7	27.79	211282792.0
2009-02-26	IWM	ETF	40.59	40.75	39.21	39.42	68400200.0
2009-02-26	DIA	ETF	73.48	74.07	71.76	71.84	31367300.0
2009-02-26	GLD	ETF	92.71	93.14	91.57	93.06	28789800.0
2009-02-26	TLT	ETF	102.87	103.26	101.98	102.47	2611100.0
2009-02-26	AAXJ	ETF	29.19	29.47	28.82	28.82	9600.0
2009-02-26	ACWI	ETF	26.87	27.07	26.23	26.23	105700.0
2009-02-26	ACWX	ETF	24.62	24.89	24.14	24.14	85208.0
2009-02-26	ADRE	ETF	25.22	25.6	24.84	24.84	269428.0
2009-02-26	AFK	ETF	18.82	18.82	18.71	18.71	200.0
2009-02-26	AGG	ETF	100.77	101.1	100.61	100.68	509300.0
2009-02-26	AGQ	ETF	85.86	85.86	79.28	81.66	145700.0
2009-02-26	AGZ	ETF	107.27	107.52	106.85	106.906	8491.0
2009-02-26	AIA	ETF	22.42	22.65	22.09	22.21	9034.0
2009-02-26	AIQ	ETF	45.7	46.05	42.3	42.5	64845.0
2009-02-26	AIS	ETF	0.4	0.43	0.37	0.42	186838.0
2009-02-26	AIVI	ETF	26.8	27.08	26.25	26.29	19900.0
2009-02-26	AOA	ETF	20.94	20.94	20.16	20.5	11000.0
2009-02-26	AOK	ETF	24.35	24.38	24.33	24.33	3863.0
2009-02-26	AOM	ETF	24.36	24.36	22.86	23.22	37665.0
2009-02-26	AOR	ETF	22.89	22.89	22.01	22.0106	2020.0
2009-02-26	ARB	ETF	12.96	13.17	12.59	12.71	314005.0
2009-02-26	BAL	ETF	24.98	25.27	24.98	25.27	634.0
2009-02-26	BBH	ETF	58.6267	58.65	56.2733	56.3867	783300.0
2009-02-26	BIL	ETF	91.74	91.74	91.68	91.68	201300.0
2009-02-26	BITS	ETF	17.4	18.04	17.0	17.4	1478.0
2009-02-26	BIV	ETF	75.94	76.02	75.72	75.92	144300.0
2009-02-26	BJK	ETF	14.16	14.79	14.0	14.66	1500.0
2009-02-26	BKF	ETF	22.1	22.57	21.98	21.99	37084.0
2009-02-26	BLV	ETF	73.34	73.34	72.86	72.86	8400.0
2009-02-26	BMVP	ETF	9.56	9.603	9.344	9.357	57483.0
2009-02-26	BND	ETF	76.51	76.59	76.33	76.51	612000.0
2009-02-26	BNE	ETF	1.84	1.87	1.76	1.82	305889.0
2009-02-26	BOSS	ETF	9.8	10.1	9.8	10.1	100.0
2009-02-26	BSV	ETF	78.63	78.63	78.3	78.47	179600.0
2009-02-26	BTF	ETF	39.24999999999999	40.25	38.8005	40.0	22327.2
2009-02-26	BWX	ETF	24.625	24.7	24.54	24.595	194382.0
2009-02-26	BWZ	ETF	31.76	31.76	31.68	31.72	3380.0
2009-02-26	CBON	ETF	1.2301	1.2301	1.1	1.1	34946.0
2009-02-26	CDL	ETF	0.13	0.16	0.13	0.14	656631.0
2009-02-26	CEF	ETF	11.87	11.89	11.42	11.8	1969200.0
2009-02-26	CGO	ETF	8.62	8.9	8.62	8.664	15045.0
2009-02-26	CGW	ETF	11.86	12.0	11.5	11.5	47454.0
2009-02-26	CHB	ETF	0.29	0.31	0.28	0.28	497109.0
2009-02-26	CHI	ETF	8.39	8.39	8.01	8.07	160952.0
2009-02-26	CHIC	ETF	5.42	5.47	5.14	5.29	132144.0
2009-02-26	CHW	ETF	5.34	5.34	5.08	5.12	107235.0
2009-02-26	CHY	ETF	8.27	8.37	7.93	8.22	315378.0
2009-02-26	CMF	ETF	51.2	51.61	51.075	51.61	7354.0

> showing 50 of 634 rows — these rows as CSV

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