PREVIEW / etf_daily / 2009-09-28

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-28.parquet
  size:    30 KB
  rows:    678

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-09-28	SPY	ETF	104.85	106.55	104.83	106.32	118285800.0
2009-09-28	QQQ	ETF	41.92	42.66	41.89	42.41	84484131.0
2009-09-28	IWM	ETF	60.22	61.58	60.04	61.26	47925100.0
2009-09-28	DIA	ETF	97.01	98.24	96.95	97.84	6393200.0
2009-09-28	GLD	ETF	97.21	97.81	97.0	97.05	7791200.0
2009-09-28	TLT	ETF	98.32	98.93	98.11	98.84	4263300.0
2009-09-28	AAXJ	ETF	51.59	52.17	51.38	51.76	82900.0
2009-09-28	ACWI	ETF	40.31	40.95	40.3	40.77	58700.0
2009-09-28	ACWX	ETF	39.34	40.03	39.29	39.72	26127.0
2009-09-28	ADRE	ETF	40.03	40.76	39.978	40.53	107635.0
2009-09-28	AFK	ETF	28.5	29.35	28.28	28.83	17907.0
2009-09-28	AGG	ETF	104.73	104.83	104.59	104.78	610400.0
2009-09-28	AGQ	ETF	106.16	109.98	106.06	108.3	147300.0
2009-09-28	AGZ	ETF	108.63	108.63	108.3001	108.593	9629.0
2009-09-28	AIA	ETF	37.62	38.37	37.62	38.1835	20142.0
2009-09-28	AIQ	ETF	26.9	28.1	26.65	27.75	46617.0
2009-09-28	AIS	ETF	1.11	1.14	1.07	1.1	319085.0
2009-09-28	AIVI	ETF	41.96	42.76	41.96	42.58	32000.0
2009-09-28	AMJ	ETF	24.79	24.95	24.7	24.924	266061.0
2009-09-28	AOA	ETF	28.72	29.09	28.72	29.06	8600.0
2009-09-28	AOK	ETF	27.25	27.2887	26.98	27.18	6778.0
2009-09-28	AOM	ETF	27.8101	27.82	27.7701	27.7701	1448.0
2009-09-28	AOR	ETF	28.15	28.47	28.15	28.3132	8607.0
2009-09-28	ARB	ETF	19.85	20.87	19.72	20.75	317989.0
2009-09-28	BAL	ETF	32.35	32.67	31.95	32.6	18790.0
2009-09-28	BBH	ETF	33.6367	34.4833	33.6367	34.1567	357300.0
2009-09-28	BIL	ETF	91.72	91.76	91.7	91.76	198050.0
2009-09-28	BITS	ETF	22.0	22.0	21.276	21.84	382.0
2009-09-28	BIV	ETF	80.36	80.45	80.13	80.37	144000.0
2009-09-28	BJK	ETF	26.0	26.15	25.65	25.76	21100.0
2009-09-28	BKF	ETF	40.79	41.75	40.79	41.59	347463.0
2009-09-28	BLV	ETF	79.98	80.26	79.68	80.19	84300.0
2009-09-28	BMVP	ETF	11.9835	12.0953	11.9835	12.0567	9672.0
2009-09-28	BND	ETF	79.41	79.51	79.26	79.5	463800.0
2009-09-28	BNE	ETF	7.19	7.62	7.01	7.6	180935.0
2009-09-28	BOSS	ETF	20.51	20.53	20.12	20.51	100.0
2009-09-28	BRF	ETF	39.23	39.8	39.23	39.71	114125.0
2009-09-28	BSV	ETF	80.0	80.08	79.81	79.96	312100.0
2009-09-28	BTF	ETF	60.7	60.7	60.05	60.49999999999999	12886.2
2009-09-28	BWX	ETF	29.185	29.215	29.085	29.195	249234.0
2009-09-28	BWZ	ETF	37.29	37.3	37.16	37.26	19461.0
2009-09-28	BZQ	ETF	5676.8	5676.8	5478.4	5515.2	9.5
2009-09-28	CEF	ETF	12.7	13.06	12.59	12.99	1657700.0
2009-09-28	CEW	ETF	21.7	21.76	21.62	21.7	32069.0
2009-09-28	CGO	ETF	13.98	14.0	13.83	13.98	16266.0
2009-09-28	CGW	ETF	17.55	17.9	17.47	17.87	69273.0
2009-09-28	CHB	ETF	0.515	0.5301	0.49	0.5	2019567.0
2009-09-28	CHI	ETF	11.58	11.87	11.58	11.86	112629.0
2009-09-28	CHIC	ETF	17.48	17.5	17.47	17.48	203767.0
2009-09-28	CHW	ETF	7.63	7.77	7.61	7.72	148097.0

> showing 50 of 678 rows — these rows as CSV

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