PREVIEW / etf_daily / 2010-07-06

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-06.parquet
  size:    33 KB
  rows:    758

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-07-06	SPY	ETF	103.64	104.37	101.88	102.87	256935300.0
2010-07-06	QQQ	ETF	43.09	43.37	42.25	42.6	88591835.0
2010-07-06	IWM	ETF	60.86	61.5	58.66	59.04	89452600.0
2010-07-06	DIA	ETF	97.99	98.62	96.61	97.45	10251400.0
2010-07-06	GLD	ETF	117.67	117.72	116.3	116.51	16846900.0
2010-07-06	TLT	ETF	100.83	101.75	100.74	101.62	6620400.0
2010-07-06	AAXJ	ETF	53.58	53.8	52.66	53.01	150300.0
2010-07-06	ACWI	ETF	38.62	38.75	37.88	38.16	95200.0
2010-07-06	ACWX	ETF	36.51	36.53	35.8	36.11	94052.0
2010-07-06	ADRE	ETF	40.36	40.44	39.44	39.77	103928.0
2010-07-06	AFK	ETF	28.21	28.37	27.77	27.909	7285.0
2010-07-06	AGG	ETF	106.85	107.1	106.75	107.06	553200.0
2010-07-06	AGQ	ETF	115.2	117.18	111.98	114.44	166150.0
2010-07-06	AGZ	ETF	109.84	110.09	109.84	109.96	11906.0
2010-07-06	AIA	ETF	37.85	38.02	37.31	37.36	14603.0
2010-07-06	AIQ	ETF	19.55	19.95	17.75	18.2	54709.0
2010-07-06	AIS	ETF	1.66	1.68	1.59	1.59	897546.0
2010-07-06	AIVI	ETF	37.61	37.77	37.02	37.29	34900.0
2010-07-06	AMJ	ETF	31.11	31.3	30.64	30.86	288902.0
2010-07-06	AOA	ETF	28.39	28.5	28.18	28.23	6200.0
2010-07-06	AOK	ETF	27.24	27.34	27.18	27.218	8322.0
2010-07-06	AOM	ETF	27.62	27.67	27.5446	27.547	13258.0
2010-07-06	AOR	ETF	27.87	27.9401	27.68	27.707	14571.0
2010-07-06	ARB	ETF	25.79	25.95	24.89	25.14	254729.0
2010-07-06	BAB	ETF	26.05	26.17	25.96	26.13	167806.0
2010-07-06	BAL	ETF	36.83	36.9	36.8	36.8	2200.0
2010-07-06	BALT	ETF	10.34	10.53	9.9001	10.03	247503.0
2010-07-06	BBH	ETF	29.4133	29.4533	28.7167	28.92	352500.0
2010-07-06	BIB	ETF	5.1688	5.2263	5.05	5.05	48800.0
2010-07-06	BICK	ETF	27.54	27.54	27.055	27.055	930.0
2010-07-06	BIL	ETF	91.72	91.72	91.7	91.7	715900.0
2010-07-06	BIS	ETF	12750.4	13377.6	12748.8	13377.6	21.2
2010-07-06	BITS	ETF	26.48	27.04	26.08	26.48	775.0
2010-07-06	BIV	ETF	83.48	83.63	83.2	83.5	247400.0
2010-07-06	BJK	ETF	23.24	23.3	22.65	22.76	11600.0
2010-07-06	BKF	ETF	41.9	42.28	41.3	41.575	92413.0
2010-07-06	BLV	ETF	81.81	82.28	81.55	82.22	34000.0
2010-07-06	BMVP	ETF	11.6367	11.7367	11.4667	11.492	11381.0
2010-07-06	BND	ETF	81.14	81.36	81.12	81.34	787900.0
2010-07-06	BNE	ETF	11.23	11.25	11.21	11.23	693760.0
2010-07-06	BNO	ETF	24.33	24.33	24.33	24.33	7800.0
2010-07-06	BRF	ETF	45.19	45.605	44.411	44.895	201919.0
2010-07-06	BSCE	ETF	20.38	20.41	20.38	20.39	9540.0
2010-07-06	BSV	ETF	80.75	80.95	80.75	80.87	675100.0
2010-07-06	BTF	ETF	65.94999999999999	66.69999999999999	64.85	65.1	7297.400000000001
2010-07-06	BWX	ETF	27.405	27.4745	26.84	27.295	214242.0
2010-07-06	BWZ	ETF	34.33	34.36	33.89	34.34	46497.0
2010-07-06	BZQ	ETF	4036.8	4246.4	3987.2	4139.2	609.0
2010-07-06	CEF	ETF	14.64	14.74	14.32	14.49	1332300.0
2010-07-06	CEW	ETF	21.48	21.496	21.401	21.45	55326.0

> showing 50 of 758 rows — these rows as CSV

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