PREVIEW / etf_daily / 2009-06-04

all etf daily files

  file:    by_date/etf_daily/2009/2009-06-04.parquet
  size:    29 KB
  rows:    655

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-04	SPY	ETF	94.0	94.67	93.3	94.53	210102300.0
2009-06-04	QQQ	ETF	36.4	36.79	36.34	36.74	89280573.0
2009-06-04	IWM	ETF	52.75	53.26	52.09	53.18	42972900.0
2009-06-04	DIA	ETF	86.91	87.66	86.49	87.51	11762200.0
2009-06-04	GLD	ETF	95.24	96.49	95.2	96.23	13629500.0
2009-06-04	TLT	ETF	91.43	91.72	90.24	90.53	5438600.0
2009-06-04	AAXJ	ETF	45.31	45.56	44.88	45.5	617600.0
2009-06-04	ACWI	ETF	35.53	35.8	35.34	35.75	123700.0
2009-06-04	ACWX	ETF	34.47	34.85	34.429	34.78	25331.0
2009-06-04	ADRE	ETF	35.8	36.33	35.62	36.21	135999.0
2009-06-04	AFK	ETF	28.4	28.75	28.0	28.37	209136.0
2009-06-04	AGG	ETF	101.29	101.29	100.54	100.59	591900.0
2009-06-04	AGQ	ETF	105.82	113.16	105.82	111.94	214500.0
2009-06-04	AGZ	ETF	106.26	107.4	106.26	106.762	83066.0
2009-06-04	AIA	ETF	32.9	33.36	32.86	33.34	19736.0
2009-06-04	AIQ	ETF	37.5	37.5	36.75	37.25	58781.0
2009-06-04	AIS	ETF	0.65	0.71	0.6	0.71	775812.0
2009-06-04	AIVI	ETF	36.86	36.94	36.54	36.74	11700.0
2009-06-04	AMJ	ETF	23.05	23.2	22.96	23.15	58442.0
2009-06-04	AOA	ETF	25.85	26.19	25.68	25.96	12100.0
2009-06-04	AOK	ETF	26.5	26.5	25.8655	25.91	29281.0
2009-06-04	AOM	ETF	26.48	26.48	25.9599	25.96	8910.0
2009-06-04	AOR	ETF	26.05	26.39	25.88	25.92	9791.0
2009-06-04	ARB	ETF	20.81	20.81	20.03	20.6	256662.0
2009-06-04	BAL	ETF	31.53	32.08	31.39	32.08	9126.0
2009-06-04	BBH	ETF	31.4067	31.5733	30.9567	31.0333	404700.0
2009-06-04	BIL	ETF	91.72	91.74	91.68	91.72	134000.0
2009-06-04	BITS	ETF	18.76	19.6	18.76	19.6	2079.0
2009-06-04	BIV	ETF	76.54	76.54	75.55	75.82	101500.0
2009-06-04	BJK	ETF	21.55	22.44	21.44	22.16	21900.0
2009-06-04	BKF	ETF	36.56	37.36	36.0	37.15	283056.0
2009-06-04	BLV	ETF	72.29	72.65	71.75	71.99	13600.0
2009-06-04	BMVP	ETF	11.11	11.1571	11.0267	11.14	23440.0
2009-06-04	BND	ETF	77.19	77.19	76.7	76.76	457300.0
2009-06-04	BNE	ETF	6.62	6.88	6.31	6.77	189623.0
2009-06-04	BOSS	ETF	16.43	16.43	16.01	16.43	500.0
2009-06-04	BRF	ETF	27.37	28.39	27.35	28.3	93065.0
2009-06-04	BSV	ETF	79.1	79.1	78.92	78.92	175200.0
2009-06-04	BTF	ETF	48.25	48.75	47.85	48.699999999999996	8401.2
2009-06-04	BWX	ETF	27.175	27.2	27.0	27.07	338768.0
2009-06-04	BWZ	ETF	35.28	35.32	35.2	35.2585	2951.0
2009-06-04	CBON	ETF	1.25	1.3	1.21	1.3	27740.0
2009-06-04	CEF	ETF	12.17	12.49	12.07	12.37	1096600.0
2009-06-04	CEW	ETF	20.71	20.78	20.6755	20.75	40402.0
2009-06-04	CGO	ETF	11.59	11.76	11.5862	11.76	24000.0
2009-06-04	CGW	ETF	15.51	15.66	15.36	15.6	91066.0
2009-06-04	CHB	ETF	0.42	0.45	0.413	0.44	555931.0
2009-06-04	CHI	ETF	10.8	10.89	10.72	10.81	179429.0
2009-06-04	CHIC	ETF	11.29	11.38	10.9	11.33	205113.0
2009-06-04	CHW	ETF	7.41	7.55	7.32	7.47	252142.0

> showing 50 of 655 rows — these rows as CSV

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