PREVIEW / etf_daily / 2010-09-08

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-08.parquet
  size:    33 KB
  rows:    773

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-09-08	SPY	ETF	109.86	110.85	109.81	110.41	149924400.0
2010-09-08	QQQ	ETF	45.84	46.45	45.82	46.25	66883924.0
2010-09-08	IWM	ETF	63.26	63.99	63.23	63.48	58863300.0
2010-09-08	DIA	ETF	103.71	104.4	103.68	103.98	5742100.0
2010-09-08	GLD	ETF	122.82	123.42	122.6	122.71	9788900.0
2010-09-08	TLT	ETF	105.09	105.21	104.36	104.86	6698400.0
2010-09-08	AADR	ETF	26.36	26.46	26.3	26.3	4000.0
2010-09-08	AAXJ	ETF	56.52	56.77	56.33	56.5	654000.0
2010-09-08	ACWI	ETF	41.01	41.4	40.99	41.18	56500.0
2010-09-08	ACWX	ETF	39.05	39.41	39.05	39.19	80531.0
2010-09-08	ADRE	ETF	42.26	42.5	42.24	42.27	52703.0
2010-09-08	AFK	ETF	30.17	30.42	30.17	30.28	3155.0
2010-09-08	AGG	ETF	108.2	108.34	108.14	108.25	819800.0
2010-09-08	AGQ	ETF	140.2	142.0	139.48	140.22	147500.0
2010-09-08	AGZ	ETF	111.04	111.04	110.86	110.88	50539.0
2010-09-08	AIA	ETF	39.77	40.0081	39.77	39.93	10215.0
2010-09-08	AIQ	ETF	21.8	22.0	21.25	21.75	39842.0
2010-09-08	AIS	ETF	1.55	1.59	1.51	1.52	765363.0
2010-09-08	AIVI	ETF	40.86	41.23	40.86	40.98	12200.0
2010-09-08	AMJ	ETF	32.79	32.79	32.56	32.6	1505880.0
2010-09-08	AMLP	ETF	76.0	76.0	75.6	75.6	82540.0
2010-09-08	AOA	ETF	30.15	30.28	30.11	30.18	26600.0
2010-09-08	AOK	ETF	27.9901	28.03	27.9901	28.02	3446.0
2010-09-08	AOM	ETF	28.55	28.63	28.55	28.59	12765.0
2010-09-08	AOR	ETF	29.14	29.24	29.14	29.21	5040.0
2010-09-08	ARB	ETF	26.47	26.84	26.36	26.55	60998.0
2010-09-08	BAB	ETF	26.74	26.74	26.61	26.69	235989.0
2010-09-08	BAL	ETF	44.38	44.7499	44.18	44.2999	13083.0
2010-09-08	BALT	ETF	11.08	11.32	11.08	11.13	209690.0
2010-09-08	BBH	ETF	30.79	31.1733	30.79	31.14	88500.0
2010-09-08	BIB	ETF	5.8812	5.9401	5.8812	5.9401	24160.0
2010-09-08	BICK	ETF	29.45	29.538	29.38	29.41	34659.0
2010-09-08	BIL	ETF	91.7	91.72	91.7	91.7	697700.0
2010-09-08	BIS	ETF	11003.2	11003.2	11003.2	11003.2	0.625
2010-09-08	BITS	ETF	24.28	24.4	24.28	24.32	440.0
2010-09-08	BIV	ETF	85.72	85.74	85.51	85.59	176900.0
2010-09-08	BJK	ETF	26.29	26.75	26.29	26.63	46100.0
2010-09-08	BKF	ETF	44.98	45.16	44.61	44.88	105081.0
2010-09-08	BLV	ETF	85.55	85.59	85.1	85.3	27500.0
2010-09-08	BMVP	ETF	12.5467	12.5726	12.52	12.5267	4683.0
2010-09-08	BND	ETF	82.29	82.32	82.19	82.21	499800.0
2010-09-08	BNE	ETF	10.82	11.0	10.81	11.0	531494.0
2010-09-08	BOSS	ETF	29.875	30.1	29.875	30.1	300.0
2010-09-08	BRF	ETF	52.97	53.41	52.95	53.21	328941.0
2010-09-08	BSCE	ETF	20.83	20.84	20.8013	20.825	8189.0
2010-09-08	BSV	ETF	81.43	81.45	81.36	81.42	765900.0
2010-09-08	BTF	ETF	71.85	73.2	71.85	72.84949999999999	4551.8
2010-09-08	BWX	ETF	28.765	28.868	28.595	28.66	249086.0
2010-09-08	BWZ	ETF	35.28	35.39	35.28	35.38	5976.0
2010-09-08	BZQ	ETF	3272.0	3284.8	3222.4	3270.4	621.0

> showing 50 of 773 rows — these rows as CSV

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