PREVIEW / etf_daily / 2010-01-14

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-14.parquet
  size:    31 KB
  rows:    714

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-14	SPY	ETF	114.49	115.14	114.42	114.93	115718800.0
2010-01-14	QQQ	ETF	46.26	46.52	46.22	46.39	75812668.0
2010-01-14	IWM	ETF	64.14	64.82	64.02	64.62	41859800.0
2010-01-14	DIA	ETF	106.64	107.15	106.58	107.03	7039900.0
2010-01-14	GLD	ETF	111.51	112.37	110.79	112.03	18305300.0
2010-01-14	TLT	ETF	89.69	90.52	89.54	90.52	4188800.0
2010-01-14	AAXJ	ETF	57.46	57.49	57.16	57.29	266600.0
2010-01-14	ACWI	ETF	43.69	43.84	43.57	43.75	56200.0
2010-01-14	ACWX	ETF	42.55	42.71	42.46	42.65	52805.0
2010-01-14	ADRE	ETF	44.92	44.92	44.54	44.59	163220.0
2010-01-14	AFK	ETF	29.82	29.9	29.75	29.9	6235.0
2010-01-14	AGG	ETF	103.97	104.18	103.87	104.07	498600.0
2010-01-14	AGQ	ETF	135.62	137.8	133.7	137.02	146150.0
2010-01-14	AGZ	ETF	108.01	108.2601	108.01	108.25	17860.0
2010-01-14	AIA	ETF	40.71	40.82	40.41	40.72	46129.0
2010-01-14	AIQ	ETF	26.0	26.6	25.95	26.15	37985.0
2010-01-14	AIS	ETF	1.2	1.27	1.1801	1.24	388123.0
2010-01-14	AIVI	ETF	44.74	44.97	44.59	44.97	17900.0
2010-01-14	AMJ	ETF	29.2	29.42	29.12	29.25	345276.0
2010-01-14	AOA	ETF	30.83	30.94	30.81	30.91	17900.0
2010-01-14	AOK	ETF	27.69	27.71	27.63	27.698	6624.0
2010-01-14	AOM	ETF	28.6	28.73	28.59	28.73	17826.0
2010-01-14	AOR	ETF	29.6	29.9	29.6	29.69	41835.0
2010-01-14	ARB	ETF	24.59	24.9	24.5	24.62	240021.0
2010-01-14	BAB	ETF	24.51	24.6	24.49	24.57	208820.0
2010-01-14	BAL	ETF	36.1658	36.1658	35.46	35.54	36052.0
2010-01-14	BBH	ETF	33.18	33.33	33.1167	33.2733	87600.0
2010-01-14	BIL	ETF	91.7	91.72	91.7	91.7	53300.0
2010-01-14	BITS	ETF	31.6	32.32	31.44	32.04	562.0
2010-01-14	BIV	ETF	80.04	80.16	79.85	80.1	98200.0
2010-01-14	BJK	ETF	25.43	25.58	25.4	25.58	5300.0
2010-01-14	BKF	ETF	47.0	47.14	46.72	46.79	224752.0
2010-01-14	BLV	ETF	76.25	76.96	76.14	76.89	16200.0
2010-01-14	BMVP	ETF	12.99	13.039	12.99	13.027	19920.0
2010-01-14	BND	ETF	79.18	79.28	79.13	79.24	777700.0
2010-01-14	BNE	ETF	7.25	7.42	7.04	7.11	134539.0
2010-01-14	BOSS	ETF	19.62	19.62	19.025	19.025	200.0
2010-01-14	BRF	ETF	49.9	50.032	49.3	49.3	501501.0
2010-01-14	BSV	ETF	80.08	80.1	80.0	80.07	294600.0
2010-01-14	BTF	ETF	64.05	64.5	63.8	64.3	5587.0
2010-01-14	BWX	ETF	28.93	28.985	28.764	28.925	288882.0
2010-01-14	BWZ	ETF	37.02	37.12	37.0	37.03	36711.0
2010-01-14	BZQ	ETF	3619.2	3723.2	3590.4	3704.0	126.0
2010-01-14	CEF	ETF	14.54	14.57	14.41	14.5	697400.0
2010-01-14	CEW	ETF	22.32	22.37	22.29	22.37	60947.0
2010-01-14	CGO	ETF	14.93	15.27	14.93	15.174	23208.0
2010-01-14	CGW	ETF	18.99	19.03	18.85	18.97	64044.0
2010-01-14	CHI	ETF	12.77	12.79	12.72	12.76	119909.0
2010-01-14	CHIE	ETF	15.62	15.62	15.25	15.25	17469.0
2010-01-14	CHII	ETF	16.18	16.18	15.99	16.0799	26500.0

> showing 50 of 714 rows — these rows as CSV

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