PREVIEW / etf_daily / 2010-09-29

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-29.parquet
  size:    34 KB
  rows:    794

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-29	SPY	ETF	114.38	114.91	114.02	114.47	179665800.0
2010-09-29	QQQ	ETF	49.3	49.53	49.11	49.29	81679166.0
2010-09-29	IWM	ETF	67.38	67.95	67.12	67.67	53580600.0
2010-09-29	DIA	ETF	108.35	108.71	108.0	108.31	6281000.0
2010-09-29	GLD	ETF	127.93	128.24	127.52	127.95	12328900.0
2010-09-29	TLT	ETF	106.17	106.27	105.35	105.58	5507100.0
2010-09-29	AADR	ETF	28.26	28.32	28.23	28.32	100100.0
2010-09-29	AAXJ	ETF	60.05	60.48	60.04	60.28	314600.0
2010-09-29	ACWI	ETF	43.32	43.49	43.13	43.3	155600.0
2010-09-29	ACWX	ETF	41.42	41.689	41.33	41.47	39149.0
2010-09-29	ADRE	ETF	44.49	44.9092	44.49	44.75	109295.0
2010-09-29	AFK	ETF	32.28	32.38	32.0	32.0	17347.0
2010-09-29	AGG	ETF	108.72	108.8	108.6	108.69	833500.0
2010-09-29	AGQ	ETF	167.36	169.94	166.0	167.94	212950.0
2010-09-29	AGZ	ETF	111.47	111.5399	111.3432	111.41	8681.0
2010-09-29	AIA	ETF	42.32	42.33	42.1732	42.23	41755.0
2010-09-29	AIQ	ETF	23.35	23.5	22.8	23.05	12805.0
2010-09-29	AIS	ETF	1.43	1.46	1.4	1.45	350219.0
2010-09-29	AIVI	ETF	43.41	43.57	43.21	43.33	14600.0
2010-09-29	AMJ	ETF	33.47	33.69	33.4	33.61	1087190.0
2010-09-29	AMLP	ETF	76.8	77.1	76.7	77.05	120000.0
2010-09-29	AOA	ETF	31.56	31.7	31.51	31.56	4000.0
2010-09-29	AOK	ETF	28.39	28.46	28.38	28.38	3492.0
2010-09-29	AOM	ETF	29.07	29.17	29.07	29.078	3616.0
2010-09-29	AOR	ETF	30.02	30.07	29.9864	30.0401	4781.0
2010-09-29	ARB	ETF	26.83	28.0	26.65	27.89	159633.0
2010-09-29	BAB	ETF	26.92	26.92	26.79	26.8	136065.0
2010-09-29	BAL	ETF	50.04	50.07	49.2401	49.41	45816.0
2010-09-29	BALT	ETF	11.08	11.15	10.9	11.0	163589.0
2010-09-29	BBH	ETF	32.1833	32.1833	31.7133	31.8967	65700.0
2010-09-29	BIB	ETF	6.4062	6.4062	6.4062	6.4062	8000.0
2010-09-29	BICK	ETF	31.55	31.57	31.355	31.49	11935.0
2010-09-29	BIL	ETF	91.7	91.72	91.7	91.7	161500.0
2010-09-29	BIS	ETF	9689.6	9780.8	9688.0	9780.8	1.875
2010-09-29	BITS	ETF	26.84	27.8	26.84	27.16	1325.0
2010-09-29	BIV	ETF	86.88	86.9	86.66	86.78	125300.0
2010-09-29	BJK	ETF	28.21	28.28	28.04	28.12	9800.0
2010-09-29	BKF	ETF	47.31	47.498	46.96	47.46	117046.0
2010-09-29	BLV	ETF	86.2	86.45	85.8	86.08	34000.0
2010-09-29	BMVP	ETF	13.07	13.21	13.07	13.15	5146.0
2010-09-29	BND	ETF	82.78	82.79	82.66	82.7	430600.0
2010-09-29	BNE	ETF	11.0	11.02	10.99	11.02	379371.0
2010-09-29	BNO	ETF	27.055	27.11	27.04	27.11	1200.0
2010-09-29	BRF	ETF	55.79	55.96	55.4397	55.73	675833.0
2010-09-29	BSCE	ETF	21.01	21.01	20.987	20.99	14992.0
2010-09-29	BSV	ETF	81.79	81.8	81.71	81.71	375100.0
2010-09-29	BTF	ETF	75.75	76.1	75.5	75.85	3346.2000000000003
2010-09-29	BWX	ETF	29.94	30.125	29.914	29.96	136632.0
2010-09-29	BWZ	ETF	36.84	36.99	36.74	36.8734	38441.0
2010-09-29	BZQ	ETF	2848.0	2848.0	2763.2	2780.8	1219.0

> showing 50 of 794 rows — these rows as CSV

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