PREVIEW / etf_daily / 2009-01-09

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-09.parquet
  size:    28 KB
  rows:    635

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-09	SPY	ETF	91.16	91.32	85.36	89.09	330953600.0
2009-01-09	QQQ	ETF	30.79	30.79	29.92	30.07	117168319.0
2009-01-09	IWM	ETF	50.11	50.19	47.92	48.13	82725900.0
2009-01-09	DIA	ETF	87.67	87.76	85.84	86.14	24494100.0
2009-01-09	GLD	ETF	83.34	85.5	83.09	83.92	8861900.0
2009-01-09	TLT	ETF	111.46	113.35	111.27	112.73	2727900.0
2009-01-09	AAXJ	ETF	33.37	33.37	32.42	32.61	93800.0
2009-01-09	ACWI	ETF	32.48	32.48	31.6	31.66	3407400.0
2009-01-09	ACWX	ETF	30.75	30.75	30.07	30.1	124579.0
2009-01-09	ADRE	ETF	28.11	28.2	27.39	27.798	184923.0
2009-01-09	AFK	ETF	20.7	20.7	20.6	20.6	11500.0
2009-01-09	AGG	ETF	102.71	103.31	102.34	102.51	1137600.0
2009-01-09	AGQ	ETF	59.72	65.4	59.32	61.5	116450.0
2009-01-09	AGZ	ETF	108.15	108.5	107.92	108.42	2004.0
2009-01-09	AIA	ETF	24.96	25.16	24.32	25.15	21000.0
2009-01-09	AIQ	ETF	42.85	43.0	41.35	42.1	41190.0
2009-01-09	AIS	ETF	0.44	0.45	0.41	0.44	86023.0
2009-01-09	AIVI	ETF	34.0	34.04	33.26	33.26	10500.0
2009-01-09	AOA	ETF	24.25	24.25	23.99	24.1	4300.0
2009-01-09	AOK	ETF	25.62	25.62	25.62	25.62	1200.0
2009-01-09	AOM	ETF	25.19	25.27	25.152	25.25	2589.0
2009-01-09	AOR	ETF	24.11	24.75	24.11	24.47	7040.0
2009-01-09	ARB	ETF	16.24	16.26	15.9	16.0	516397.0
2009-01-09	BAL	ETF	29.63	29.63	29.04	29.08	1500.0
2009-01-09	BBH	ETF	57.6833	58.3367	56.7733	57.79	606600.0
2009-01-09	BIL	ETF	91.7	91.82	91.64	91.72	87900.0
2009-01-09	BITS	ETF	19.28	19.88	19.0	19.76	1588.0
2009-01-09	BIV	ETF	78.17	78.66	77.9	78.48	65400.0
2009-01-09	BJK	ETF	18.25	18.75	17.8	18.43	2000.0
2009-01-09	BKF	ETF	24.61	24.995	24.57	24.77	37462.0
2009-01-09	BLV	ETF	77.28	78.14	77.28	77.74	8800.0
2009-01-09	BMVP	ETF	10.86	10.86	10.59	10.61	14504.0
2009-01-09	BND	ETF	78.08	78.37	77.98	78.24	203700.0
2009-01-09	BNE	ETF	6.23	6.36	4.89	4.97	338916.0
2009-01-09	BSV	ETF	79.69	79.75	79.14	79.31	123200.0
2009-01-09	BTF	ETF	52.99999999999999	54.4	52.24999999999999	54.349999999999994	6731.0
2009-01-09	BWX	ETF	26.65	26.675	26.51	26.6	266678.0
2009-01-09	CBON	ETF	2.78	2.84	2.6	2.6	23199.0
2009-01-09	CDL	ETF	0.22	0.2618	0.2	0.23	1151573.0
2009-01-09	CEF	ETF	10.21	10.59	10.13	10.27	1017500.0
2009-01-09	CGO	ETF	10.21	10.2724	10.0	10.03	18088.0
2009-01-09	CGW	ETF	14.65	14.65	14.06	14.06	48680.0
2009-01-09	CHB	ETF	0.85	0.85	0.76	0.76	629668.0
2009-01-09	CHI	ETF	9.89	10.04	9.71	9.8001	265531.0
2009-01-09	CHIC	ETF	6.58	6.59	6.12	6.13	192526.0
2009-01-09	CHW	ETF	6.37	6.42	6.08	6.35	342353.0
2009-01-09	CHY	ETF	9.47	9.48	9.25	9.31	321484.0
2009-01-09	CMF	ETF	51.99	51.99	51.46	51.7749	13878.0
2009-01-09	CNXT	ETF	0.86	0.86	0.76	0.79	654836.0
2009-01-09	COW	ETF	33.5	33.5	33.14	33.22	29711.0

> showing 50 of 635 rows — these rows as CSV

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