PREVIEW / etf_daily / 2010-03-10

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-10.parquet
  size:    32 KB
  rows:    728

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-03-10	SPY	ETF	114.51	115.28	114.41	114.97	186088800.0
2010-03-10	QQQ	ETF	46.8	47.28	46.8	47.17	102578892.0
2010-03-10	IWM	ETF	67.04	67.9	67.01	67.55	73655200.0
2010-03-10	DIA	ETF	105.82	106.14	105.38	105.77	7325500.0
2010-03-10	GLD	ETF	109.94	110.5	108.02	108.47	21982100.0
2010-03-10	TLT	ETF	89.49	89.7	89.19	89.59	3216200.0
2010-03-10	AAXJ	ETF	55.89	56.12	55.63	55.85	91700.0
2010-03-10	ACWI	ETF	42.61	42.89	42.54	42.68	108800.0
2010-03-10	ACWX	ETF	40.78	41.0781	40.77	40.92	49879.0
2010-03-10	ADRE	ETF	43.69	43.97	43.52	43.74	78720.0
2010-03-10	AFK	ETF	30.12	30.27	30.12	30.2001	14027.0
2010-03-10	AGG	ETF	104.38	104.51	104.38	104.51	512000.0
2010-03-10	AGQ	ETF	115.1	118.98	109.32	110.0	384050.0
2010-03-10	AGZ	ETF	108.18	108.4	108.18	108.4	87851.0
2010-03-10	AIA	ETF	39.74	40.1881	39.74	40.14	30672.0
2010-03-10	AIQ	ETF	25.0	25.4	24.65	25.0	85361.0
2010-03-10	AIS	ETF	1.4	1.44	1.36	1.39	272802.0
2010-03-10	AIVI	ETF	41.84	42.22	41.8	42.05	14200.0
2010-03-10	AMJ	ETF	30.23	30.39	30.15	30.37	544692.0
2010-03-10	AOA	ETF	30.93	31.07	30.91	31.06	8200.0
2010-03-10	AOK	ETF	27.6	27.73	27.6	27.67	5531.0
2010-03-10	AOM	ETF	28.4852	28.59	28.48	28.57	11833.0
2010-03-10	AOR	ETF	29.44	29.5148	29.38	29.4601	5937.0
2010-03-10	ARB	ETF	23.1	23.77	23.01	23.77	234306.0
2010-03-10	BAB	ETF	24.82	24.82	24.7	24.78	319944.0
2010-03-10	BAL	ETF	38.8	39.0	37.8915	38.3101	7175.0
2010-03-10	BALT	ETF	14.0	14.12	13.53	13.96	7378497.0
2010-03-10	BBH	ETF	34.7467	34.9133	34.7467	34.7667	378300.0
2010-03-10	BIL	ETF	91.68	91.7	91.68	91.7	127200.0
2010-03-10	BITS	ETF	32.76	32.76	32.64	32.64	100.0
2010-03-10	BIV	ETF	80.46	80.64	80.38	80.53	97300.0
2010-03-10	BJK	ETF	24.65	24.72	24.59	24.67	6200.0
2010-03-10	BKF	ETF	45.45	46.09	45.45	45.75	148895.0
2010-03-10	BLV	ETF	76.53	76.74	76.3	76.69	31000.0
2010-03-10	BMVP	ETF	12.95	13.0319	12.95	12.99	11358.0
2010-03-10	BND	ETF	79.29	79.33	79.2	79.33	1147900.0
2010-03-10	BNE	ETF	11.23	11.29	11.22	11.28	1090835.0
2010-03-10	BRF	ETF	47.48	47.75	47.1901	47.6	340339.0
2010-03-10	BSV	ETF	80.2	80.2	80.11	80.17	672800.0
2010-03-10	BTF	ETF	72.55	73.35	72.3	73.1995	5721.0
2010-03-10	BWX	ETF	28.025	28.05	27.935	27.97	200086.0
2010-03-10	BWZ	ETF	35.65	35.78	35.63	35.69	7653.0
2010-03-10	BZQ	ETF	3635.2	3662.4	3536.0	3604.8	837.5
2010-03-10	CEF	ETF	13.87	14.1	13.81	13.81	947400.0
2010-03-10	CEW	ETF	22.1	22.15	22.08	22.12	107455.0
2010-03-10	CGO	ETF	14.56	14.6568	14.14	14.14	107944.0
2010-03-10	CGW	ETF	18.03	18.1899	18.03	18.14	50404.0
2010-03-10	CHI	ETF	12.98	12.98	12.77	12.78	218588.0
2010-03-10	CHIE	ETF	14.52	14.6	14.47	14.57	11850.0
2010-03-10	CHII	ETF	15.5	15.56	15.42	15.47	10630.0

> showing 50 of 728 rows — these rows as CSV

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