PREVIEW / etf_daily / 2009-05-12

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-12.parquet
  size:    29 KB
  rows:    656

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-05-12	SPY	ETF	91.63	91.83	89.85	90.97	282431300.0
2009-05-12	QQQ	ETF	34.42	34.48	33.52	33.93	147842117.0
2009-05-12	IWM	ETF	50.54	50.82	48.71	49.55	49453100.0
2009-05-12	DIA	ETF	84.77	85.28	83.77	84.72	16819400.0
2009-05-12	GLD	ETF	90.4	90.84	89.95	90.7	15764900.0
2009-05-12	TLT	ETF	96.18	97.02	95.8	96.64	2304800.0
2009-05-12	AAXJ	ETF	42.09	42.09	40.97	41.59	258200.0
2009-05-12	ACWI	ETF	33.97	34.16	33.59	33.98	321800.0
2009-05-12	ACWX	ETF	32.93	32.94	32.33	32.67	27955.0
2009-05-12	ADRE	ETF	34.06	34.3616	33.21	33.55	253200.0
2009-05-12	AFK	ETF	24.18	24.8	24.18	24.8	1979.0
2009-05-12	AGG	ETF	101.3	101.84	101.27	101.81	786700.0
2009-05-12	AGQ	ETF	91.34	91.8	89.74	91.4	159700.0
2009-05-12	AGZ	ETF	108.18	108.26	107.6	108.17	8652.0
2009-05-12	AIA	ETF	31.33	31.53	30.9	31.07	49708.0
2009-05-12	AIQ	ETF	38.85	39.15	38.35	38.7	40578.0
2009-05-12	AIS	ETF	0.58	0.58	0.52	0.53	58571.0
2009-05-12	AIVI	ETF	34.43	34.66	34.0	34.49	7700.0
2009-05-12	AMJ	ETF	22.29	22.29	21.625	21.78	31286.0
2009-05-12	AOA	ETF	24.75	24.88	24.52	24.81	1800.0
2009-05-12	AOK	ETF	25.548	26.14	25.5244	26.14	18039.0
2009-05-12	AOM	ETF	25.41	25.63	25.06	25.49	13664.0
2009-05-12	AOR	ETF	24.97	25.27	24.41	25.2	22059.0
2009-05-12	ARB	ETF	20.41	20.71	19.73	20.29	199849.0
2009-05-12	BAL	ETF	34.27	34.27	33.76	33.84	7999.0
2009-05-12	BBH	ETF	29.8133	29.9667	29.4933	29.78	897000.0
2009-05-12	BIL	ETF	91.66	91.76	91.66	91.74	152400.0
2009-05-12	BITS	ETF	18.56	18.56	17.92	18.44	13700.0
2009-05-12	BIV	ETF	77.1	77.31	76.98	77.15	84300.0
2009-05-12	BJK	ETF	21.43	22.15	21.24	21.68	137900.0
2009-05-12	BKF	ETF	33.0	33.45	32.1	32.4	80428.0
2009-05-12	BLV	ETF	73.19	73.19	72.6	72.93	4500.0
2009-05-12	BMVP	ETF	10.73	10.777	10.589	10.693	19625.0
2009-05-12	BND	ETF	77.4	77.54	77.33	77.42	356500.0
2009-05-12	BNE	ETF	5.87	6.1	5.07	5.26	320770.0
2009-05-12	BOSS	ETF	18.0	18.41	17.75	17.75	900.0
2009-05-12	BSV	ETF	79.04	79.26	78.96	79.11	185200.0
2009-05-12	BTF	ETF	48.49999999999999	48.49999999999999	47.699999999999996	48.349999999999994	11314.400000000001
2009-05-12	BWX	ETF	26.55	26.575	26.37	26.435	203122.0
2009-05-12	BWZ	ETF	34.17	34.44	34.15	34.44	1080.0
2009-05-12	CBON	ETF	1.58	1.58	1.37	1.42	53499.0
2009-05-12	CEF	ETF	11.67	11.68	11.51	11.6	753400.0
2009-05-12	CEW	ETF	20.46	20.79	20.2	20.27	204730.0
2009-05-12	CGO	ETF	10.35	10.35	10.08	10.23	34502.0
2009-05-12	CGW	ETF	14.81	14.81	14.49	14.68	33894.0
2009-05-12	CHB	ETF	0.59	0.6	0.56	0.57	455497.0
2009-05-12	CHI	ETF	10.2	10.34	10.08	10.13	245422.0
2009-05-12	CHIC	ETF	11.98	12.31	11.3796	11.57	391971.0
2009-05-12	CHW	ETF	6.55	6.59	6.43	6.51	180847.0
2009-05-12	CHY	ETF	9.67	9.85	9.5624	9.77	319123.0

> showing 50 of 656 rows — these rows as CSV

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