PREVIEW / etf_daily / 2009-07-14

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-14.parquet
  size:    29 KB
  rows:    657

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-07-14	SPY	ETF	90.38	90.69	89.73	90.61	181487400.0
2009-07-14	QQQ	ETF	35.52	35.79	35.4	35.72	115631626.0
2009-07-14	IWM	ETF	49.25	49.72	48.95	49.55	32721400.0
2009-07-14	DIA	ETF	83.54	83.71	82.93	83.66	10288300.0
2009-07-14	GLD	ETF	90.86	91.11	90.59	90.81	5720900.0
2009-07-14	TLT	ETF	94.76	95.13	93.7	94.1	3629100.0
2009-07-14	AAXJ	ETF	43.59	43.99	43.43	43.99	142700.0
2009-07-14	ACWI	ETF	33.92	34.04	33.73	33.94	132900.0
2009-07-14	ACWX	ETF	32.67	32.68	32.46	32.63	37283.0
2009-07-14	ADRE	ETF	33.6	33.84	33.376	33.7	98192.0
2009-07-14	AFK	ETF	25.75	26.0475	25.75	25.8	1600.0
2009-07-14	AGG	ETF	102.6	102.77	102.41	102.52	529700.0
2009-07-14	AGQ	ETF	72.78	73.84	72.14	72.68	139050.0
2009-07-14	AGZ	ETF	108.2	108.2	107.45	107.81	20399.0
2009-07-14	AIA	ETF	32.21	32.27	32.01	32.27	20831.0
2009-07-14	AIQ	ETF	32.55	33.25	32.5	33.2	14627.0
2009-07-14	AIS	ETF	0.8	0.82	0.78	0.81	183277.0
2009-07-14	AIVI	ETF	34.37	34.43	34.1	34.34	87500.0
2009-07-14	AMJ	ETF	22.84	22.87	22.48	22.85	111593.0
2009-07-14	AOA	ETF	24.65	24.78	24.59	24.78	4400.0
2009-07-14	AOK	ETF	25.16	25.6299	25.16	25.4496	2454.0
2009-07-14	AOM	ETF	25.3401	25.44	25.3401	25.44	2174.0
2009-07-14	AOR	ETF	25.25	27.0	25.0894	25.2	12605.0
2009-07-14	ARB	ETF	16.43	16.43	16.06	16.36	161803.0
2009-07-14	BAL	ETF	32.6272	33.0	32.6272	33.0	2834.0
2009-07-14	BBH	ETF	31.6633	31.9133	31.3933	31.4967	367200.0
2009-07-14	BIL	ETF	91.76	91.76	91.74	91.76	143300.0
2009-07-14	BITS	ETF	21.998	22.0	21.8	21.8	430.0
2009-07-14	BIV	ETF	77.79	77.86	77.52	77.66	50300.0
2009-07-14	BJK	ETF	19.83	20.28	19.81	20.1	12200.0
2009-07-14	BKF	ETF	33.66	33.8	33.13	33.47	111902.0
2009-07-14	BLV	ETF	75.13	75.19	74.5	74.53	12100.0
2009-07-14	BMVP	ETF	10.76	10.8	10.72	10.8	10274.0
2009-07-14	BND	ETF	77.84	77.86	77.53	77.73	374300.0
2009-07-14	BNE	ETF	6.4	6.6296	6.38	6.4	123010.0
2009-07-14	BOSS	ETF	14.96	14.96	14.75	14.75	100.0
2009-07-14	BRF	ETF	28.38	28.48	27.93	28.24	62173.0
2009-07-14	BSV	ETF	79.29	79.29	79.12	79.26	310000.0
2009-07-14	BTF	ETF	47.75	48.3495	47.75	48.2	17027.4
2009-07-14	BWX	ETF	27.465	27.465	27.297	27.4	232018.0
2009-07-14	BWZ	ETF	35.22	35.31	35.1188	35.14	6025.0
2009-07-14	BZQ	ETF	10144.0	10144.0	10144.0	10144.0	3.25
2009-07-14	CBON	ETF	0.86	0.86	0.8	0.82	16880.0
2009-07-14	CEF	ETF	11.38	11.43	11.31	11.43	596200.0
2009-07-14	CEW	ETF	20.58	20.6	20.572	20.6	1940.0
2009-07-14	CGO	ETF	11.39	11.45	11.34	11.4	17244.0
2009-07-14	CGW	ETF	14.97	15.14	14.91	15.09	108502.0
2009-07-14	CHB	ETF	0.31	0.31	0.278	0.29	702500.0
2009-07-14	CHI	ETF	9.93	10.39	9.93	10.33	126624.0
2009-07-14	CHIC	ETF	12.13	12.65	11.94	12.55	343593.0

> showing 50 of 657 rows — these rows as CSV

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