PREVIEW / etf_daily / 2010-06-11

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-11.parquet
  size:    33 KB
  rows:    757

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-06-11	SPY	ETF	108.19	109.75	108.12	109.68	214128200.0
2010-06-11	QQQ	ETF	44.63	45.54	44.61	45.5	74347725.0
2010-06-11	IWM	ETF	63.29	65.03	63.18	64.94	65295200.0
2010-06-11	DIA	ETF	101.07	102.35	101.02	102.31	9066300.0
2010-06-11	GLD	ETF	119.88	120.41	119.33	120.01	7829400.0
2010-06-11	TLT	ETF	97.09	97.81	96.61	97.41	6266700.0
2010-06-11	AAXJ	ETF	51.78	52.92	51.78	52.89	375600.0
2010-06-11	ACWI	ETF	39.26	39.76	39.19	39.76	1499100.0
2010-06-11	ACWX	ETF	36.52	36.84	36.4225	36.81	298248.0
2010-06-11	ADRE	ETF	40.16	40.92	40.04	40.85	64605.0
2010-06-11	AFK	ETF	28.18	28.79	28.1001	28.626	915.0
2010-06-11	AGG	ETF	105.64	105.89	105.57	105.66	442000.0
2010-06-11	AGQ	ETF	122.56	122.8	119.18	121.02	90700.0
2010-06-11	AGZ	ETF	109.49	109.5	109.273	109.432	7128.0
2010-06-11	AIA	ETF	36.99	37.488	36.99	37.488	5321.0
2010-06-11	AIQ	ETF	25.55	26.45	25.35	26.45	12826.0
2010-06-11	AIS	ETF	1.71	1.74	1.65	1.74	368212.0
2010-06-11	AIVI	ETF	37.64	38.23	37.64	38.22	19000.0
2010-06-11	AMJ	ETF	29.59	29.98	29.5	29.89	660678.0
2010-06-11	AOA	ETF	29.02	29.41	29.02	29.41	18400.0
2010-06-11	AOK	ETF	27.433	27.544	27.433	27.544	1637.0
2010-06-11	AOM	ETF	27.879	28.009	27.879	28.009	5201.0
2010-06-11	AOR	ETF	28.35	28.63	28.34	28.63	23007.0
2010-06-11	ARB	ETF	28.1	29.06	28.02	28.86	138338.0
2010-06-11	BAB	ETF	26.01	26.09	25.9	26.05	123078.0
2010-06-11	BAL	ETF	38.51	38.5101	38.51	38.5101	200.0
2010-06-11	BALT	ETF	12.07	12.15	11.84	12.15	169057.0
2010-06-11	BBH	ETF	29.14	29.5667	29.1367	29.4233	139800.0
2010-06-11	BIB	ETF	5.6675	5.7263	5.6675	5.7263	4000.0
2010-06-11	BICK	ETF	27.38	27.38	27.255	27.355	745.0
2010-06-11	BIL	ETF	91.72	91.74	91.7	91.74	144750.0
2010-06-11	BIS	ETF	12144.0	12144.0	11716.8	11720.0	5.6
2010-06-11	BITS	ETF	27.8	28.12	27.4	27.96	1018.0
2010-06-11	BIV	ETF	81.89	82.09	81.75	82.03	101900.0
2010-06-11	BJK	ETF	23.87	24.35	23.87	24.29	7900.0
2010-06-11	BKF	ETF	41.54	42.33	41.3	42.32	68424.0
2010-06-11	BLV	ETF	79.38	79.93	79.26	79.8	56900.0
2010-06-11	BMVP	ETF	12.22	12.37	12.22	12.37	10868.0
2010-06-11	BND	ETF	80.34	80.47	80.24	80.36	621300.0
2010-06-11	BNE	ETF	11.12	11.15	11.12	11.15	545756.0
2010-06-11	BNO	ETF	25.535	25.565	25.31	25.56	54600.0
2010-06-11	BOSS	ETF	28.775	28.775	28.5	28.5	200.0
2010-06-11	BRF	ETF	43.24	43.97	43.1	43.97	332548.0
2010-06-11	BSCE	ETF	20.13	20.13	20.11	20.11	1300.0
2010-06-11	BSV	ETF	80.32	80.47	80.32	80.45	329000.0
2010-06-11	BTF	ETF	64.4	65.1185	64.35	65.05	5528.400000000001
2010-06-11	BWX	ETF	26.51	26.51	26.25	26.295	297804.0
2010-06-11	BWZ	ETF	33.241	33.26	33.05	33.1	33189.0
2010-06-11	BZQ	ETF	4214.4	4216.0	4024.0	4038.4	818.0
2010-06-11	CEF	ETF	14.96	15.0	14.84	14.96	659500.0

> showing 50 of 757 rows — these rows as CSV

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