PREVIEW / etf_daily / 2010-06-25

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-25.parquet
  size:    33 KB
  rows:    753

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-25	SPY	ETF	107.74	108.42	106.77	107.87	238726500.0
2010-06-25	QQQ	ETF	45.51	45.66	44.95	45.27	89040244.0
2010-06-25	IWM	ETF	63.78	64.92	63.2	64.63	87177700.0
2010-06-25	DIA	ETF	101.8	102.03	100.83	101.72	10893500.0
2010-06-25	GLD	ETF	122.75	123.13	122.49	122.76	9986700.0
2010-06-25	TLT	ETF	98.32	99.33	98.16	99.05	5148300.0
2010-06-25	AAXJ	ETF	53.79	55.11	53.0	55.11	306900.0
2010-06-25	ACWI	ETF	39.48	39.65	39.06	39.54	316800.0
2010-06-25	ACWX	ETF	36.92	37.0695	36.52	36.97	119840.0
2010-06-25	ADRE	ETF	41.14	41.47	40.72	41.4056	73305.0
2010-06-25	AFK	ETF	28.95	28.996	28.62	28.996	2595.0
2010-06-25	AGG	ETF	106.47	106.79	106.47	106.72	513800.0
2010-06-25	AGQ	ETF	129.64	132.78	128.52	131.7	312650.0
2010-06-25	AGZ	ETF	109.8392	109.97	109.75	109.83	9292.0
2010-06-25	AIA	ETF	38.27	38.57	38.03	38.4096	28771.0
2010-06-25	AIQ	ETF	22.9	23.3	21.35	22.6	106634.0
2010-06-25	AIS	ETF	1.83	1.95	1.795	1.95	6847358.0
2010-06-25	AIVI	ETF	38.52	38.8	38.24	38.67	77100.0
2010-06-25	AMJ	ETF	30.21	30.95	30.21	30.95	1069286.0
2010-06-25	AOA	ETF	29.07	29.21	28.95	29.2	2100.0
2010-06-25	AOK	ETF	27.56	27.6354	27.56	27.635	1451.0
2010-06-25	AOM	ETF	27.88	27.94	27.8146	27.94	8225.0
2010-06-25	AOR	ETF	28.36	28.49	28.21	28.43	6369.0
2010-06-25	ARB	ETF	26.88	27.17	26.47	26.86	204516.0
2010-06-25	BAB	ETF	25.96	26.07	25.88	26.02	272161.0
2010-06-25	BAL	ETF	38.48	38.48	38.3	38.4301	1000.0
2010-06-25	BALT	ETF	11.65	11.91	11.53	11.79	1629473.0
2010-06-25	BBH	ETF	30.4667	31.1467	30.4667	30.79	83700.0
2010-06-25	BIB	ETF	5.6787	5.855	5.6787	5.855	15200.0
2010-06-25	BICK	ETF	27.99	28.3704	27.9	28.13	12257.0
2010-06-25	BIL	ETF	91.72	91.72	91.7	91.72	93800.0
2010-06-25	BIS	ETF	11784.0	11785.6	11406.4	11494.4	11.9
2010-06-25	BITS	ETF	27.24	27.84	27.04	27.64	650.0
2010-06-25	BIV	ETF	82.86	83.1	82.69	82.97	247000.0
2010-06-25	BJK	ETF	24.32	24.63	24.17	24.63	10000.0
2010-06-25	BKF	ETF	43.34	43.459	42.72	43.24	57155.0
2010-06-25	BLV	ETF	80.61	81.22	80.54	81.05	21500.0
2010-06-25	BMVP	ETF	12.15	12.21	12.09	12.15	9797.0
2010-06-25	BND	ETF	80.92	81.09	80.9	81.02	449400.0
2010-06-25	BNE	ETF	11.24	11.25	11.19	11.23	1150286.0
2010-06-25	BNO	ETF	26.065	26.64	26.05	26.575	92200.0
2010-06-25	BRF	ETF	44.92	45.81	44.9	45.74	223693.0
2010-06-25	BSCE	ETF	20.29	20.33	20.2899	20.31	11933.0
2010-06-25	BSV	ETF	80.77	80.86	80.76	80.86	297600.0
2010-06-25	BTF	ETF	67.39999999999999	68.55	67.35	68.55	2345.0
2010-06-25	BWX	ETF	26.765	27.0	26.715	26.945	431232.0
2010-06-25	BWZ	ETF	33.19	33.8599	33.19	33.78	18996.0
2010-06-25	BZQ	ETF	3968.0	4025.6	3825.6	3832.0	765.0
2010-06-25	CEF	ETF	15.2	15.3	15.12	15.3	867000.0
2010-06-25	CEW	ETF	21.47	21.5	21.36	21.489	93419.0

> showing 50 of 753 rows — these rows as CSV

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