PREVIEW / etf_daily / 2010-10-18

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-18.parquet
  size:    34 KB
  rows:    791

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-10-18	SPY	ETF	117.74	118.67	117.31	118.28	141204800.0
2010-10-18	QQQ	ETF	51.52	51.72	51.3	51.3	72505161.0
2010-10-18	IWM	ETF	70.56	71.03	70.26	70.88	39841500.0
2010-10-18	DIA	ETF	110.68	111.59	110.55	111.01	4434900.0
2010-10-18	GLD	ETF	133.46	134.34	133.16	134.28	12289500.0
2010-10-18	TLT	ETF	101.2	101.45	100.78	101.08	5592200.0
2010-10-18	AADR	ETF	28.79	28.79	28.79	28.79	500.0
2010-10-18	AAXJ	ETF	62.94	63.35	62.68	63.31	203400.0
2010-10-18	ACWI	ETF	44.98	45.2	44.82	45.12	1369100.0
2010-10-18	ACWX	ETF	43.15	43.4581	43.13	43.4	81738.0
2010-10-18	ADRE	ETF	46.48	47.1	46.48	47.03	87127.0
2010-10-18	AFK	ETF	33.95	34.18	33.7	34.134	31828.0
2010-10-18	AGG	ETF	108.25	108.47	108.17	108.4	755700.0
2010-10-18	AGQ	ETF	202.0	208.72	200.9	208.5	233550.0
2010-10-18	AGZ	ETF	111.57	111.642	111.45	111.61	16219.0
2010-10-18	AIA	ETF	43.72	43.95	43.57	43.95	21463.0
2010-10-18	AIQ	ETF	22.2	22.4	21.85	22.15	22832.0
2010-10-18	AIS	ETF	1.53	1.59	1.52	1.58	181231.0
2010-10-18	AIVI	ETF	45.35	45.72	45.23	45.68	12900.0
2010-10-18	AMJ	ETF	35.01	35.02	34.88	35.0	269882.0
2010-10-18	AMLP	ETF	79.0	79.0	78.75	78.95	102080.0
2010-10-18	AOA	ETF	32.52	32.76	32.52	32.76	9300.0
2010-10-18	AOK	ETF	28.69	28.81	28.69	28.81	11093.0
2010-10-18	AOM	ETF	29.61	29.6965	29.61	29.6965	4301.0
2010-10-18	AOR	ETF	30.68	30.79	30.61	30.79	6252.0
2010-10-18	ARB	ETF	29.8	30.35	29.65	30.06	268548.0
2010-10-18	BAB	ETF	26.23	26.29	26.18	26.22	110271.0
2010-10-18	BAL	ETF	53.78	55.7	53.66	55.67	67614.0
2010-10-18	BALT	ETF	11.01	11.17	10.89	10.96	151924.0
2010-10-18	BBH	ETF	32.9067	33.2333	32.88	33.2233	25800.0
2010-10-18	BIB	ETF	6.8613	6.8613	6.835	6.835	20848.0
2010-10-18	BICK	ETF	33.1	33.1	32.92	33.07	155518.0
2010-10-18	BIL	ETF	91.7	91.72	91.7	91.72	187850.0
2010-10-18	BIS	ETF	9089.6	9110.4	9008.0	9008.0	20.65
2010-10-18	BITS	ETF	27.2	27.36	27.0	27.332	2110.0
2010-10-18	BIV	ETF	86.95	87.17	86.72	87.05	128500.0
2010-10-18	BJK	ETF	29.77	29.85	29.63	29.85	13800.0
2010-10-18	BKF	ETF	50.27	50.75	49.98	50.42	141580.0
2010-10-18	BLV	ETF	83.88	84.0	83.61	83.88	56900.0
2010-10-18	BMVP	ETF	13.51	13.6	13.51	13.58	9002.0
2010-10-18	BND	ETF	82.52	82.68	82.46	82.65	486900.0
2010-10-18	BNE	ETF	11.37	11.4	11.36	11.37	186660.0
2010-10-18	BRF	ETF	60.99	61.36	60.25	60.25	340532.0
2010-10-18	BSCE	ETF	21.14	21.14	21.085	21.09	7700.0
2010-10-18	BSV	ETF	81.87	81.95	81.81	81.93	373400.0
2010-10-18	BTF	ETF	77.5	77.8	77.35	77.55	5779.8
2010-10-18	BWX	ETF	30.805	30.875	30.73	30.785	230718.0
2010-10-18	BWZ	ETF	37.75	37.88	37.73	37.8599	14779.0
2010-10-18	BZQ	ETF	2512.0	2515.2	2451.2	2478.4	269.0
2010-10-18	CEF	ETF	17.6	17.93	17.57	17.93	933500.0

> showing 50 of 791 rows — these rows as CSV

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