PREVIEW / etf_daily / 2009-07-07

all etf daily files

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

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-07	SPY	ETF	89.71	89.82	88.0	88.06	197088900.0
2009-07-07	QQQ	ETF	35.42	35.49	34.51	34.53	149772994.0
2009-07-07	IWM	ETF	49.37	49.5	48.35	48.4	40473600.0
2009-07-07	DIA	ETF	83.16	83.19	81.54	81.55	15240600.0
2009-07-07	GLD	ETF	90.89	91.38	90.5	90.71	7690200.0
2009-07-07	TLT	ETF	93.62	94.88	93.61	94.75	2592400.0
2009-07-07	AAXJ	ETF	43.49	43.72	42.73	42.78	119000.0
2009-07-07	ACWI	ETF	33.83	33.83	33.15	33.19	118200.0
2009-07-07	ACWX	ETF	32.56	32.56	31.9	31.94	36370.0
2009-07-07	ADRE	ETF	33.71	33.78	32.8556	32.88	150038.0
2009-07-07	AFK	ETF	25.94	26.17	25.22	25.45	23435.0
2009-07-07	AGG	ETF	101.99	102.3	101.97	102.26	518600.0
2009-07-07	AGQ	ETF	75.96	76.82	74.98	75.14	84000.0
2009-07-07	AGZ	ETF	108.03	108.05	107.52	108.05	7468.0
2009-07-07	AIA	ETF	31.95	32.0	31.49	31.49	42797.0
2009-07-07	AIQ	ETF	32.7	33.15	32.45	32.45	64537.0
2009-07-07	AIS	ETF	0.9	0.9	0.83	0.84	337306.0
2009-07-07	AIVI	ETF	34.18	34.18	33.56	33.58	7400.0
2009-07-07	AMJ	ETF	22.2	22.2	21.88	21.93	122581.0
2009-07-07	AOA	ETF	24.4	24.5	24.22	24.22	8600.0
2009-07-07	AOK	ETF	25.52	25.55	25.48	25.49	13000.0
2009-07-07	AOM	ETF	25.75	25.75	25.19	25.19	12007.0
2009-07-07	AOR	ETF	25.0799	25.0799	24.8	24.84	10802.0
2009-07-07	ARB	ETF	15.92	16.05	15.49	15.84	217649.0
2009-07-07	BAL	ETF	31.0	31.0001	30.45	30.45	9398.0
2009-07-07	BBH	ETF	30.3533	30.5	30.1567	30.1767	513300.0
2009-07-07	BIL	ETF	91.76	91.76	91.74	91.74	146100.0
2009-07-07	BITS	ETF	20.6	20.6	20.44	20.44	200.0
2009-07-07	BIV	ETF	77.19	77.5	77.05	77.45	101300.0
2009-07-07	BJK	ETF	19.89	20.08	19.57	19.77	62500.0
2009-07-07	BKF	ETF	34.45	34.45	33.28	33.37	199912.0
2009-07-07	BLV	ETF	74.08	74.91	74.08	74.7	17300.0
2009-07-07	BMVP	ETF	10.7315	10.7315	10.5867	10.5952	10196.0
2009-07-07	BND	ETF	77.5	77.68	77.42	77.51	281200.0
2009-07-07	BNE	ETF	6.6	6.65	6.4	6.4	158055.0
2009-07-07	BRF	ETF	28.2	28.26	27.4	27.416	37768.0
2009-07-07	BSV	ETF	79.23	79.32	79.14	79.18	212600.0
2009-07-07	BTF	ETF	47.75	48.49999999999999	47.4505	47.5	18126.4
2009-07-07	BWX	ETF	27.38	27.46	27.17	27.17	156620.0
2009-07-07	BWZ	ETF	35.16	35.16	35.04	35.04	2105.0
2009-07-07	BZQ	ETF	10184.0	10552.0	10184.0	10552.0	2.0
2009-07-07	CBON	ETF	0.9	0.98	0.9	0.98	12652.0
2009-07-07	CEF	ETF	11.41	11.52	11.25	11.38	709900.0
2009-07-07	CEW	ETF	20.87	20.87	20.7	20.72	9533.0
2009-07-07	CGO	ETF	11.27	11.46	10.91	11.14	18104.0
2009-07-07	CGW	ETF	15.21	15.21	14.77	14.77	44349.0
2009-07-07	CHB	ETF	0.3	0.3551	0.3	0.32	1526898.0
2009-07-07	CHI	ETF	10.4	10.4299	10.25	10.35	133178.0
2009-07-07	CHIC	ETF	12.41	12.83	12.32	12.4	219187.0
2009-07-07	CHW	ETF	6.48	6.5	6.36	6.47	147922.0

> showing 50 of 662 rows — these rows as CSV

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