PREVIEW / etf_daily / 2010-07-08

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-08.parquet
  size:    33 KB
  rows:    756

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
2010-07-08	SPY	ETF	107.0	107.28	105.91	107.16	210842100.0
2010-07-08	QQQ	ETF	44.3097	44.38	43.68	44.2	78264578.0
2010-07-08	IWM	ETF	61.77	62.11	61.04	61.98	58770100.0
2010-07-08	DIA	ETF	100.9	101.51	100.4	101.51	9456500.0
2010-07-08	GLD	ETF	117.39	117.41	116.1	117.21	11315100.0
2010-07-08	TLT	ETF	99.82	100.16	99.55	99.79	6260600.0
2010-07-08	AAXJ	ETF	53.88	54.15	53.6	54.15	1715300.0
2010-07-08	ACWI	ETF	39.6	39.65	39.17	39.65	92500.0
2010-07-08	ACWX	ETF	37.23	37.4	36.97	37.35	60439.0
2010-07-08	ADRE	ETF	40.91	41.039	40.518	40.99	162299.0
2010-07-08	AFK	ETF	28.7	28.7	28.3	28.36	7415.0
2010-07-08	AGG	ETF	106.82	106.98	106.67	106.9	622100.0
2010-07-08	AGQ	ETF	117.54	117.72	113.06	116.44	163600.0
2010-07-08	AGZ	ETF	109.78	109.937	109.71	109.92	23407.0
2010-07-08	AIA	ETF	38.02	38.1399	37.8119	38.13	18394.0
2010-07-08	AIQ	ETF	17.3	19.8	17.2	19.35	85527.0
2010-07-08	AIS	ETF	1.7	1.85	1.68	1.73	461554.0
2010-07-08	AIVI	ETF	38.54	38.82	38.35	38.82	8200.0
2010-07-08	AMJ	ETF	31.65	31.75	31.46	31.74	381858.0
2010-07-08	AOA	ETF	29.06	29.11	28.8	28.98	11200.0
2010-07-08	AOK	ETF	27.46	27.48	27.4	27.46	15878.0
2010-07-08	AOM	ETF	27.9265	27.95	27.802	27.95	4588.0
2010-07-08	AOR	ETF	28.3054	28.3601	28.24	28.3601	4463.0
2010-07-08	ARB	ETF	25.88	26.41	25.55	25.86	175025.0
2010-07-08	BAB	ETF	25.79	25.83	25.72	25.78	164232.0
2010-07-08	BAL	ETF	36.12	36.289	35.85	36.1	2517.0
2010-07-08	BALT	ETF	10.33	10.44	10.01	10.38	143475.0
2010-07-08	BBH	ETF	29.2067	29.6167	29.1167	29.5833	216900.0
2010-07-08	BIB	ETF	5.2012	5.2012	5.2012	5.2012	800.0
2010-07-08	BICK	ETF	27.44	27.69	27.44	27.69	1906.0
2010-07-08	BIL	ETF	91.7	91.72	91.7	91.72	1255100.0
2010-07-08	BIS	ETF	12798.4	12798.4	12689.6	12689.6	2.255
2010-07-08	BITS	ETF	26.92	26.92	26.56	26.84	150.0
2010-07-08	BIV	ETF	83.18	83.38	82.94	83.3	254900.0
2010-07-08	BJK	ETF	23.72	23.79	23.45	23.67	31500.0
2010-07-08	BKF	ETF	42.42	42.64	42.01	42.59	117983.0
2010-07-08	BLV	ETF	81.3	81.49	81.05	81.21	32800.0
2010-07-08	BMVP	ETF	11.99	12.03	11.92	12.03	18419.0
2010-07-08	BND	ETF	81.11	81.25	81.03	81.18	619500.0
2010-07-08	BNE	ETF	11.25	11.31	11.24	11.3	963281.0
2010-07-08	BNO	ETF	25.535	25.535	25.2	25.44	77000.0
2010-07-08	BRF	ETF	46.03	46.206	45.4101	46.08	118640.0
2010-07-08	BSCE	ETF	20.42	20.42	20.4134	20.4134	1870.0
2010-07-08	BSV	ETF	80.79	80.91	80.78	80.9	522200.0
2010-07-08	BTF	ETF	67.75	68.2	67.05	68.0	10980.6
2010-07-08	BWX	ETF	27.475	27.5018	27.35	27.435	208766.0
2010-07-08	BWZ	ETF	34.2	34.342	34.2	34.32	36615.0
2010-07-08	BZQ	ETF	3848.0	3936.0	3796.8	3820.8	1201.0
2010-07-08	CEF	ETF	14.73	14.73	14.4	14.64	578300.0
2010-07-08	CEW	ETF	21.63	21.63	21.53	21.6	238215.0

> showing 50 of 756 rows — these rows as CSV

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