PREVIEW / etf_daily / 2010-06-15

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-15.parquet
  size:    33 KB
  rows:    758

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-15	SPY	ETF	110.28	112.1	110.09	112.0	238268700.0
2010-06-15	QQQ	ETF	45.71	46.77	45.4532	46.71	76332552.0
2010-06-15	IWM	ETF	65.92	67.17	65.36	66.99	72336400.0
2010-06-15	DIA	ETF	102.81	104.29	102.1	104.17	9402100.0
2010-06-15	GLD	ETF	119.71	121.03	119.48	120.99	15073000.0
2010-06-15	TLT	ETF	97.11	97.25	96.05	96.51	4920100.0
2010-06-15	AAXJ	ETF	53.21	54.53	53.21	54.43	543000.0
2010-06-15	ACWI	ETF	40.18	40.86	40.15	40.8	1546900.0
2010-06-15	ACWX	ETF	37.59	38.08	37.489	38.07	44648.0
2010-06-15	ADRE	ETF	40.95	41.97	40.95	41.95	57185.0
2010-06-15	AFK	ETF	28.83	29.24	28.83	29.24	5036.0
2010-06-15	AGG	ETF	105.86	105.95	105.65	105.81	882800.0
2010-06-15	AGQ	ETF	123.48	127.16	122.46	125.9	107350.0
2010-06-15	AGZ	ETF	109.42	109.49	109.23	109.32	19199.0
2010-06-15	AIA	ETF	37.78	38.53	37.78	38.524	9547.0
2010-06-15	AIQ	ETF	25.7	26.05	25.3	25.75	19745.0
2010-06-15	AIS	ETF	1.84	1.88	1.82	1.88	632696.0
2010-06-15	AIVI	ETF	39.22	39.89	39.22	39.89	14200.0
2010-06-15	AMJ	ETF	30.32	30.67	30.17	30.45	469977.0
2010-06-15	AOA	ETF	29.71	30.15	29.71	30.15	4100.0
2010-06-15	AOK	ETF	27.69	27.76	27.633	27.7185	6511.0
2010-06-15	AOM	ETF	28.13	28.34	28.1101	28.34	7892.0
2010-06-15	AOR	ETF	28.78	29.06	28.78	29.05	17115.0
2010-06-15	ARB	ETF	28.31	28.55	27.65	28.04	366304.0
2010-06-15	BAB	ETF	25.86	25.89	25.6899	25.78	205876.0
2010-06-15	BAL	ETF	39.02	39.02	38.65	38.8	3828.0
2010-06-15	BALT	ETF	12.38	12.84	12.27	12.73	174858.0
2010-06-15	BBH	ETF	29.7333	30.2233	29.7333	30.2	85500.0
2010-06-15	BIB	ETF	5.875	6.015	5.875	6.0088	3200.0
2010-06-15	BICK	ETF	27.92	28.5934	27.86	28.2635	14197.0
2010-06-15	BIL	ETF	91.72	91.74	91.7	91.7	382100.0
2010-06-15	BIS	ETF	11232.0	11232.0	11152.16	11152.16	6.25
2010-06-15	BITS	ETF	27.6	28.44	27.4	27.76	525.0
2010-06-15	BIV	ETF	82.03	82.03	81.65	81.79	130400.0
2010-06-15	BJK	ETF	24.93	25.23	24.71	25.22	16000.0
2010-06-15	BKF	ETF	42.33	43.204	42.33	43.145	125222.0
2010-06-15	BLV	ETF	79.8	79.8	79.12	79.2	19100.0
2010-06-15	BMVP	ETF	12.52	12.71	12.51	12.69	11044.0
2010-06-15	BND	ETF	80.44	80.47	80.2	80.24	808100.0
2010-06-15	BNE	ETF	11.19	11.21	11.15	11.16	576773.0
2010-06-15	BNO	ETF	26.12	26.175	26.12	26.16	8000.0
2010-06-15	BRF	ETF	44.2	45.06	44.12	45.06	302668.0
2010-06-15	BSCE	ETF	20.16	20.16	20.147	20.15	4175.0
2010-06-15	BSV	ETF	80.47	80.47	80.36	80.4	766100.0
2010-06-15	BTF	ETF	65.7	67.03999999999999	65.7	67.03999999999999	3444.2000000000003
2010-06-15	BWX	ETF	26.46	26.675	26.46	26.555	109612.0
2010-06-15	BWZ	ETF	33.68	33.72	33.548	33.7	5180.0
2010-06-15	BZQ	ETF	4025.6	4059.2	3860.8	3878.4	1639.5
2010-06-15	CEF	ETF	15.05	15.29	14.99	15.27	2033200.0
2010-06-15	CEW	ETF	21.38	21.55	21.37	21.55	36568.0

> showing 50 of 758 rows — these rows as CSV

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