PREVIEW / etf_daily / 2010-01-15

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-15.parquet
  size:    31 KB
  rows:    718

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-15	SPY	ETF	114.73	114.84	113.2	113.64	212283100.0
2010-01-15	QQQ	ETF	46.46	46.55	45.65	45.85	126866066.0
2010-01-15	IWM	ETF	64.65	64.8	63.27	63.68	68725100.0
2010-01-15	DIA	ETF	106.94	106.98	105.54	106.01	14027400.0
2010-01-15	GLD	ETF	111.35	112.01	110.38	110.86	18002700.0
2010-01-15	TLT	ETF	91.03	91.33	90.98	91.08	4142800.0
2010-01-15	AAXJ	ETF	57.39	57.39	56.59	56.86	881500.0
2010-01-15	ACWI	ETF	43.7	43.7	43.07	43.32	48100.0
2010-01-15	ACWX	ETF	42.45	42.45	41.84	42.05	74934.0
2010-01-15	ADRE	ETF	44.66	44.66	43.85	44.0	156527.0
2010-01-15	AFK	ETF	29.9	29.9	29.5	29.5	7202.0
2010-01-15	AGG	ETF	104.3	104.4	104.18	104.27	575300.0
2010-01-15	AGQ	ETF	135.08	135.08	132.9	133.28	134700.0
2010-01-15	AGZ	ETF	108.28	108.41	108.27	108.27	18838.0
2010-01-15	AIA	ETF	40.86	40.86	40.26	40.43	28956.0
2010-01-15	AIQ	ETF	26.3	26.8	25.9	26.55	104610.0
2010-01-15	AIS	ETF	1.22	1.25	1.19	1.23	256420.0
2010-01-15	AIVI	ETF	44.47	44.47	43.69	43.95	42000.0
2010-01-15	AMJ	ETF	29.3	29.395	29.02	29.3	191362.0
2010-01-15	AOA	ETF	30.83	30.83	30.5	30.6	19000.0
2010-01-15	AOK	ETF	27.65	27.66	27.61	27.66	7400.0
2010-01-15	AOM	ETF	28.72	28.72	28.54	28.58	15589.0
2010-01-15	AOR	ETF	29.68	29.68	29.39	29.47	16534.0
2010-01-15	ARB	ETF	24.75	25.3	24.665	25.25	419040.0
2010-01-15	BAB	ETF	24.66	24.69	24.55	24.63	86175.0
2010-01-15	BAL	ETF	35.26	35.56	35.2	35.2	6790.0
2010-01-15	BBH	ETF	33.2	33.3067	32.8967	33.1667	345600.0
2010-01-15	BIL	ETF	91.7	91.72	91.7	91.7	83700.0
2010-01-15	BITS	ETF	32.24	32.56	31.8004	32.532	1639.0
2010-01-15	BIV	ETF	80.25	80.39	80.12	80.26	141600.0
2010-01-15	BJK	ETF	25.62	25.62	24.99	25.28	8000.0
2010-01-15	BKF	ETF	46.83	46.93	46.01	46.26	172747.0
2010-01-15	BLV	ETF	77.05	77.31	76.95	76.95	32300.0
2010-01-15	BMVP	ETF	13.01	13.01	12.8276	12.87	10977.0
2010-01-15	BND	ETF	79.35	79.43	79.27	79.29	745300.0
2010-01-15	BNE	ETF	7.11	7.21	6.88	7.03	190180.0
2010-01-15	BOSS	ETF	19.09	20.03	19.01	20.03	100.0
2010-01-15	BRF	ETF	49.5	49.7	48.57	48.83	489842.0
2010-01-15	BSV	ETF	80.18	80.23	80.13	80.19	563300.0
2010-01-15	BTF	ETF	63.849999999999994	64.4	63.849999999999994	63.955	1228.6000000000001
2010-01-15	BWX	ETF	28.89	28.905	28.71	28.885	319276.0
2010-01-15	BWZ	ETF	36.93	37.02	36.55	36.82	128602.0
2010-01-15	BZQ	ETF	3686.4	3844.8	3686.4	3801.6	219.0
2010-01-15	CEF	ETF	14.44	14.47	14.31	14.4	652500.0
2010-01-15	CEW	ETF	22.38	22.38	22.28	22.35	122135.0
2010-01-15	CGO	ETF	15.19	15.19	14.93	15.03	34070.0
2010-01-15	CGW	ETF	18.95	18.96	18.66	18.76	89935.0
2010-01-15	CHI	ETF	12.78	12.81	12.62	12.725	138405.0
2010-01-15	CHIE	ETF	15.0502	15.06	15.01	15.032	9068.0
2010-01-15	CHII	ETF	16.1	16.1	15.8	15.82	21082.0

> showing 50 of 718 rows — these rows as CSV

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