PREVIEW / etf_daily / 2009-03-13

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-13.parquet
  size:    28 KB
  rows:    637

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-03-13	SPY	ETF	76.01	76.98	74.73	76.09	337474700.0
2009-03-13	QQQ	ETF	28.68	28.84	28.32	28.74	156783498.0
2009-03-13	IWM	ETF	39.33	39.66	38.76	39.37	72449700.0
2009-03-13	DIA	ETF	72.19	72.59	71.2	72.32	21835800.0
2009-03-13	GLD	ETF	91.87	91.89	90.5	91.3	11693100.0
2009-03-13	TLT	ETF	102.75	103.88	102.33	102.73	2504000.0
2009-03-13	AAXJ	ETF	30.65	31.01	30.47	30.9	67000.0
2009-03-13	ACWI	ETF	26.6	26.68	26.22	26.57	75500.0
2009-03-13	ACWX	ETF	24.62	24.81	24.4199	24.76	31409.0
2009-03-13	ADRE	ETF	26.67	26.78	26.23	26.6	178347.0
2009-03-13	AFK	ETF	18.7705	18.7705	18.65	18.6501	500.0
2009-03-13	AGG	ETF	100.4	100.74	100.35	100.67	561400.0
2009-03-13	AGQ	ETF	81.86	82.4	79.66	81.84	74750.0
2009-03-13	AGZ	ETF	107.5	107.95	107.37	107.71	16531.0
2009-03-13	AIA	ETF	24.0	24.0	23.36	23.44	24416.0
2009-03-13	AIQ	ETF	33.05	35.65	32.5	35.4	60560.0
2009-03-13	AIS	ETF	0.37	0.39	0.37	0.39	59800.0
2009-03-13	AIVI	ETF	26.12	26.12	25.56	25.94	33100.0
2009-03-13	AOA	ETF	21.56	22.47	20.15	20.7	10200.0
2009-03-13	AOK	ETF	24.37	24.45	24.37	24.45	3240.0
2009-03-13	AOM	ETF	24.2	24.2	23.2399	23.3	6165.0
2009-03-13	AOR	ETF	22.25	22.29	21.36	22.13	6961.0
2009-03-13	ARB	ETF	13.3	13.3	12.83	12.96	244278.0
2009-03-13	BAL	ETF	24.28	24.3	24.28	24.3	2600.0
2009-03-13	BBH	ETF	57.1433	58.0533	56.9033	57.42	838500.0
2009-03-13	BIL	ETF	91.72	91.76	91.68	91.7	299750.0
2009-03-13	BITS	ETF	17.2	17.28	15.68	16.88	1478.0
2009-03-13	BIV	ETF	75.14	75.73	75.04	75.53	60600.0
2009-03-13	BJK	ETF	15.09	15.5	14.13	14.8	1204900.0
2009-03-13	BKF	ETF	23.68	23.68	23.04	23.42	40737.0
2009-03-13	BLV	ETF	72.24	72.68	72.0	72.24	35300.0
2009-03-13	BMVP	ETF	9.2	9.42	9.2	9.4	34985.0
2009-03-13	BND	ETF	76.36	76.49	76.08	76.27	407000.0
2009-03-13	BNE	ETF	2.03	2.06	1.71	1.83	346957.0
2009-03-13	BSV	ETF	78.3	78.3	77.8	78.18	178200.0
2009-03-13	BTF	ETF	37.449999999999996	37.85	36.6	36.699999999999996	6159.400000000001
2009-03-13	BWX	ETF	24.815	24.895	24.73	24.86	343546.0
2009-03-13	BWZ	ETF	32.01	32.02	31.94	32.02	29301.0
2009-03-13	CBON	ETF	0.97	1.11	0.969	1.04	14888.0
2009-03-13	CEF	ETF	12.06	12.07	11.82	11.93	779300.0
2009-03-13	CGO	ETF	8.34	8.7	8.34	8.638	21754.0
2009-03-13	CGW	ETF	11.1	11.32	11.05	11.22	35248.0
2009-03-13	CHB	ETF	0.15	0.18	0.13	0.16	2309735.0
2009-03-13	CHI	ETF	8.01	8.1	7.8	8.05	232967.0
2009-03-13	CHIC	ETF	6.62	6.82	6.3	6.56	95862.0
2009-03-13	CHW	ETF	4.97	4.99	4.72	4.91	185072.0
2009-03-13	CHY	ETF	7.99	7.99	7.84	7.97	166421.0
2009-03-13	CMF	ETF	50.63	50.835	50.63	50.822	8256.0
2009-03-13	CNXT	ETF	0.47	0.52	0.47	0.48	280138.0
2009-03-13	COW	ETF	31.59	31.59	31.22	31.31	17390.0

> showing 50 of 637 rows — these rows as CSV

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