PREVIEW / etf_daily / 2010-08-26

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-26.parquet
  size:    33 KB
  rows:    769

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-08-26	SPY	ETF	106.44	106.58	104.88	105.23	224439500.0
2010-08-26	QQQ	ETF	44.24	44.32	43.5	43.54	91222971.0
2010-08-26	IWM	ETF	60.75	61.28	59.86	60.08	74569900.0
2010-08-26	DIA	ETF	100.96	101.06	99.67	99.93	8258800.0
2010-08-26	GLD	ETF	121.09	122.95	120.5	120.96	8886600.0
2010-08-26	TLT	ETF	107.56	108.49	107.29	108.42	7039900.0
2010-08-26	AADR	ETF	25.12	25.15	25.0	25.0	7500.0
2010-08-26	AAXJ	ETF	54.53	54.9	54.22	54.24	703200.0
2010-08-26	ACWI	ETF	39.51	39.66	39.07	39.11	153100.0
2010-08-26	ACWX	ETF	37.52	37.69	37.17	37.28	49330.0
2010-08-26	ADRE	ETF	40.86	41.022	40.3601	40.41	137465.0
2010-08-26	AFK	ETF	29.9699	29.9699	29.49	29.54	2762.0
2010-08-26	AGG	ETF	108.63	108.94	108.56	108.73	1177900.0
2010-08-26	AGQ	ETF	129.14	130.12	126.86	127.84	191050.0
2010-08-26	AGZ	ETF	111.4284	111.44	111.18	111.21	16609.0
2010-08-26	AIA	ETF	38.66	38.7301	38.4	38.55	3715.0
2010-08-26	AIQ	ETF	22.65	22.75	21.75	21.8	17545.0
2010-08-26	AIS	ETF	1.51	1.54	1.48	1.49	120360.0
2010-08-26	AIVI	ETF	39.05	39.05	38.5	38.61	7500.0
2010-08-26	AMJ	ETF	32.04	32.05	31.81	31.93	616020.0
2010-08-26	AMLP	ETF	75.5	75.5	75.0	75.35	252820.0
2010-08-26	AOA	ETF	29.05	29.05	28.8	28.8	1900.0
2010-08-26	AOK	ETF	27.69	27.77	27.66	27.706	7866.0
2010-08-26	AOM	ETF	28.1444	28.1599	28.0	28.0	7208.0
2010-08-26	AOR	ETF	28.49	28.49	28.33	28.36	6058.0
2010-08-26	ARB	ETF	24.29	24.6	24.18	24.38	237678.0
2010-08-26	BAB	ETF	26.72	27.0	26.72	27.0	354805.0
2010-08-26	BAL	ETF	41.9	42.24	41.8	42.18	7967.0
2010-08-26	BALT	ETF	11.23	11.39	10.8	10.88	104213.0
2010-08-26	BBH	ETF	30.1833	30.2	29.6033	29.6633	66000.0
2010-08-26	BIB	ETF	5.4575	5.4575	5.2912	5.2912	4000.0
2010-08-26	BICK	ETF	28.04	28.33	27.83	27.9293	40163.0
2010-08-26	BIL	ETF	91.72	91.72	91.7	91.7	130050.0
2010-08-26	BIS	ETF	11706.4	12096.0	11706.4	12096.0	2.5
2010-08-26	BITS	ETF	24.6	24.6	24.04	24.4	1046.0
2010-08-26	BIV	ETF	86.26	86.48	86.21	86.46	124800.0
2010-08-26	BJK	ETF	25.45	25.64	25.05	25.12	9200.0
2010-08-26	BKF	ETF	43.24	43.24	42.37	42.55	154477.0
2010-08-26	BLV	ETF	86.83	87.7	86.83	87.57	26200.0
2010-08-26	BMVP	ETF	12.0733	12.0967	11.9136	11.9467	15028.0
2010-08-26	BND	ETF	82.71	82.8	82.64	82.76	459400.0
2010-08-26	BNE	ETF	11.16	11.16	11.11	11.11	364761.0
2010-08-26	BNO	ETF	25.35	25.35	25.35	25.35	3000.0
2010-08-26	BRF	ETF	50.94	50.97	50.0	50.23	246798.0
2010-08-26	BSCE	ETF	20.84	20.84	20.8154	20.84	2170.0
2010-08-26	BSV	ETF	81.62	81.65	81.56	81.63	428800.0
2010-08-26	BTF	ETF	68.75	69.05	67.755	68.3	4426.6
2010-08-26	BWX	ETF	28.97	28.97	28.84	28.925	275990.0
2010-08-26	BWZ	ETF	35.08	35.11	35.0	35.0504	3006.0
2010-08-26	BZQ	ETF	3601.6	3779.2	3592.0	3771.2	949.0

> showing 50 of 769 rows — these rows as CSV

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