PREVIEW / etf_daily / 2010-10-15

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-15.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-10-15	SPY	ETF	118.28	118.35	116.76	117.7	243705000.0
2010-10-15	QQQ	ETF	51.04	51.5	50.63	51.49	104653951.0
2010-10-15	IWM	ETF	71.14	71.25	69.89	70.29	74953500.0
2010-10-15	DIA	ETF	111.43	111.47	110.11	110.68	9377400.0
2010-10-15	GLD	ETF	134.24	134.46	133.07	133.68	26168600.0
2010-10-15	TLT	ETF	100.6	101.05	99.89	100.27	12694700.0
2010-10-15	AADR	ETF	28.78	28.78	28.76	28.77	800.0
2010-10-15	AAXJ	ETF	63.54	63.54	62.76	63.16	226000.0
2010-10-15	ACWI	ETF	45.47	45.47	44.75	45.0	116000.0
2010-10-15	ACWX	ETF	43.55	43.56	43.0	43.24	38751.0
2010-10-15	ADRE	ETF	47.37	47.37	46.59	46.83	235372.0
2010-10-15	AFK	ETF	33.95	34.054	33.66	33.69	8638.0
2010-10-15	AGG	ETF	108.21	108.23	107.97	108.02	882600.0
2010-10-15	AGQ	ETF	209.62	209.7	201.52	204.76	395100.0
2010-10-15	AGZ	ETF	111.46	111.55	111.3	111.3	62504.0
2010-10-15	AIA	ETF	44.48	44.48	43.978	44.27	22536.0
2010-10-15	AIQ	ETF	22.65	22.7	22.1535	22.3	33521.0
2010-10-15	AIS	ETF	1.6	1.63	1.55	1.56	322604.0
2010-10-15	AIVI	ETF	45.53	45.61	45.15	45.44	37200.0
2010-10-15	AMJ	ETF	35.01	35.0935	34.75	34.95	547493.0
2010-10-15	AMLP	ETF	79.25	79.25	78.65	78.95	78820.0
2010-10-15	AOA	ETF	32.8	32.8	32.49	32.52	3500.0
2010-10-15	AOK	ETF	28.75	28.78	28.679	28.68	14129.0
2010-10-15	AOM	ETF	29.64	29.64	29.566	29.59	6832.0
2010-10-15	AOR	ETF	30.8	30.8	30.6	30.648	7767.0
2010-10-15	ARB	ETF	30.07	30.32	29.34	29.85	144725.0
2010-10-15	BAB	ETF	26.19	26.21	26.0	26.03	294713.0
2010-10-15	BAL	ETF	56.47	56.47	53.095	53.645	120155.0
2010-10-15	BALT	ETF	11.28	11.34	10.84	11.01	149046.0
2010-10-15	BBH	ETF	32.5	32.9833	32.42	32.9533	34500.0
2010-10-15	BIB	ETF	6.5412	6.7875	6.5412	6.7875	13600.0
2010-10-15	BICK	ETF	33.69	33.69	33.07	33.27	89055.0
2010-10-15	BIL	ETF	91.7	91.72	91.7	91.7	89350.0
2010-10-15	BIS	ETF	9251.2	9296.0	9118.4	9137.6	51.0
2010-10-15	BITS	ETF	27.12	27.2	27.0	27.2	1300.0
2010-10-15	BIV	ETF	86.83	86.95	86.54	86.66	173300.0
2010-10-15	BJK	ETF	29.98	30.08	29.68	29.85	5200.0
2010-10-15	BKF	ETF	50.71	50.78	50.0224	50.47	86692.0
2010-10-15	BLV	ETF	83.66	83.66	82.84	83.1	93600.0
2010-10-15	BMVP	ETF	13.5982	13.5982	13.4333	13.5233	16413.0
2010-10-15	BND	ETF	82.41	82.54	82.34	82.34	829400.0
2010-10-15	BNE	ETF	11.4	11.41	11.37	11.37	461269.0
2010-10-15	BOSS	ETF	39.69	39.69	39.69	39.69	200.0
2010-10-15	BRF	ETF	61.91	62.05	60.7	61.18	390037.0
2010-10-15	BSCE	ETF	21.13	21.13	21.01	21.029	10760.0
2010-10-15	BSV	ETF	81.88	81.88	81.75	81.76	505900.0
2010-10-15	BTF	ETF	77.8	77.8	77.0	77.24999999999999	1114.8
2010-10-15	BWX	ETF	30.87	30.98	30.7201	30.78	262918.0
2010-10-15	BWZ	ETF	37.99	37.99	37.53	37.73	20285.0
2010-10-15	BZQ	ETF	2438.4	2505.6	2438.4	2480.0	693.0

> showing 50 of 794 rows — these rows as CSV

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