PREVIEW / etf_daily / 2009-07-13

all etf daily files

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

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-13	SPY	ETF	88.31	90.17	87.59	90.1	217413500.0
2009-07-13	QQQ	ETF	34.95	35.6	34.48	35.59	127140297.0
2009-07-13	IWM	ETF	48.29	49.29	47.42	49.26	44825200.0
2009-07-13	DIA	ETF	81.69	83.39	81.39	83.31	14384000.0
2009-07-13	GLD	ETF	89.45	90.69	89.1	90.19	8809500.0
2009-07-13	TLT	ETF	96.32	96.6	95.56	95.69	2604300.0
2009-07-13	AAXJ	ETF	43.38	43.48	42.29	43.48	508000.0
2009-07-13	ACWI	ETF	33.2	33.75	32.87	33.67	22200.0
2009-07-13	ACWX	ETF	31.9	32.45	31.62	32.36	24861.0
2009-07-13	ADRE	ETF	33.0	33.391	32.42	33.36	135369.0
2009-07-13	AFK	ETF	25.0831	26.07	24.75	25.993	9972.0
2009-07-13	AGG	ETF	102.9	103.12	102.77	102.83	397800.0
2009-07-13	AGQ	ETF	68.54	71.94	67.72	71.86	137850.0
2009-07-13	AGZ	ETF	108.32	108.4	107.9	108.05	17924.0
2009-07-13	AIA	ETF	31.5	31.93	31.12	31.93	10131.0
2009-07-13	AIQ	ETF	32.15	33.0	31.45	32.9	43089.0
2009-07-13	AIS	ETF	0.76	0.81	0.7593	0.7985	315983.0
2009-07-13	AIVI	ETF	33.49	34.29	33.49	34.27	4100.0
2009-07-13	AMJ	ETF	22.71	22.76	22.38	22.75	78098.0
2009-07-13	AOA	ETF	24.3	24.67	24.3	24.66	3700.0
2009-07-13	AOK	ETF	25.53	25.58	25.01	25.58	2218.0
2009-07-13	AOM	ETF	25.3497	25.394	25.3497	25.394	700.0
2009-07-13	AOR	ETF	24.91	25.13	24.91	25.13	2370.0
2009-07-13	ARB	ETF	16.28	16.49	15.88	16.49	316566.0
2009-07-13	BAL	ETF	32.48	32.678	32.25	32.51	4650.0
2009-07-13	BBH	ETF	31.34	31.61	31.02	31.5867	496200.0
2009-07-13	BIL	ETF	91.74	91.76	91.72	91.76	430750.0
2009-07-13	BITS	ETF	22.122	22.68	20.9604	21.7996	2594.0
2009-07-13	BIV	ETF	78.07	78.13	77.82	77.89	64500.0
2009-07-13	BJK	ETF	19.22	19.78	19.22	19.69	18200.0
2009-07-13	BKF	ETF	32.96	33.18	32.06	33.16	110553.0
2009-07-13	BLV	ETF	75.78	76.04	75.12	75.17	26300.0
2009-07-13	BMVP	ETF	10.5733	10.75	10.4885	10.75	19976.0
2009-07-13	BND	ETF	78.11	78.19	77.9	77.96	789000.0
2009-07-13	BNE	ETF	6.42	6.58	6.34	6.42	136190.0
2009-07-13	BRF	ETF	27.24	28.07	26.9716	28.04	44080.0
2009-07-13	BSV	ETF	79.52	79.56	79.31	79.46	213300.0
2009-07-13	BTF	ETF	46.6	47.449999999999996	46.5	47.449999999999996	12003.400000000001
2009-07-13	BWX	ETF	27.495	27.525	27.36	27.475	220790.0
2009-07-13	BWZ	ETF	35.02	35.32	35.02	35.32	13972.0
2009-07-13	BZQ	ETF	10720.0	11003.2	10318.4	10318.4	66.0
2009-07-13	CBON	ETF	0.86	0.87	0.81	0.81	3031.0
2009-07-13	CEF	ETF	11.02	11.26	11.0	11.23	475800.0
2009-07-13	CEW	ETF	20.31	20.5499	20.31	20.47	7275.0
2009-07-13	CGO	ETF	11.13	11.29	11.0	11.28	35642.0
2009-07-13	CGW	ETF	14.93	15.059	14.642	15.0	60438.0
2009-07-13	CHB	ETF	0.3266	0.3266	0.3	0.31	313731.0
2009-07-13	CHI	ETF	9.89	10.04	9.86	9.99	152714.0
2009-07-13	CHIC	ETF	11.73	12.24	11.54	12.12	256853.0
2009-07-13	CHW	ETF	6.26	6.46	6.26	6.45	176337.0

> showing 50 of 658 rows — these rows as CSV

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