PREVIEW / etf_daily / 2009-01-13

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-13.parquet
  size:    28 KB
  rows:    629

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-13	SPY	ETF	86.73	87.88	86.2	87.11	356432300.0
2009-01-13	QQQ	ETF	29.52	29.98	29.18	29.53	186387347.0
2009-01-13	IWM	ETF	46.63	47.61	46.41	47.32	62644600.0
2009-01-13	DIA	ETF	84.61	85.29	83.83	84.42	29846500.0
2009-01-13	GLD	ETF	80.94	81.82	80.62	80.88	10019100.0
2009-01-13	TLT	ETF	113.5	114.08	112.96	114.02	1767400.0
2009-01-13	AAXJ	ETF	31.32	32.17	31.32	31.74	39200.0
2009-01-13	ACWI	ETF	30.64	30.86	30.4	30.62	133800.0
2009-01-13	ACWX	ETF	28.65	28.93	28.36	28.57	372205.0
2009-01-13	ADRE	ETF	26.12	27.0	26.12	26.69	141671.0
2009-01-13	AFK	ETF	19.67	19.92	19.67	19.92	29009.0
2009-01-13	AGG	ETF	103.3	103.31	102.79	103.22	585600.0
2009-01-13	AGQ	ETF	53.7	56.78	53.7	56.32	19950.0
2009-01-13	AGZ	ETF	108.52	108.89	108.368	108.83	14094.0
2009-01-13	AIA	ETF	24.3	24.62	23.74	24.3958	30995.0
2009-01-13	AIQ	ETF	41.15	42.5	40.5	41.95	35324.0
2009-01-13	AIS	ETF	0.43	0.46	0.43	0.4479	114980.0
2009-01-13	AIVI	ETF	31.89	31.91	31.42	31.65	25900.0
2009-01-13	AOA	ETF	23.85	23.85	23.45	23.45	1200.0
2009-01-13	AOK	ETF	25.46	25.51	25.46	25.5	6655.0
2009-01-13	AOM	ETF	25.45	25.45	24.76	24.96	10193.0
2009-01-13	AOR	ETF	24.3	24.3	24.3	24.3	400.0
2009-01-13	ARB	ETF	15.54	16.02	15.17	15.33	343503.0
2009-01-13	BAL	ETF	27.71	27.71	27.36	27.48	1100.0
2009-01-13	BBH	ETF	57.6667	58.35	57.6567	57.95	236700.0
2009-01-13	BIL	ETF	91.76	91.88	91.7	91.8	1438550.0
2009-01-13	BITS	ETF	19.84	19.84	18.44	18.76	824.0
2009-01-13	BIV	ETF	78.9	78.96	78.45	78.86	305100.0
2009-01-13	BJK	ETF	17.14	17.22	16.93	16.93	3100.0
2009-01-13	BKF	ETF	23.37	23.9	23.05	23.35	71443.0
2009-01-13	BLV	ETF	77.65	77.79	77.56	77.79	6100.0
2009-01-13	BMVP	ETF	10.37	10.53	10.37	10.47	37534.0
2009-01-13	BND	ETF	77.96	78.37	77.82	78.35	235600.0
2009-01-13	BNE	ETF	4.09	4.23	3.66	3.92	251278.0
2009-01-13	BSV	ETF	80.21	80.21	79.57	79.98	98500.0
2009-01-13	BTF	ETF	51.55	51.6995	50.55	51.449999999999996	10078.0
2009-01-13	BWX	ETF	26.175	26.175	26.075	26.16	199402.0
2009-01-13	CBON	ETF	2.41	2.55	2.4	2.5	90593.0
2009-01-13	CDL	ETF	0.22	0.23	0.2	0.21	281372.0
2009-01-13	CEF	ETF	10.06	10.12	9.99	10.09	488100.0
2009-01-13	CGO	ETF	9.8	10.4	9.78	10.27	22605.0
2009-01-13	CGW	ETF	13.5	13.69	13.35	13.49	73973.0
2009-01-13	CHB	ETF	0.73	0.74	0.65	0.65	427232.0
2009-01-13	CHI	ETF	9.77	9.77	9.11	9.4	225257.0
2009-01-13	CHIC	ETF	5.8	5.86	5.39	5.47	150757.0
2009-01-13	CHW	ETF	6.26	6.32	6.19	6.27	343002.0
2009-01-13	CHY	ETF	9.06	9.29	8.98	9.2	271792.0
2009-01-13	CMF	ETF	51.845	52.085	51.737	52.046	7250.0
2009-01-13	CNXT	ETF	0.7578	0.7797	0.75	0.753	214996.0
2009-01-13	COW	ETF	32.83	33.28	32.83	33.06	16593.0

> showing 50 of 629 rows — these rows as CSV

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