PREVIEW / etf_daily / 2009-09-17

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-17.parquet
  size:    30 KB
  rows:    675

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-17	SPY	ETF	107.17	108.06	106.57	107.16	229170900.0
2009-09-17	QQQ	ETF	42.32	42.66	42.21	42.41	102169545.0
2009-09-17	IWM	ETF	61.74	62.34	61.35	61.66	50596200.0
2009-09-17	DIA	ETF	97.97	98.72	97.64	98.06	15803800.0
2009-09-17	GLD	ETF	99.66	100.08	99.04	99.34	12493600.0
2009-09-17	TLT	ETF	95.69	96.73	95.17	96.62	2832000.0
2009-09-17	AAXJ	ETF	53.12	53.36	52.63	53.0	299700.0
2009-09-17	ACWI	ETF	41.33	42.15	41.0	41.2	55200.0
2009-09-17	ACWX	ETF	40.26	40.56	40.01	40.16	120075.0
2009-09-17	ADRE	ETF	41.55	41.77	41.051	41.32	91819.0
2009-09-17	AFK	ETF	28.6	28.93	28.4801	28.84	13164.0
2009-09-17	AGG	ETF	104.07	104.5	103.99	104.5	468400.0
2009-09-17	AGQ	ETF	126.16	128.2	122.94	123.68	298400.0
2009-09-17	AGZ	ETF	108.1	108.51	107.9042	108.5	8252.0
2009-09-17	AIA	ETF	38.82	39.03	38.66	38.75	49606.0
2009-09-17	AIQ	ETF	29.0	29.25	28.15	28.85	30432.0
2009-09-17	AIS	ETF	1.11	1.11	1.0701	1.09	451068.0
2009-09-17	AIVI	ETF	43.39	43.82	43.3	43.59	20100.0
2009-09-17	AMJ	ETF	25.19	25.91	24.98	25.0	228188.0
2009-09-17	AOA	ETF	29.5	29.51	29.35	29.36	8600.0
2009-09-17	AOK	ETF	27.2	27.23	27.04	27.1961	27131.0
2009-09-17	AOM	ETF	28.03	28.07	27.918	28.01	6398.0
2009-09-17	AOR	ETF	28.76	28.76	28.5639	28.65	5068.0
2009-09-17	ARB	ETF	19.33	19.44	18.96	19.07	216854.0
2009-09-17	BAL	ETF	33.39	33.39	33.2251	33.3699	1931.0
2009-09-17	BBH	ETF	33.67	34.02	33.6667	33.99	221700.0
2009-09-17	BIL	ETF	91.72	91.74	91.7	91.72	196700.0
2009-09-17	BITS	ETF	22.0	22.08	21.8	21.84	327.0
2009-09-17	BIV	ETF	79.67	79.98	79.39	79.93	160100.0
2009-09-17	BJK	ETF	26.42	26.69	26.0	26.25	19700.0
2009-09-17	BKF	ETF	41.85	42.22	41.5	41.5	403560.0
2009-09-17	BLV	ETF	78.5	79.12	78.2	79.12	23400.0
2009-09-17	BMVP	ETF	12.153	12.212	12.103	12.143	14041.0
2009-09-17	BND	ETF	78.99	79.19	78.87	79.19	879600.0
2009-09-17	BNE	ETF	7.4	7.4	7.02	7.03	107797.0
2009-09-17	BRF	ETF	39.9	40.1	39.1601	39.25	310342.0
2009-09-17	BSV	ETF	79.85	79.86	79.68	79.84	379800.0
2009-09-17	BTF	ETF	59.4	60.25	59.4	59.85	9634.2
2009-09-17	BWX	ETF	29.15	29.245	29.1	29.205	586564.0
2009-09-17	BWZ	ETF	37.19	37.27	36.88	37.23	143461.0
2009-09-17	BZQ	ETF	5766.4	5766.4	5622.4	5760.0	11.25
2009-09-17	CEF	ETF	13.48	13.56	13.18	13.29	912400.0
2009-09-17	CEW	ETF	21.72	21.78	21.65	21.73	12436.0
2009-09-17	CGO	ETF	14.29	14.5152	14.25	14.25	27446.0
2009-09-17	CGW	ETF	18.14	18.22	18.0	18.11	372750.0
2009-09-17	CHB	ETF	0.62	0.64	0.58	0.59	2318970.0
2009-09-17	CHI	ETF	11.81	11.89	11.7	11.75	139274.0
2009-09-17	CHIC	ETF	17.47	17.47	17.46	17.46	258256.0
2009-09-17	CHW	ETF	7.88	8.03	7.64	7.88	353191.0
2009-09-17	CHY	ETF	11.53	11.77	11.5	11.55	257365.0

> showing 50 of 675 rows — these rows as CSV

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