PREVIEW / etf_daily / 2010-06-30

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-30.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-30	SPY	ETF	103.92	104.88	102.88	103.22	284101700.0
2010-06-30	QQQ	ETF	43.23	43.67	42.64	42.71	101313181.0
2010-06-30	IWM	ETF	61.63	62.62	60.94	61.12	93806400.0
2010-06-30	DIA	ETF	98.51	99.13	97.59	97.73	13386200.0
2010-06-30	GLD	ETF	121.07	122.09	120.88	121.68	12016300.0
2010-06-30	TLT	ETF	101.41	101.79	100.8	101.75	7205700.0
2010-06-30	AAXJ	ETF	52.93	52.93	51.98	52.08	1119400.0
2010-06-30	ACWI	ETF	37.97	38.27	37.57	37.6	63600.0
2010-06-30	ACWX	ETF	35.28	35.76	35.05	35.15	163215.0
2010-06-30	ADRE	ETF	39.41	39.92	39.0	39.05	90838.0
2010-06-30	AFK	ETF	27.68	28.07	27.52	27.52	6046.0
2010-06-30	AGG	ETF	107.32	107.35	107.04	107.25	1050800.0
2010-06-30	AGQ	ETF	124.12	126.52	123.68	125.34	148100.0
2010-06-30	AGZ	ETF	110.36	110.36	110.15	110.29	15878.0
2010-06-30	AIA	ETF	36.92	37.3681	36.71	36.72	43673.0
2010-06-30	AIQ	ETF	20.35	20.7	20.025	20.2	27696.0
2010-06-30	AIS	ETF	1.74	1.8	1.74	1.76	698943.0
2010-06-30	AIVI	ETF	36.08	36.52	35.74	35.75	23100.0
2010-06-30	AMJ	ETF	30.88	31.18	30.7	30.91	602088.0
2010-06-30	AOA	ETF	28.21	28.46	27.95	27.95	6400.0
2010-06-30	AOK	ETF	27.43	27.458	27.4	27.4	2220.0
2010-06-30	AOM	ETF	27.5	27.65	27.47	27.48	7519.0
2010-06-30	AOR	ETF	27.86	28.0	27.73	27.73	19446.0
2010-06-30	ARB	ETF	25.81	26.46	25.55	25.63	132742.0
2010-06-30	BAB	ETF	26.16	26.16	25.96	26.1	152240.0
2010-06-30	BAL	ETF	37.51	37.6485	37.0	37.6485	5118.0
2010-06-30	BALT	ETF	11.38	11.6	11.3	11.37	175585.0
2010-06-30	BBH	ETF	29.5233	29.8267	29.06	29.06	131400.0
2010-06-30	BIB	ETF	5.4169	5.4169	5.2125	5.2125	1600.0
2010-06-30	BICK	ETF	27.12	27.272	27.05	27.05	1447.0
2010-06-30	BIL	ETF	91.7	91.74	91.7	91.74	1013900.0
2010-06-30	BIS	ETF	12297.6	12747.2	12272.8	12747.2	18.1
2010-06-30	BITS	ETF	26.8	27.52	26.2	26.672	1125.0
2010-06-30	BIV	ETF	83.72	83.72	83.5	83.7	262500.0
2010-06-30	BJK	ETF	23.18	23.39	22.67	22.72	28700.0
2010-06-30	BKF	ETF	41.3	41.72	40.98	40.99	388439.0
2010-06-30	BLV	ETF	82.5	82.75	82.07	82.69	51500.0
2010-06-30	BMVP	ETF	11.7567	11.8755	11.6333	11.6667	16109.0
2010-06-30	BND	ETF	81.4	81.45	81.23	81.38	1286700.0
2010-06-30	BNE	ETF	11.22	11.24	11.21	11.22	811556.0
2010-06-30	BNO	ETF	25.6	25.77	25.185	25.49	26400.0
2010-06-30	BRF	ETF	44.13	44.73	43.49	43.62	269596.0
2010-06-30	BSCE	ETF	20.45	20.5	20.4484	20.5	35101.0
2010-06-30	BSV	ETF	81.02	81.02	80.93	81.02	458100.0
2010-06-30	BTF	ETF	67.5	67.6	67.39999999999999	67.39999999999999	5242.0
2010-06-30	BWX	ETF	26.755	26.935	26.755	26.875	186640.0
2010-06-30	BWZ	ETF	33.44	33.75	33.44	33.4812	14298.0
2010-06-30	BZQ	ETF	4304.0	4441.6	4161.6	4432.0	1251.0
2010-06-30	CEF	ETF	14.95	15.12	14.95	15.07	722400.0
2010-06-30	CEW	ETF	21.25	21.3779	21.2401	21.26	128033.0

> showing 50 of 757 rows — these rows as CSV

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