PREVIEW / etf_daily / 2009-01-07

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-07.parquet
  size:    28 KB
  rows:    628

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-07	SPY	ETF	92.0	92.26	90.2	90.67	280899200.0
2009-01-07	QQQ	ETF	30.81	30.9	30.19	30.44	134061870.0
2009-01-07	IWM	ETF	50.27	51.35	49.03	49.74	77662100.0
2009-01-07	DIA	ETF	88.88	89.18	87.23	87.86	33165500.0
2009-01-07	GLD	ETF	84.56	84.58	82.21	82.75	13360000.0
2009-01-07	TLT	ETF	111.96	112.68	111.4	112.65	2565600.0
2009-01-07	AAXJ	ETF	35.5	35.5	33.93	34.29	27400.0
2009-01-07	ACWI	ETF	33.06	33.15	32.32	32.48	169500.0
2009-01-07	ACWX	ETF	31.31	31.36	30.57	30.76	215259.0
2009-01-07	ADRE	ETF	29.65	29.65	28.1	28.1	497844.0
2009-01-07	AFK	ETF	21.874	21.874	21.544	21.544	11875.0
2009-01-07	AGG	ETF	104.21	104.28	103.26	103.65	1222800.0
2009-01-07	AGQ	ETF	62.38	62.4	58.34	59.52	47950.0
2009-01-07	AGZ	ETF	107.74	107.74	107.488	107.66	2300.0
2009-01-07	AIA	ETF	26.78	26.8	25.81	26.12	37125.0
2009-01-07	AIQ	ETF	40.85	44.05	40.8	42.35	107926.0
2009-01-07	AIS	ETF	0.4	0.43	0.39	0.42	120350.0
2009-01-07	AIVI	ETF	34.28	34.5	33.87	33.95	52400.0
2009-01-07	AOA	ETF	24.63	24.68	24.39	24.39	5400.0
2009-01-07	AOM	ETF	25.23	25.42	25.23	25.297	3515.0
2009-01-07	AOR	ETF	25.5	25.5	24.84	24.87	5032.0
2009-01-07	ARB	ETF	14.0	17.44	13.73	16.36	1255732.0
2009-01-07	BAL	ETF	29.0	29.49	29.0	29.07	2170.0
2009-01-07	BBH	ETF	57.0033	57.8367	56.9833	57.4833	166500.0
2009-01-07	BIL	ETF	91.62	91.78	91.62	91.76	214050.0
2009-01-07	BITS	ETF	19.88	19.88	19.64	19.84	451.0
2009-01-07	BIV	ETF	78.39	78.44	77.52	77.91	115500.0
2009-01-07	BJK	ETF	19.75	19.76	18.55	18.55	1500.0
2009-01-07	BKF	ETF	27.93	27.93	25.46	25.51	66092.0
2009-01-07	BLV	ETF	77.15	77.52	76.79	77.52	19300.0
2009-01-07	BMVP	ETF	10.95	11.02	10.75	10.79	54673.0
2009-01-07	BND	ETF	78.22	78.22	77.61	78.09	500400.0
2009-01-07	BNE	ETF	6.33	6.33	5.81	5.98	251577.0
2009-01-07	BSV	ETF	80.08	80.44	79.25	79.3	153400.0
2009-01-07	BTF	ETF	54.699999999999996	54.699999999999996	54.45	54.5	7331.0
2009-01-07	BWX	ETF	26.615	26.67	26.46	26.545	520646.0
2009-01-07	CBON	ETF	3.0601	3.33	3.06	3.12	5974.0
2009-01-07	CDL	ETF	0.2	0.22	0.1914	0.21	482083.0
2009-01-07	CEF	ETF	10.78	10.78	10.15	10.21	718500.0
2009-01-07	CGO	ETF	10.8	10.94	10.13	10.19	31492.0
2009-01-07	CGW	ETF	14.85	14.85	14.3	14.4	22506.0
2009-01-07	CHB	ETF	0.76	0.83	0.73	0.74	713283.0
2009-01-07	CHI	ETF	8.94	9.2	8.85	9.2	778860.0
2009-01-07	CHIC	ETF	6.51	6.54	6.12	6.24	286430.0
2009-01-07	CHW	ETF	6.49	6.49	6.0	6.25	216054.0
2009-01-07	CHY	ETF	9.19	9.196	9.02	9.05	567746.0
2009-01-07	CMF	ETF	51.07	51.73	50.975	51.725	22672.0
2009-01-07	CNXT	ETF	0.84	0.84	0.75	0.76	657184.0
2009-01-07	COW	ETF	34.84	34.98	33.95	34.1	19605.0
2009-01-07	CPST	ETF	1.05	1.06	0.99	1.01	1435695.0

> showing 50 of 628 rows — these rows as CSV

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