PREVIEW / etf_daily / 2009-12-30

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-30.parquet
  size:    31 KB
  rows:    709

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-12-30	SPY	ETF	112.23	112.65	112.17	112.52	73138400.0
2009-12-30	QQQ	ETF	46.0	46.26	45.96	46.17	57612660.0
2009-12-30	IWM	ETF	63.04	63.49	62.65	63.19	45268900.0
2009-12-30	DIA	ETF	104.93	105.33	104.88	105.22	3243500.0
2009-12-30	GLD	ETF	106.64	107.44	106.4	106.93	9399600.0
2009-12-30	TLT	ETF	89.92	90.48	89.86	90.32	1919100.0
2009-12-30	AAXJ	ETF	55.27	55.75	55.27	55.75	81100.0
2009-12-30	ACWI	ETF	42.45	42.45	42.26	42.36	378600.0
2009-12-30	ACWX	ETF	41.0	41.1	40.84	41.06	69014.0
2009-12-30	ADRE	ETF	43.93	44.07	43.79	44.03	147574.0
2009-12-30	AFK	ETF	28.25	28.38	28.01	28.38	7659.0
2009-12-30	AGG	ETF	103.3	103.32	103.08	103.32	532000.0
2009-12-30	AGQ	ETF	112.38	113.16	111.0	111.94	141300.0
2009-12-30	AGZ	ETF	107.52	107.77	107.52	107.77	6844.0
2009-12-30	AIA	ETF	39.73	39.83	39.7	39.814	18126.0
2009-12-30	AIQ	ETF	28.4	28.7	28.1	28.5	25965.0
2009-12-30	AIS	ETF	1.06	1.1	1.06	1.09	175250.0
2009-12-30	AIVI	ETF	43.75	44.05	43.7	43.93	30100.0
2009-12-30	AMJ	ETF	28.61	28.61	28.45	28.58	265184.0
2009-12-30	AOA	ETF	30.12	30.21	30.12	30.21	6500.0
2009-12-30	AOK	ETF	27.4595	27.48	27.4373	27.48	5447.0
2009-12-30	AOM	ETF	28.28	28.33	28.24	28.33	11070.0
2009-12-30	AOR	ETF	29.11	29.14	29.04	29.08	9397.0
2009-12-30	ARB	ETF	24.47	24.65	23.9	24.1	183936.0
2009-12-30	BAB	ETF	24.28	24.36	24.25	24.3399	66450.0
2009-12-30	BAL	ETF	36.9	37.08	36.9	37.01	1934.0
2009-12-30	BBH	ETF	32.6067	32.9567	32.6067	32.91	92400.0
2009-12-30	BIL	ETF	91.72	91.74	91.7	91.72	99200.0
2009-12-30	BITS	ETF	30.36	30.4	30.28	30.32	1226.0
2009-12-30	BIV	ETF	79.28	79.37	79.07	79.21	68600.0
2009-12-30	BJK	ETF	23.48	23.64	23.47	23.56	5800.0
2009-12-30	BKF	ETF	45.65	45.73	45.42	45.69	134075.0
2009-12-30	BLV	ETF	76.33	76.33	75.79	76.22	13800.0
2009-12-30	BMVP	ETF	12.78	12.83	12.77	12.83	32976.0
2009-12-30	BND	ETF	78.61	78.71	78.51	78.65	599000.0
2009-12-30	BNE	ETF	6.87	6.91	6.73	6.88	125969.0
2009-12-30	BOSS	ETF	19.88	20.17	19.88	19.88	100.0
2009-12-30	BRF	ETF	48.86	49.36	48.55	49.1	292228.0
2009-12-30	BSV	ETF	79.67	79.71	79.61	79.67	664000.0
2009-12-30	BTF	ETF	63.449999999999996	63.94	63.349999999999994	63.48	4005.0
2009-12-30	BWX	ETF	28.385	28.5175	28.285	28.385	269896.0
2009-12-30	BWZ	ETF	36.5	36.5	36.16	36.18	84091.0
2009-12-30	BZQ	ETF	3739.2	3760.0	3700.8	3731.2	96.0
2009-12-30	CEF	ETF	13.7	13.7	13.56	13.66	545700.0
2009-12-30	CEW	ETF	21.92	21.93	21.8866	21.92	117875.0
2009-12-30	CGO	ETF	14.52	14.58	14.05	14.33	26922.0
2009-12-30	CGW	ETF	18.53	18.59	18.4201	18.52	82572.0
2009-12-30	CHI	ETF	12.48	12.5	12.36	12.39	129943.0
2009-12-30	CHIE	ETF	14.79	14.9	14.79	14.9	6672.0
2009-12-30	CHII	ETF	15.3725	15.408	15.366	15.4	4073.0

> showing 50 of 709 rows — these rows as CSV

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