PREVIEW / etf_daily / 2009-03-06

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-06.parquet
  size:    28 KB
  rows:    638

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-06	SPY	ETF	69.4	70.45	67.1	68.92	490470000.0
2009-03-06	QQQ	ETF	26.63	26.81	25.71	26.3	218421537.0
2009-03-06	IWM	ETF	35.4	35.88	34.32	35.2	76036000.0
2009-03-06	DIA	ETF	66.54	67.63	64.78	66.5	35830500.0
2009-03-06	GLD	ETF	91.81	92.95	91.2	92.29	22395300.0
2009-03-06	TLT	ETF	104.26	105.97	104.09	104.26	3125900.0
2009-03-06	AAXJ	ETF	28.3	28.5	27.51	27.94	35100.0
2009-03-06	ACWI	ETF	24.7	24.86	23.77	24.3	176000.0
2009-03-06	ACWX	ETF	23.09	23.24	22.24	22.73	160710.0
2009-03-06	ADRE	ETF	24.0	24.78	23.67	24.19	179252.0
2009-03-06	AFK	ETF	17.65	17.8	17.65	17.71	1400.0
2009-03-06	AGG	ETF	100.56	100.71	100.15	100.7	701200.0
2009-03-06	AGQ	ETF	83.8	85.3	82.98	83.84	92600.0
2009-03-06	AGZ	ETF	107.6155	108.0	107.3102	107.82	21125.0
2009-03-06	AIA	ETF	21.67	22.13	21.23	21.49	41489.0
2009-03-06	AIQ	ETF	38.3	42.4	37.3	37.35	74218.0
2009-03-06	AIS	ETF	0.35	0.38	0.34	0.36	72400.0
2009-03-06	AIVI	ETF	24.09	24.16	23.27	23.8	16300.0
2009-03-06	AOA	ETF	19.34	19.49	19.0	19.0	4200.0
2009-03-06	AOK	ETF	23.8	23.9299	23.8	23.9299	1827.0
2009-03-06	AOM	ETF	22.5194	23.398	22.368	22.62	4653.0
2009-03-06	AOR	ETF	21.24	21.24	20.958	20.958	300.0
2009-03-06	ARB	ETF	12.43	12.78	12.2	12.56	256118.0
2009-03-06	BAL	ETF	23.89	23.89	23.75	23.75	500.0
2009-03-06	BBH	ETF	51.8733	54.5667	51.6667	54.4933	1556700.0
2009-03-06	BIL	ETF	91.72	91.78	91.72	91.76	278150.0
2009-03-06	BITS	ETF	16.48	17.04	16.0	17.0	1948.0
2009-03-06	BIV	ETF	75.24	75.87	75.24	75.63	85600.0
2009-03-06	BJK	ETF	13.23	13.23	12.48	13.0	1300.0
2009-03-06	BKF	ETF	21.15	21.73	20.72	21.24	32122.0
2009-03-06	BLV	ETF	72.87	73.69	72.5	72.61	32500.0
2009-03-06	BMVP	ETF	8.6833	8.8133	8.4733	8.6677	118007.0
2009-03-06	BND	ETF	76.42	76.59	76.2	76.2	690800.0
2009-03-06	BNE	ETF	1.19	1.6	0.85	1.6	446412.0
2009-03-06	BOSS	ETF	9.3	9.3	9.06	9.06	300.0
2009-03-06	BSV	ETF	78.86	78.86	78.2	78.21	250800.0
2009-03-06	BTF	ETF	32.05	32.55	31.299999999999997	32.4	44994.600000000006
2009-03-06	BWX	ETF	24.43	24.565	24.1	24.15	606350.0
2009-03-06	BWZ	ETF	31.35	31.35	31.35	31.35	15000.0
2009-03-06	CBON	ETF	0.77	0.798	0.75	0.798	22427.0
2009-03-06	CEF	ETF	12.0	12.04	11.85	11.97	1650300.0
2009-03-06	CGO	ETF	7.62	8.07	7.54	7.66	51098.0
2009-03-06	CGW	ETF	10.65	11.0899	10.28	10.56	124387.0
2009-03-06	CHB	ETF	0.21	0.2299	0.15	0.2	671896.0
2009-03-06	CHI	ETF	7.06	7.15	6.53	6.81	385022.0
2009-03-06	CHIC	ETF	5.09	5.63	5.0	5.6	443277.0
2009-03-06	CHW	ETF	4.47	4.56	4.06	4.38	381546.0
2009-03-06	CHY	ETF	6.83	6.89	6.41	6.62	804525.0
2009-03-06	CMF	ETF	51.095	51.095	50.405	50.76	21488.0
2009-03-06	CNXT	ETF	0.35	0.35	0.33	0.33	143260.0

> showing 50 of 638 rows — these rows as CSV

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