PREVIEW / etf_daily / 2009-04-13

all etf daily files

  file:    by_date/etf_daily/2009/2009-04-13.parquet
  size:    28 KB
  rows:    643

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-04-13	SPY	ETF	84.92	86.54	84.58	85.83	224847500.0
2009-04-13	QQQ	ETF	32.8	33.07	32.53	32.89	119310408.0
2009-04-13	IWM	ETF	46.26	47.0	45.67	46.66	58557300.0
2009-04-13	DIA	ETF	80.03	81.18	79.69	80.55	11991300.0
2009-04-13	GLD	ETF	88.03	88.45	87.6	87.88	7283700.0
2009-04-13	TLT	ETF	102.96	103.51	102.93	103.29	946600.0
2009-04-13	AAXJ	ETF	36.59	37.49	36.59	37.08	86200.0
2009-04-13	ACWI	ETF	31.13	31.23	30.55	31.21	35400.0
2009-04-13	ACWX	ETF	28.34	29.54	28.34	29.27	16071.0
2009-04-13	ADRE	ETF	30.83	31.0	30.33	30.87	201770.0
2009-04-13	AFK	ETF	20.68	20.74	20.68	20.74	300.0
2009-04-13	AGG	ETF	100.82	101.15	100.33	101.15	475800.0
2009-04-13	AGQ	ETF	75.4	76.14	74.38	74.68	73050.0
2009-04-13	AGZ	ETF	108.51	108.55	107.7668	108.51	7238.0
2009-04-13	AIA	ETF	28.0	28.65	27.7	28.13	45585.0
2009-04-13	AIQ	ETF	38.55	38.9	37.5	38.45	40461.0
2009-04-13	AIS	ETF	0.45	0.45	0.42	0.43	52558.0
2009-04-13	AIVI	ETF	30.67	31.34	30.56	31.1	36800.0
2009-04-13	AMJ	ETF	19.85	20.15	19.85	20.15	5000.0
2009-04-13	AOA	ETF	23.03	23.41	23.0	23.37	11300.0
2009-04-13	AOK	ETF	25.79	25.79	25.0008	25.29	7913.0
2009-04-13	AOM	ETF	24.649	24.7572	24.5802	24.73	11425.0
2009-04-13	AOR	ETF	23.9894	24.24	23.9502	24.13	6322.0
2009-04-13	ARB	ETF	16.95	17.11	16.59	16.99	312318.0
2009-04-13	BAL	ETF	27.6	27.6	26.98	27.592	5600.0
2009-04-13	BBH	ETF	30.1833	31.07	30.05	30.1033	760200.0
2009-04-13	BIL	ETF	91.68	91.74	91.68	91.74	243500.0
2009-04-13	BITS	ETF	18.7204	18.76	17.6	17.84	3337.0
2009-04-13	BIV	ETF	76.14	76.43	76.04	76.43	80300.0
2009-04-13	BJK	ETF	16.92	18.86	16.92	17.58	4100.0
2009-04-13	BKF	ETF	29.6	29.6	28.6276	29.24	62331.0
2009-04-13	BLV	ETF	72.64	73.31	72.64	72.82	18500.0
2009-04-13	BMVP	ETF	10.37	10.52	10.31	10.49	12539.0
2009-04-13	BND	ETF	77.03	77.17	76.71	77.09	376700.0
2009-04-13	BNE	ETF	3.88	4.24	3.48	4.13	285531.0
2009-04-13	BSV	ETF	78.61	78.75	78.45	78.67	260300.0
2009-04-13	BTF	ETF	45.9	46.39999999999999	45.49999999999999	45.9	8030.200000000001
2009-04-13	BWX	ETF	25.55	25.755	25.5	25.755	215152.0
2009-04-13	BWZ	ETF	33.01	33.01	33.0	33.0	540.0
2009-04-13	CBON	ETF	2.49	2.62	2.3	2.47	32776.0
2009-04-13	CEF	ETF	11.05	11.21	11.01	11.07	1638100.0
2009-04-13	CGO	ETF	9.37	9.54	9.36	9.53	6176.0
2009-04-13	CGW	ETF	13.13	13.17	12.884	13.05	21993.0
2009-04-13	CHB	ETF	0.51	0.57	0.5	0.57	871293.0
2009-04-13	CHI	ETF	8.85	9.12	8.6	9.04	221221.0
2009-04-13	CHIC	ETF	10.25	11.46	10.14	11.21	636192.0
2009-04-13	CHW	ETF	5.99	6.0497	5.85	6.0	154424.0
2009-04-13	CHY	ETF	8.76	8.88	8.6	8.88	164637.0
2009-04-13	CMF	ETF	51.75	52.01	51.75	51.75	13358.0
2009-04-13	CNXT	ETF	0.73	0.73	0.7	0.72	199432.0

> showing 50 of 643 rows — these rows as CSV

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