PREVIEW / etf_daily / 2010-02-18

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-18.parquet
  size:    31 KB
  rows:    723

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-02-18	SPY	ETF	110.08	111.14	110.04	110.91	193708600.0
2010-02-18	QQQ	ETF	44.54	44.93	44.45	44.85	65752535.0
2010-02-18	IWM	ETF	62.47	63.0	62.25	62.98	43072800.0
2010-02-18	DIA	ETF	103.17	104.3	103.16	104.17	8677700.0
2010-02-18	GLD	ETF	109.61	110.11	109.19	109.98	19177400.0
2010-02-18	TLT	ETF	89.46	89.5	88.51	88.97	5121800.0
2010-02-18	AAXJ	ETF	53.24	53.65	52.99	53.58	171100.0
2010-02-18	ACWI	ETF	41.05	41.33	41.03	41.33	33600.0
2010-02-18	ACWX	ETF	39.22	39.56	39.22	39.55	33603.0
2010-02-18	ADRE	ETF	41.15	41.8581	41.15	41.75	48733.0
2010-02-18	AFK	ETF	29.24	29.3	29.0101	29.21	10670.0
2010-02-18	AGG	ETF	103.99	104.1	103.75	103.92	400100.0
2010-02-18	AGQ	ETF	101.08	101.92	98.12	100.96	223850.0
2010-02-18	AGZ	ETF	108.3999	108.425	108.09	108.1	36082.0
2010-02-18	AIA	ETF	38.29	38.86	38.29	38.74	21274.0
2010-02-18	AIQ	ETF	25.55	25.9	25.1	25.8	17830.0
2010-02-18	AIS	ETF	1.2	1.22	1.12	1.21	331511.0
2010-02-18	AIVI	ETF	40.51	40.95	40.51	40.83	9300.0
2010-02-18	AMJ	ETF	29.75	29.75	29.47	29.6	1224427.0
2010-02-18	AOA	ETF	29.62	29.79	29.59	29.75	21100.0
2010-02-18	AOK	ETF	27.35	27.35	27.27	27.3135	6045.0
2010-02-18	AOM	ETF	27.96	28.05	27.9232	28.05	20541.0
2010-02-18	AOR	ETF	28.63	28.74	28.62	28.74	8432.0
2010-02-18	ARB	ETF	24.0	24.0	22.27	22.8	1171453.0
2010-02-18	BAB	ETF	24.54	24.54	24.37	24.48	304497.0
2010-02-18	BAL	ETF	36.47	37.685	36.47	37.55	57852.0
2010-02-18	BBH	ETF	34.44	34.57	34.3133	34.5267	177900.0
2010-02-18	BIL	ETF	91.7	91.72	91.7	91.72	103800.0
2010-02-18	BITS	ETF	31.72	32.0	31.48	32.0	1020.0
2010-02-18	BIV	ETF	80.0	80.0	79.68	79.77	83200.0
2010-02-18	BJK	ETF	23.42	23.47	23.31	23.4	9800.0
2010-02-18	BKF	ETF	42.75	43.44	42.66	43.33	150573.0
2010-02-18	BLV	ETF	75.98	75.99	75.13	75.66	23100.0
2010-02-18	BMVP	ETF	12.5533	12.6911	12.5533	12.6833	21009.0
2010-02-18	BND	ETF	79.24	79.24	78.94	79.04	510600.0
2010-02-18	BNE	ETF	6.81	6.87	6.75	6.8	228676.0
2010-02-18	BRF	ETF	45.79	46.7	45.47	46.39	349738.0
2010-02-18	BSV	ETF	80.24	80.24	80.05	80.12	830800.0
2010-02-18	BTF	ETF	66.69999999999999	67.3495	66.14999999999999	67.3495	5331.400000000001
2010-02-18	BWX	ETF	27.88	27.92	27.77	27.895	269264.0
2010-02-18	BWZ	ETF	35.57	35.64	35.44	35.48	8886.0
2010-02-18	BZQ	ETF	4243.2	4243.2	4019.2	4033.6	632.5
2010-02-18	CEF	ETF	13.58	13.66	13.4	13.4	1540800.0
2010-02-18	CEW	ETF	21.76	21.83	21.76	21.81	63560.0
2010-02-18	CGO	ETF	14.02	14.28	14.02	14.11	23711.0
2010-02-18	CGW	ETF	17.55	17.85	17.51	17.85	63677.0
2010-02-18	CHI	ETF	11.88	12.1	11.88	12.05	267093.0
2010-02-18	CHIE	ETF	14.04	14.1199	14.04	14.1199	3085.0
2010-02-18	CHII	ETF	14.53	14.66	14.5045	14.66	4274.0
2010-02-18	CHIM	ETF	25.56	25.58	25.48	25.58	1564.0

> showing 50 of 723 rows — these rows as CSV

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