PREVIEW / etf_daily / 2009-12-31

all etf daily files

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

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-31	SPY	ETF	112.77	112.8	111.39	111.44	90637900.0
2009-12-31	QQQ	ETF	46.25	46.275	45.75	45.75	50079160.0
2009-12-31	IWM	ETF	63.23	63.57	62.26	62.44	34407900.0
2009-12-31	DIA	ETF	105.34	105.39	104.03	104.07	5189400.0
2009-12-31	GLD	ETF	107.98	108.11	107.24	107.31	9124700.0
2009-12-31	TLT	ETF	89.76	90.11	89.05	89.89	3242400.0
2009-12-31	AAXJ	ETF	55.92	56.06	55.57	55.71	254700.0
2009-12-31	ACWI	ETF	42.49	42.56	42.23	42.29	582200.0
2009-12-31	ACWX	ETF	41.14	41.25	40.91	40.91	40857.0
2009-12-31	ADRE	ETF	44.13	44.35	44.0	44.13	119610.0
2009-12-31	AFK	ETF	28.11	28.89	28.11	28.4	11571.0
2009-12-31	AGG	ETF	103.04	103.3	102.78	103.19	651800.0
2009-12-31	AGQ	ETF	114.12	114.24	111.74	112.3	114650.0
2009-12-31	AGZ	ETF	107.3308	107.66	107.3308	107.57	11099.0
2009-12-31	AIA	ETF	40.3	40.3	39.95	39.95	10999.0
2009-12-31	AIQ	ETF	28.45	28.95	28.45	28.55	35735.0
2009-12-31	AIS	ETF	1.1	1.14	1.09	1.14	368036.0
2009-12-31	AIVI	ETF	43.99	44.1	43.59	43.59	43500.0
2009-12-31	AMJ	ETF	30.44	30.44	28.4601	28.58	139265.0
2009-12-31	AOA	ETF	30.34	30.34	29.97	29.97	39600.0
2009-12-31	AOK	ETF	27.49	27.5	27.3	27.3	60291.0
2009-12-31	AOM	ETF	28.55	28.55	28.22	28.23	40197.0
2009-12-31	AOR	ETF	29.23	29.23	28.61	28.94	24343.0
2009-12-31	ARB	ETF	24.05	24.18	23.42	23.42	123270.0
2009-12-31	BAB	ETF	24.28	24.36	24.15	24.29	162321.0
2009-12-31	BAL	ETF	37.03	37.228	37.03	37.228	925.0
2009-12-31	BBH	ETF	32.9033	32.9033	32.5133	32.5133	105600.0
2009-12-31	BIL	ETF	91.72	91.74	91.7	91.74	73700.0
2009-12-31	BITS	ETF	30.4	30.4	30.264	30.32	445.0
2009-12-31	BIV	ETF	79.06	79.27	78.75	79.07	59200.0
2009-12-31	BJK	ETF	23.54	23.75	22.62	23.45	37000.0
2009-12-31	BKF	ETF	45.98	46.1881	45.76	45.85	166295.0
2009-12-31	BLV	ETF	75.93	76.16	75.51	76.16	20500.0
2009-12-31	BMVP	ETF	12.87	12.87	12.68	12.68	13610.0
2009-12-31	BND	ETF	78.54	78.64	78.33	78.59	404300.0
2009-12-31	BNE	ETF	6.9	6.9	6.65	6.68	613539.0
2009-12-31	BRF	ETF	49.44	49.58	48.8707	49.41	536030.0
2009-12-31	BSV	ETF	79.55	79.62	79.36	79.54	391500.0
2009-12-31	BTF	ETF	63.4	63.699999999999996	63.4	63.6	3332.0
2009-12-31	BWX	ETF	28.425	28.4848	28.345	28.415	229264.0
2009-12-31	BWZ	ETF	36.47	36.472	36.33	36.42	27755.0
2009-12-31	BZQ	ETF	3668.8	3768.0	3665.6	3705.6	49.5
2009-12-31	CEF	ETF	13.77	13.8	13.6	13.78	866700.0
2009-12-31	CEW	ETF	22.0	22.0099	21.95	22.0	156101.0
2009-12-31	CGO	ETF	14.47	14.5	14.31	14.35	14642.0
2009-12-31	CGW	ETF	18.64	18.64	18.42	18.42	53604.0
2009-12-31	CHI	ETF	12.4	12.45	12.307	12.3227	104331.0
2009-12-31	CHIE	ETF	15.0	15.0	14.99	14.99	104340.0
2009-12-31	CHII	ETF	15.66	15.66	15.46	15.47	26128.0
2009-12-31	CHIQ	ETF	16.72	16.72	16.5	16.5	145227.0

> showing 50 of 711 rows — these rows as CSV

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