PREVIEW / etf_daily / 2009-08-18

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-18.parquet
  size:    29 KB
  rows:    667

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-08-18	SPY	ETF	98.53	99.44	98.35	99.09	173461500.0
2009-08-18	QQQ	ETF	38.72	39.98	38.61	39.03	84607838.0
2009-08-18	IWM	ETF	55.2	55.89	54.92	55.55	39358200.0
2009-08-18	DIA	ETF	91.88	92.59	91.75	92.3	8539100.0
2009-08-18	GLD	ETF	91.81	92.2	91.76	92.06	4354600.0
2009-08-18	TLT	ETF	94.66	94.77	94.01	94.18	2557900.0
2009-08-18	AAXJ	ETF	48.0	48.3	47.73	48.3	155100.0
2009-08-18	ACWI	ETF	37.3	37.77	37.3	37.58	145100.0
2009-08-18	ACWX	ETF	36.25	36.69	36.22	36.69	43003.0
2009-08-18	ADRE	ETF	37.27	37.657	37.22	37.51	101403.0
2009-08-18	AFK	ETF	27.19	27.59	27.19	27.418	8935.0
2009-08-18	AGG	ETF	103.42	103.55	103.22	103.22	442400.0
2009-08-18	AGQ	ETF	82.14	83.74	81.74	82.92	82450.0
2009-08-18	AGZ	ETF	107.7	107.7	107.5	107.6	21587.0
2009-08-18	AIA	ETF	35.14	35.43	35.1	35.43	14190.0
2009-08-18	AIQ	ETF	25.75	25.85	25.35	25.85	123260.0
2009-08-18	AIS	ETF	0.95	0.98	0.94	0.96	249106.0
2009-08-18	AIVI	ETF	38.04	38.79	37.98	38.79	18700.0
2009-08-18	AMJ	ETF	23.89	24.17	23.89	24.1499	104704.0
2009-08-18	AOA	ETF	27.16	27.16	27.04	27.11	7200.0
2009-08-18	AOK	ETF	26.36	26.42	26.25	26.41	3779.0
2009-08-18	AOM	ETF	26.6594	26.74	26.6594	26.66	5571.0
2009-08-18	AOR	ETF	27.16	27.16	26.7601	26.9764	15101.0
2009-08-18	ARB	ETF	16.34	16.57	15.9	16.5	228249.0
2009-08-18	BAL	ETF	30.63	30.88	30.6	30.78	9085.0
2009-08-18	BBH	ETF	32.5067	32.74	32.4467	32.5767	141000.0
2009-08-18	BIL	ETF	91.74	91.74	91.7	91.74	73450.0
2009-08-18	BITS	ETF	21.48	21.76	21.48	21.6	1000.0
2009-08-18	BIV	ETF	78.94	79.04	78.57	78.79	124700.0
2009-08-18	BJK	ETF	22.4	23.06	22.4	22.88	23200.0
2009-08-18	BKF	ETF	37.3	37.63	37.13	37.58	154826.0
2009-08-18	BLV	ETF	76.82	77.26	76.71	76.84	19400.0
2009-08-18	BMVP	ETF	11.407	11.481	11.383	11.45	12933.0
2009-08-18	BND	ETF	78.58	78.61	78.26	78.47	466600.0
2009-08-18	BNE	ETF	6.0	6.12	5.83	6.04	338520.0
2009-08-18	BOSS	ETF	18.3	19.01	18.3	19.01	200.0
2009-08-18	BRF	ETF	34.45	35.33	34.01	35.29	147825.0
2009-08-18	BSV	ETF	79.65	79.65	79.54	79.62	262000.0
2009-08-18	BTF	ETF	57.4	57.69	57.05	57.5	8240.0
2009-08-18	BWX	ETF	28.065	28.071	27.845	27.91	161230.0
2009-08-18	BWZ	ETF	35.7	35.79	35.5	35.79	24174.0
2009-08-18	BZQ	ETF	7393.6	7409.6	7171.2	7172.8	65.0
2009-08-18	CEF	ETF	11.62	11.9	11.62	11.87	763300.0
2009-08-18	CEW	ETF	21.09	21.27	21.062	21.27	11281.0
2009-08-18	CGO	ETF	12.65	12.93	12.65	12.75	15914.0
2009-08-18	CGW	ETF	15.86	16.21	15.86	16.17	29239.0
2009-08-18	CHB	ETF	0.42	0.44	0.39	0.39	1353975.0
2009-08-18	CHI	ETF	10.84	11.0706	10.82	10.9834	174680.0
2009-08-18	CHIC	ETF	13.78	14.08	13.76	13.94	333259.0
2009-08-18	CHW	ETF	7.11	7.22	7.1001	7.1915	148925.0

> showing 50 of 667 rows — these rows as CSV

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