PREVIEW / etf_daily / 2009-07-06

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-06.parquet
  size:    29 KB
  rows:    664

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-07-06	SPY	ETF	88.94	89.93	88.66	89.8	174499600.0
2009-07-06	QQQ	ETF	35.38	35.54	35.04	35.41	107632481.0
2009-07-06	IWM	ETF	49.47	49.74	48.65	49.47	47241700.0
2009-07-06	DIA	ETF	82.21	83.31	82.08	83.25	12392700.0
2009-07-06	GLD	ETF	90.48	90.93	90.36	90.76	6286200.0
2009-07-06	TLT	ETF	94.05	94.29	93.39	94.12	1886700.0
2009-07-06	AAXJ	ETF	43.69	44.09	43.18	44.09	152900.0
2009-07-06	ACWI	ETF	33.73	33.87	33.47	33.87	85700.0
2009-07-06	ACWX	ETF	32.46	32.71	32.29	32.71	49167.0
2009-07-06	ADRE	ETF	33.61	33.84	33.208	33.8334	134630.0
2009-07-06	AFK	ETF	26.65	26.68	25.64	26.4613	11432.0
2009-07-06	AGG	ETF	101.89	102.1	101.85	101.93	436600.0
2009-07-06	AGQ	ETF	74.52	77.34	74.26	77.12	111400.0
2009-07-06	AGZ	ETF	107.64	107.88	107.415	107.85	6855.0
2009-07-06	AIA	ETF	31.75	32.23	31.638	32.23	30097.0
2009-07-06	AIQ	ETF	33.45	34.05	32.75	32.85	55611.0
2009-07-06	AIS	ETF	0.88	0.94	0.85	0.9	576842.0
2009-07-06	AIVI	ETF	33.8	34.32	33.8	34.32	7200.0
2009-07-06	AMJ	ETF	22.1	22.18	21.92	22.18	78819.0
2009-07-06	AOA	ETF	24.55	24.56	24.4	24.5	2200.0
2009-07-06	AOK	ETF	25.56	25.63	25.508	25.63	4160.0
2009-07-06	AOM	ETF	25.61	25.61	25.28	25.3595	2795.0
2009-07-06	AOR	ETF	25.17	25.17	24.95	25.09	3483.0
2009-07-06	ARB	ETF	16.11	16.23	15.66	16.01	312907.0
2009-07-06	BAL	ETF	30.74	31.36	30.74	31.2901	10697.0
2009-07-06	BBH	ETF	30.22	30.4567	29.96	30.3733	388800.0
2009-07-06	BIL	ETF	91.74	91.76	91.74	91.74	113200.0
2009-07-06	BITS	ETF	20.6	20.6	19.32	20.56	850.0
2009-07-06	BIV	ETF	77.08	77.19	76.81	77.17	59000.0
2009-07-06	BJK	ETF	19.83	20.0	19.5	19.86	271700.0
2009-07-06	BKF	ETF	34.55	34.75	33.8	34.74	155223.0
2009-07-06	BLV	ETF	74.36	74.38	73.94	74.1	46200.0
2009-07-06	BMVP	ETF	10.71	10.8	10.67	10.8	15069.0
2009-07-06	BND	ETF	77.43	77.48	77.26	77.35	240300.0
2009-07-06	BNE	ETF	6.69	6.69	6.23	6.58	158856.0
2009-07-06	BOSS	ETF	16.33	16.33	15.2	15.2	300.0
2009-07-06	BRF	ETF	27.73	28.25	27.35	28.239	77233.0
2009-07-06	BSV	ETF	79.21	79.21	79.05	79.13	163600.0
2009-07-06	BTF	ETF	47.15	47.85	46.699999999999996	47.64999999999999	11343.6
2009-07-06	BWX	ETF	27.195	27.42	27.195	27.42	334792.0
2009-07-06	BWZ	ETF	35.07	35.09	35.07	35.085	3249.0
2009-07-06	BZQ	ETF	10060.8	10272.0	9776.0	9776.0	21.25
2009-07-06	CBON	ETF	1.29	1.29	0.9	0.9001	3486.0
2009-07-06	CEF	ETF	11.7	11.7	11.45	11.47	740500.0
2009-07-06	CEW	ETF	20.77	20.84	20.75	20.84	8037.0
2009-07-06	CGO	ETF	11.56	11.62	11.39	11.41	25588.0
2009-07-06	CGW	ETF	15.1	15.36	15.01	15.19	40281.0
2009-07-06	CHB	ETF	0.32	0.32	0.3	0.3	643049.0
2009-07-06	CHI	ETF	10.2	10.48	10.15	10.42	123704.0
2009-07-06	CHIC	ETF	12.51	12.85	12.06	12.37	154887.0

> showing 50 of 664 rows — these rows as CSV

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