PREVIEW / etf_daily / 2010-01-22

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-22.parquet
  size:    31 KB
  rows:    720

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-01-22	SPY	ETF	111.2	111.74	109.09	109.21	345942400.0
2010-01-22	QQQ	ETF	45.34	45.48	44.04	44.16	171098633.0
2010-01-22	IWM	ETF	62.76	63.06	61.18	61.73	83757000.0
2010-01-22	DIA	ETF	103.38	103.86	101.55	101.63	24606900.0
2010-01-22	GLD	ETF	106.93	107.68	106.01	107.17	24210100.0
2010-01-22	TLT	ETF	92.09	92.31	91.77	92.0	3666900.0
2010-01-22	AAXJ	ETF	54.64	54.74	53.54	53.77	359300.0
2010-01-22	ACWI	ETF	41.98	42.01	41.07	41.09	74900.0
2010-01-22	ACWX	ETF	40.34	40.44	39.57	39.62	95514.0
2010-01-22	ADRE	ETF	41.73	41.85	41.01	41.15	300530.0
2010-01-22	AFK	ETF	29.05	29.1299	28.6	28.7	22829.0
2010-01-22	AGG	ETF	104.38	104.64	104.35	104.46	426600.0
2010-01-22	AGQ	ETF	115.0	115.56	111.34	114.3	416900.0
2010-01-22	AGZ	ETF	108.382	108.74	108.33	108.7199	54159.0
2010-01-22	AIA	ETF	38.96	39.13	38.22	38.22	51411.0
2010-01-22	AIQ	ETF	26.05	26.2505	25.8	25.8	34086.0
2010-01-22	AIS	ETF	1.21	1.23	1.11	1.17	683440.0
2010-01-22	AIVI	ETF	42.39	42.57	41.47	41.59	97800.0
2010-01-22	AMJ	ETF	29.52	29.7	29.26	29.47	369464.0
2010-01-22	AOA	ETF	30.01	30.01	29.43	29.43	19300.0
2010-01-22	AOK	ETF	27.42	27.5	27.358	27.4	22987.0
2010-01-22	AOM	ETF	28.26	28.26	28.08	28.08	7693.0
2010-01-22	AOR	ETF	29.02	29.028	28.68	28.68	19855.0
2010-01-22	ARB	ETF	25.78	26.33	25.7	26.03	306177.0
2010-01-22	BAB	ETF	24.92	24.95	24.87	24.935	79360.0
2010-01-22	BAL	ETF	34.82	34.956	34.7	34.76	17060.0
2010-01-22	BBH	ETF	33.0833	33.46	33.0833	33.1533	170100.0
2010-01-22	BIL	ETF	91.72	91.72	91.7	91.7	103850.0
2010-01-22	BITS	ETF	32.12	32.4	31.88	32.16	792.0
2010-01-22	BIV	ETF	80.59	80.75	80.47	80.64	73500.0
2010-01-22	BJK	ETF	24.93	24.94	24.26	24.26	33200.0
2010-01-22	BKF	ETF	43.62	43.9555	42.91	43.16	502620.0
2010-01-22	BLV	ETF	77.87	78.02	77.6	77.88	30400.0
2010-01-22	BMVP	ETF	12.65	12.65	12.4	12.41	23376.0
2010-01-22	BND	ETF	79.6	79.66	79.5	79.5	403200.0
2010-01-22	BNE	ETF	6.51	6.76	6.49	6.5	128812.0
2010-01-22	BRF	ETF	45.22	45.84	44.56	45.37	1091591.0
2010-01-22	BSV	ETF	80.26	80.28	80.15	80.27	423800.0
2010-01-22	BTF	ETF	66.2	66.2	64.6	64.63	7733.6
2010-01-22	BWX	ETF	28.545	28.545	28.3	28.485	313474.0
2010-01-22	BWZ	ETF	36.45	36.45	36.24	36.3	24279.0
2010-01-22	BZQ	ETF	4323.2	4443.2	4233.6	4388.8	737.0
2010-01-22	CEF	ETF	13.63	13.71	13.43	13.57	1564300.0
2010-01-22	CEW	ETF	21.92	21.96	21.84	21.89	192705.0
2010-01-22	CGO	ETF	14.76	14.76	14.47	14.57	38535.0
2010-01-22	CGW	ETF	18.34	18.36	17.95	17.98	154062.0
2010-01-22	CHI	ETF	12.53	12.53	12.18	12.38	208327.0
2010-01-22	CHIE	ETF	14.15	14.18	13.84	13.84	14095.0
2010-01-22	CHII	ETF	14.99	15.04	14.67	14.72	70669.0
2010-01-22	CHIM	ETF	26.04	26.66	25.66	25.8	2964.0

> showing 50 of 720 rows — these rows as CSV

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