PREVIEW / etf_daily / 2010-10-19

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-19.parquet
  size:    34 KB
  rows:    796

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-19	SPY	ETF	117.19	117.85	116.02	116.73	280604700.0
2010-10-19	QQQ	ETF	50.81	51.3	50.42	50.82	105739706.0
2010-10-19	IWM	ETF	70.04	70.76	68.95	69.5	64627600.0
2010-10-19	DIA	ETF	110.29	110.68	109.17	109.84	9253700.0
2010-10-19	GLD	ETF	130.46	131.59	129.75	130.11	25327200.0
2010-10-19	TLT	ETF	100.58	102.09	100.55	101.69	8017500.0
2010-10-19	AADR	ETF	28.3	28.4	28.2	28.2	1900.0
2010-10-19	AAXJ	ETF	62.35	62.35	61.52	61.77	1463800.0
2010-10-19	ACWI	ETF	44.26	44.61	43.99	44.2	172900.0
2010-10-19	ACWX	ETF	42.53	42.7496	42.07	42.29	55381.0
2010-10-19	ADRE	ETF	46.17	46.23	45.5	45.72	98093.0
2010-10-19	AFK	ETF	33.63	33.63	32.86	33.01	31813.0
2010-10-19	AGG	ETF	108.3	108.62	108.25	108.49	607200.0
2010-10-19	AGQ	ETF	193.84	200.0	187.9	189.28	570100.0
2010-10-19	AGZ	ETF	111.61	111.76	111.5455	111.64	18732.0
2010-10-19	AIA	ETF	43.31	43.31	42.7724	42.83	46526.0
2010-10-19	AIQ	ETF	22.05	22.5	21.75	21.8	26364.0
2010-10-19	AIS	ETF	1.57	1.57	1.5	1.52	238399.0
2010-10-19	AIVI	ETF	44.74	44.83	44.05	44.3	53000.0
2010-10-19	AMJ	ETF	34.76	35.0	34.55	34.715	440849.0
2010-10-19	AMLP	ETF	78.5	78.9	78.45	78.6	73640.0
2010-10-19	AOA	ETF	32.31	32.44	32.02	32.14	28200.0
2010-10-19	AOK	ETF	28.68	28.74	28.66	28.68	13322.0
2010-10-19	AOM	ETF	29.5	29.5699	29.4055	29.43	11622.0
2010-10-19	AOR	ETF	30.51	30.622	30.37	30.46	22568.0
2010-10-19	ARB	ETF	29.59	30.05	28.59	28.8	159389.0
2010-10-19	BAB	ETF	26.2	26.36	26.136	26.28	383970.0
2010-10-19	BAL	ETF	54.21	55.289	53.5	53.66	36606.0
2010-10-19	BALT	ETF	10.86	11.1	10.84	10.94	135434.0
2010-10-19	BBH	ETF	33.0033	33.3333	32.6	32.81	41400.0
2010-10-19	BICK	ETF	32.8	32.8	32.01	32.11	60231.0
2010-10-19	BIL	ETF	91.72	91.72	91.7	91.7	66200.0
2010-10-19	BIS	ETF	9280.0	9359.984	9280.0	9300.8	2.5
2010-10-19	BITS	ETF	27.12	27.2	26.84	26.84	400.0
2010-10-19	BIV	ETF	86.81	87.3	86.81	87.21	171900.0
2010-10-19	BJK	ETF	29.38	29.38	28.8	28.93	17600.0
2010-10-19	BKF	ETF	49.58	49.58	48.72	48.89	164511.0
2010-10-19	BLV	ETF	83.67	84.37	83.46	84.11	25700.0
2010-10-19	BMVP	ETF	13.44	13.54	13.32	13.39	9410.0
2010-10-19	BND	ETF	82.5	82.8	82.5	82.77	470800.0
2010-10-19	BNE	ETF	11.39	11.4	11.33	11.36	494746.0
2010-10-19	BNO	ETF	27.705	27.705	27.1	27.1	6200.0
2010-10-19	BRF	ETF	59.55	59.55	57.57	57.83	1094503.0
2010-10-19	BSCE	ETF	21.1	21.1	21.04	21.04	1265.0
2010-10-19	BSV	ETF	81.92	81.96	81.88	81.94	306400.0
2010-10-19	BTF	ETF	77.24999999999999	77.39999999999999	76.14999999999999	76.92999999999999	5273.8
2010-10-19	BWX	ETF	30.465	30.47	30.16	30.21	360850.0
2010-10-19	BWZ	ETF	37.55	37.55	37.12	37.2	14872.0
2010-10-19	BZQ	ETF	2622.4	2684.8	2585.6	2654.4	1627.0
2010-10-19	CEF	ETF	17.34	17.52	17.1	17.31	2090000.0

> showing 50 of 796 rows — these rows as CSV

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