PREVIEW / etf_daily / 2009-01-05

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-05.parquet
  size:    28 KB
  rows:    632

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
2009-01-05	SPY	ETF	92.63	93.66	91.89	92.85	240349700.0
2009-01-05	QQQ	ETF	30.82	31.33	30.59	31.02	91816603.0
2009-01-05	IWM	ETF	50.49	50.8	49.39	50.4	59247000.0
2009-01-05	DIA	ETF	89.87	90.33	88.87	89.7	25612100.0
2009-01-05	GLD	ETF	83.62	84.68	83.24	84.48	9534700.0
2009-01-05	TLT	ETF	115.6	116.16	112.6	113.35	5395200.0
2009-01-05	AAXJ	ETF	35.68	35.93	35.06	35.78	189200.0
2009-01-05	ACWI	ETF	32.81	33.26	32.71	32.98	171800.0
2009-01-05	ACWX	ETF	30.78	31.3	30.78	31.17	654342.0
2009-01-05	ADRE	ETF	28.71	29.65	28.61	29.34	250981.0
2009-01-05	AFK	ETF	21.495	21.65	21.34	21.38	10588.0
2009-01-05	AGG	ETF	103.5	105.32	103.1	105.2	3306400.0
2009-01-05	AGQ	ETF	60.0	62.64	56.4	62.64	39550.0
2009-01-05	AGZ	ETF	107.698	107.7	107.264	107.264	2009.0
2009-01-05	AIA	ETF	27.86	27.86	26.86	27.03	5340.0
2009-01-05	AIQ	ETF	40.4	40.95	39.8	40.25	81947.0
2009-01-05	AIS	ETF	0.39	0.43	0.37	0.43	78356.0
2009-01-05	AIVI	ETF	33.69	34.27	33.69	33.95	140200.0
2009-01-05	AOA	ETF	24.79	25.32	24.0	24.87	13500.0
2009-01-05	AOK	ETF	25.52	25.52	25.31	25.31	153000.0
2009-01-05	AOM	ETF	25.38	26.45	25.35	26.45	102170.0
2009-01-05	AOR	ETF	27.45	27.45	24.85	25.14	454889.0
2009-01-05	ARB	ETF	13.55	13.99	13.38	13.91	376415.0
2009-01-05	BAL	ETF	27.7	28.34	27.7	28.1201	1670.0
2009-01-05	BBH	ETF	57.7967	57.8367	56.8367	57.8333	171900.0
2009-01-05	BIL	ETF	91.78	91.78	91.58	91.6	196850.0
2009-01-05	BITS	ETF	18.88	19.56	18.12	19.24	1611.0
2009-01-05	BIV	ETF	78.24	78.65	77.51	78.4	206200.0
2009-01-05	BJK	ETF	18.5	18.74	18.5	18.74	1100.0
2009-01-05	BKF	ETF	26.67	27.29	26.28	26.8601	44382.0
2009-01-05	BLV	ETF	77.82	78.4	77.38	77.52	42800.0
2009-01-05	BMVP	ETF	11.07	11.18	10.97	11.1	30295.0
2009-01-05	BND	ETF	78.47	78.85	77.9	78.35	648200.0
2009-01-05	BNE	ETF	6.44	6.44	5.6	5.87	131676.0
2009-01-05	BSV	ETF	79.94	79.97	79.08	79.2	150300.0
2009-01-05	BTF	ETF	51.9	53.49999999999999	51.449999999999996	53.2	18162.2
2009-01-05	BWX	ETF	26.675	26.675	26.475	26.65	400620.0
2009-01-05	CBON	ETF	3.55	3.55	3.0	3.06	14100.0
2009-01-05	CDL	ETF	0.1979	0.21	0.19	0.21	571821.0
2009-01-05	CEF	ETF	10.64	10.71	10.3	10.51	879100.0
2009-01-05	CGO	ETF	10.19	10.48	10.1105	10.12	28475.0
2009-01-05	CGW	ETF	14.8	14.8	14.4401	14.66	44253.0
2009-01-05	CHB	ETF	0.66	0.73	0.65	0.65	600765.0
2009-01-05	CHI	ETF	8.86	9.14	8.85	9.04	332135.0
2009-01-05	CHIC	ETF	6.88	6.89	6.0	6.19	321657.0
2009-01-05	CHW	ETF	6.17	6.18	5.95	6.17	193932.0
2009-01-05	CHY	ETF	8.85	8.85	8.6	8.77	464258.0
2009-01-05	CMF	ETF	50.835	51.215	50.23	51.12	13214.0
2009-01-05	CNXT	ETF	0.8	0.8	0.76	0.79	574688.0
2009-01-05	COW	ETF	34.66	34.66	34.2	34.37	12502.0

> showing 50 of 632 rows — these rows as CSV

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