PREVIEW / etf_daily / 2009-09-01

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-01.parquet
  size:    29 KB
  rows:    669

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-09-01	SPY	ETF	101.95	103.24	99.99	100.2	321276800.0
2009-09-01	QQQ	ETF	39.87	40.59	39.16	39.28	162958867.0
2009-09-01	IWM	ETF	56.86	58.13	55.7	55.92	77077500.0
2009-09-01	DIA	ETF	94.6	95.66	92.98	93.21	17938600.0
2009-09-01	GLD	ETF	93.41	93.96	93.06	93.9	8002400.0
2009-09-01	TLT	ETF	95.82	96.58	95.14	96.06	3304200.0
2009-09-01	AAXJ	ETF	48.17	49.0	47.34	47.44	115100.0
2009-09-01	ACWI	ETF	38.84	39.12	38.0	38.04	56000.0
2009-09-01	ACWX	ETF	37.47	37.9	36.9	36.99	50006.0
2009-09-01	ADRE	ETF	37.56	38.1555	36.71	36.73	333133.0
2009-09-01	AFK	ETF	27.67	27.8799	27.1	27.13	7287.0
2009-09-01	AGG	ETF	103.56	103.81	103.36	103.51	816200.0
2009-09-01	AGQ	ETF	92.8	96.28	91.26	95.28	184000.0
2009-09-01	AGZ	ETF	107.94	108.5	107.75	108.48	17971.0
2009-09-01	AIA	ETF	35.48	36.04	34.98	35.034	53315.0
2009-09-01	AIQ	ETF	26.5	27.695	26.25	26.45	148937.0
2009-09-01	AIS	ETF	0.9301	0.95	0.89	0.9	174545.0
2009-09-01	AIVI	ETF	40.25	40.56	39.21	39.37	17800.0
2009-09-01	AMJ	ETF	23.82	23.93	23.51	23.53	170029.0
2009-09-01	AOA	ETF	27.8	27.98	26.0	27.33	43100.0
2009-09-01	AOK	ETF	26.95	26.95	26.42	26.5799	9717.0
2009-09-01	AOM	ETF	27.39	27.39	26.78	26.918	32644.0
2009-09-01	AOR	ETF	27.54	27.54	26.94	27.23	58649.0
2009-09-01	ARB	ETF	18.25	18.9	17.54	17.64	336932.0
2009-09-01	BAL	ETF	31.0192	31.0192	29.99	30.18	4000.0
2009-09-01	BBH	ETF	32.94	33.7033	32.7633	32.9533	342600.0
2009-09-01	BIL	ETF	91.74	91.74	91.68	91.68	438500.0
2009-09-01	BITS	ETF	20.0	20.36	19.4	20.0	14868.0
2009-09-01	BIV	ETF	79.37	80.25	79.1	79.67	241100.0
2009-09-01	BJK	ETF	23.64	24.07	22.9	23.0	37600.0
2009-09-01	BKF	ETF	37.4	37.85	36.27	36.5	518700.0
2009-09-01	BLV	ETF	77.69	77.89	76.91	77.36	30100.0
2009-09-01	BMVP	ETF	11.6667	11.7953	11.5333	11.5533	24164.0
2009-09-01	BND	ETF	78.66	78.86	78.53	78.8	653800.0
2009-09-01	BNE	ETF	6.95	7.0	6.5	6.67	523554.0
2009-09-01	BOSS	ETF	19.18	19.18	18.96	19.18	200.0
2009-09-01	BRF	ETF	35.8	36.332	34.6	34.775	288905.0
2009-09-01	BSV	ETF	79.81	79.94	79.66	79.73	424800.0
2009-09-01	BTF	ETF	56.65	57.85	56.349999999999994	56.349999999999994	6540.400000000001
2009-09-01	BWX	ETF	28.435	28.435	28.045	28.145	412962.0
2009-09-01	BWZ	ETF	36.14	36.14	35.913	36.1	38207.0
2009-09-01	BZQ	ETF	7409.6	7692.8	7409.6	7657.6	102.0
2009-09-01	CEF	ETF	12.17	12.28	12.05	12.23	680500.0
2009-09-01	CEW	ETF	21.13	21.25	21.02	21.07	11244.0
2009-09-01	CGO	ETF	13.07	13.16	13.01	13.03	30505.0
2009-09-01	CGW	ETF	16.8	17.05	16.5601	16.62	87397.0
2009-09-01	CHB	ETF	0.6094	0.63	0.54	0.54	2566641.0
2009-09-01	CHI	ETF	10.91	11.08	10.91	11.0	127939.0
2009-09-01	CHIC	ETF	17.38	17.41	17.37	17.38	1583196.0
2009-09-01	CHW	ETF	7.27	7.35	7.1	7.1	209074.0

> showing 50 of 669 rows — these rows as CSV

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