PREVIEW / etf_daily / 2009-06-23

all etf daily files

  file:    by_date/etf_daily/2009/2009-06-23.parquet
  size:    29 KB
  rows:    660

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-06-23	SPY	ETF	89.47	89.88	88.85	89.35	188309800.0
2009-06-23	QQQ	ETF	35.2	35.26	34.77	35.0	114903026.0
2009-06-23	IWM	ETF	49.74	49.94	49.02	49.09	40810600.0
2009-06-23	DIA	ETF	83.42	83.71	82.85	83.18	12151100.0
2009-06-23	GLD	ETF	90.66	91.03	89.95	90.92	11958500.0
2009-06-23	TLT	ETF	92.77	93.81	92.58	93.67	5356900.0
2009-06-23	AAXJ	ETF	42.04	42.42	41.46	42.09	212000.0
2009-06-23	ACWI	ETF	33.58	33.69	33.16	33.58	166400.0
2009-06-23	ACWX	ETF	32.26	32.44	31.96	32.22	32568.0
2009-06-23	ADRE	ETF	32.8	33.13	32.46	33.0599	177733.0
2009-06-23	AFK	ETF	26.03	26.77	25.6	25.83	16536.0
2009-06-23	AGG	ETF	101.44	101.8	101.29	101.72	524300.0
2009-06-23	AGQ	ETF	84.58	85.04	81.94	84.24	90000.0
2009-06-23	AGZ	ETF	106.42	107.13	106.42	107.1	5758.0
2009-06-23	AIA	ETF	30.47	30.85	30.29	30.83	29857.0
2009-06-23	AIQ	ETF	36.85	37.0	35.95	36.8	65367.0
2009-06-23	AIS	ETF	0.71	0.72	0.671	0.7	44835.0
2009-06-23	AIVI	ETF	33.93	34.55	32.99	34.03	13000.0
2009-06-23	AMJ	ETF	21.41	21.52	21.08	21.1199	66322.0
2009-06-23	AOA	ETF	24.64	24.72	24.5	24.68	14200.0
2009-06-23	AOK	ETF	25.59	25.59	25.5761	25.58	1267.0
2009-06-23	AOM	ETF	25.89	25.89	25.02	25.44	6418.0
2009-06-23	AOR	ETF	24.95	25.22	24.95	25.19	11237.0
2009-06-23	ARB	ETF	16.63	16.63	15.74	15.79	325684.0
2009-06-23	BAL	ETF	28.81	28.81	28.5601	28.5601	800.0
2009-06-23	BBH	ETF	30.6033	30.8367	30.5367	30.67	786600.0
2009-06-23	BIL	ETF	91.76	91.76	91.74	91.76	242400.0
2009-06-23	BITS	ETF	18.16	19.44	18.12	18.64	2162.0
2009-06-23	BIV	ETF	76.38	76.74	76.24	76.67	83100.0
2009-06-23	BJK	ETF	20.1	20.7	20.03	20.04	11200.0
2009-06-23	BKF	ETF	33.32	35.38	32.84	33.48	852855.0
2009-06-23	BLV	ETF	73.66	74.28	73.45	74.0	36300.0
2009-06-23	BMVP	ETF	10.633	10.655	10.597	10.655	21226.0
2009-06-23	BND	ETF	77.0	77.29	76.95	77.28	333000.0
2009-06-23	BNE	ETF	6.1	6.54	6.1	6.28	146344.0
2009-06-23	BOSS	ETF	15.1	15.1	15.0	15.0	100.0
2009-06-23	BRF	ETF	27.39	27.39	25.9	26.64	62752.0
2009-06-23	BSV	ETF	78.81	79.03	78.77	78.84	372000.0
2009-06-23	BTF	ETF	45.949999999999996	45.99999999999999	45.49	45.75	7503.200000000001
2009-06-23	BWX	ETF	27.035	27.215	26.925	27.14	236822.0
2009-06-23	BWZ	ETF	35.0125	35.27	35.0	35.222	2541.0
2009-06-23	BZQ	ETF	10532.8	10641.6	10532.8	10563.2	8.75
2009-06-23	CBON	ETF	1.43	1.43	1.16	1.16	7350.0
2009-06-23	CEF	ETF	11.81	11.87	11.6	11.76	749000.0
2009-06-23	CEW	ETF	20.58	20.765	20.48	20.566	25231.0
2009-06-23	CGO	ETF	10.81	11.05	10.75	11.0	49225.0
2009-06-23	CGW	ETF	14.9	15.08	14.82	14.93	124308.0
2009-06-23	CHB	ETF	0.35	0.38	0.3303	0.38	357695.0
2009-06-23	CHI	ETF	10.31	10.31	9.95	10.14	158931.0
2009-06-23	CHIC	ETF	11.79	12.28	11.56	11.82	171365.0

> showing 50 of 660 rows — these rows as CSV

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