PREVIEW / etf_daily / 2010-10-27

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-27.parquet
  size:    34 KB
  rows:    794

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-27	SPY	ETF	117.89	118.51	117.26	118.38	190024000.0
2010-10-27	QQQ	ETF	51.77	52.23	51.66	52.19	57483184.0
2010-10-27	IWM	ETF	70.21	70.62	69.54	70.51	53515400.0
2010-10-27	DIA	ETF	111.12	111.46	110.26	111.31	7608300.0
2010-10-27	GLD	ETF	129.93	130.0	128.79	129.52	16132100.0
2010-10-27	TLT	ETF	99.68	100.17	99.22	99.22	9245200.0
2010-10-27	AADR	ETF	28.87	28.87	28.87	28.87	200.0
2010-10-27	AAXJ	ETF	61.92	61.95	61.26	61.81	542700.0
2010-10-27	ACWI	ETF	44.6	44.62	44.21	44.6	107500.0
2010-10-27	ACWX	ETF	42.56	42.56	42.0	42.41	50561.0
2010-10-27	ADRE	ETF	45.97	45.97	45.21	45.68	95699.0
2010-10-27	AFK	ETF	33.07	33.29	32.771	33.04	24959.0
2010-10-27	AGG	ETF	108.15	108.35	108.02	108.05	587900.0
2010-10-27	AGQ	ETF	194.06	194.22	188.88	192.64	316250.0
2010-10-27	AGZ	ETF	111.17	111.49	111.17	111.3	68186.0
2010-10-27	AIA	ETF	43.55	43.55	43.2	43.55	16918.0
2010-10-27	AIQ	ETF	20.35	20.8	20.35	20.5	46031.0
2010-10-27	AIS	ETF	1.41	1.41	1.38	1.38	254555.0
2010-10-27	AIVI	ETF	44.71	44.84	44.28	44.8	26100.0
2010-10-27	AMJ	ETF	35.14	35.24	34.91	35.18	541018.0
2010-10-27	AMLP	ETF	79.2	79.45	78.9	79.25	100740.0
2010-10-27	AOA	ETF	32.51	32.51	32.25	32.46	6400.0
2010-10-27	AOK	ETF	28.71	28.71	28.63	28.68	8179.0
2010-10-27	AOM	ETF	29.53	29.53	29.4001	29.5	10911.0
2010-10-27	AOR	ETF	30.59	30.67	30.44	30.58	14783.0
2010-10-27	ARB	ETF	26.95	27.12	26.01	26.36	418720.0
2010-10-27	BAB	ETF	26.04	26.15	26.0	26.01	145163.0
2010-10-27	BAL	ETF	61.01	61.01	59.3	60.68	54159.0
2010-10-27	BALT	ETF	11.18	11.47	11.16	11.19	145050.0
2010-10-27	BBH	ETF	33.3933	33.81	33.3933	33.8033	83700.0
2010-10-27	BIB	ETF	6.6925	6.7387	6.6925	6.7387	8240.0
2010-10-27	BICK	ETF	32.67	32.67	32.12	32.4	26543.0
2010-10-27	BIL	ETF	91.7	91.72	91.7	91.72	115000.0
2010-10-27	BIS	ETF	9108.8	9240.0	9088.0	9088.0	72.0
2010-10-27	BITS	ETF	27.44	28.0	27.32	27.96	652.0
2010-10-27	BIV	ETF	86.39	86.42	86.07	86.09	136000.0
2010-10-27	BJK	ETF	30.07	30.21	29.85	30.15	14700.0
2010-10-27	BKF	ETF	49.15	49.15	48.38	48.9	149769.0
2010-10-27	BLV	ETF	83.33	83.34	82.87	82.97	29300.0
2010-10-27	BMVP	ETF	13.63	13.68	13.55	13.68	17729.0
2010-10-27	BND	ETF	82.34	82.41	82.24	82.27	1980200.0
2010-10-27	BNE	ETF	11.33	11.35	11.29	11.33	222217.0
2010-10-27	BNO	ETF	27.585	27.585	27.48	27.515	5800.0
2010-10-27	BRF	ETF	59.23	59.41	58.3	58.6	300949.0
2010-10-27	BSCE	ETF	21.01	21.01	21.0	21.0	3500.0
2010-10-27	BSV	ETF	81.79	81.79	81.71	81.72	289000.0
2010-10-27	BTF	ETF	77.8	77.8	76.85	77.69999999999999	2723.4
2010-10-27	BWX	ETF	30.21	30.385	30.105	30.19	266190.0
2010-10-27	BWZ	ETF	37.15	37.2835	37.1001	37.28	6618.0
2010-10-27	BZQ	ETF	2672.0	2771.2	2672.0	2742.4	437.5

> showing 50 of 794 rows — these rows as CSV

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