PREVIEW / etf_daily / 2009-10-13

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-13.parquet
  size:    29 KB
  rows:    672

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-10-13	SPY	ETF	107.39	107.71	106.76	107.46	157692700.0
2009-10-13	QQQ	ETF	42.54	42.75	42.37	42.58	70939211.0
2009-10-13	IWM	ETF	61.32	61.49	60.6	61.17	35459500.0
2009-10-13	DIA	ETF	98.64	99.02	98.22	98.83	6026200.0
2009-10-13	GLD	ETF	103.7	104.5	103.46	104.26	17358800.0
2009-10-13	TLT	ETF	96.62	96.85	96.26	96.55	2886500.0
2009-10-13	AAXJ	ETF	53.27	53.53	52.98	53.53	360900.0
2009-10-13	ACWI	ETF	41.58	41.58	41.16	41.41	214900.0
2009-10-13	ACWX	ETF	40.72	40.72	40.322	40.63	59885.0
2009-10-13	ADRE	ETF	42.75	42.85	42.2	42.8099	85838.0
2009-10-13	AFK	ETF	29.69	30.39	29.69	30.3099	21445.0
2009-10-13	AGG	ETF	104.56	104.68	104.46	104.66	380200.0
2009-10-13	AGQ	ETF	129.02	131.46	126.72	129.72	262550.0
2009-10-13	AGZ	ETF	108.3932	108.53	108.33	108.49	3516.0
2009-10-13	AIA	ETF	38.49	38.58	38.23	38.512	25815.0
2009-10-13	AIQ	ETF	31.1	31.5	31.0	31.4	126352.0
2009-10-13	AIS	ETF	1.14	1.14	1.09	1.12	466182.0
2009-10-13	AIVI	ETF	42.99	43.09	42.6	42.9	8500.0
2009-10-13	AMJ	ETF	25.84	26.0	25.7201	25.95	147867.0
2009-10-13	AOA	ETF	29.4	29.4	29.22	29.35	5800.0
2009-10-13	AOK	ETF	27.25	27.25	27.1601	27.215	5288.0
2009-10-13	AOM	ETF	27.96	27.96	27.86	27.93	36541.0
2009-10-13	AOR	ETF	28.63	28.63	28.47	28.6	7309.0
2009-10-13	ARB	ETF	22.35	22.69	21.91	22.31	143671.0
2009-10-13	BAL	ETF	33.25	34.43	33.25	34.4299	15993.0
2009-10-13	BBH	ETF	33.25	33.4067	33.13	33.34	57000.0
2009-10-13	BIL	ETF	91.72	91.72	91.7	91.72	80250.0
2009-10-13	BITS	ETF	22.0	25.2	22.0	24.76	29665.0
2009-10-13	BIV	ETF	80.37	80.4	80.14	80.29	112700.0
2009-10-13	BJK	ETF	25.87	26.41	25.87	26.33	11200.0
2009-10-13	BKF	ETF	44.59	44.59	43.759	44.33	184168.0
2009-10-13	BLV	ETF	78.54	78.82	78.36	78.55	91400.0
2009-10-13	BMVP	ETF	12.22	12.24	12.1575	12.2	42702.0
2009-10-13	BND	ETF	79.43	79.43	79.14	79.34	745700.0
2009-10-13	BNE	ETF	7.84	7.84	7.52	7.81	76788.0
2009-10-13	BOSS	ETF	22.8	22.8	22.54	22.8	500.0
2009-10-13	BRF	ETF	44.02	44.57	43.734	44.53	435342.0
2009-10-13	BSV	ETF	80.03	80.03	79.85	79.92	324800.0
2009-10-13	BTF	ETF	60.3	60.99999999999999	60.0	60.65	2555.0
2009-10-13	BWX	ETF	29.58	29.58	29.39	29.51	289104.0
2009-10-13	BWZ	ETF	37.65	37.69	37.65	37.6799	56081.0
2009-10-13	BZQ	ETF	4625.6	4656.0	4539.2	4558.4	45.75
2009-10-13	CEF	ETF	13.85	14.01	13.76	13.91	1177800.0
2009-10-13	CEW	ETF	22.0	22.03	21.9307	22.01	81031.0
2009-10-13	CGO	ETF	14.2	14.24	14.13	14.19	6926.0
2009-10-13	CGW	ETF	17.84	17.93	17.692	17.83	43048.0
2009-10-13	CHB	ETF	0.44	0.45	0.3	0.32	5013042.0
2009-10-13	CHI	ETF	11.66	11.728	11.54	11.67	194044.0
2009-10-13	CHIC	ETF	17.48	17.51	17.48	17.51	190131.0
2009-10-13	CHW	ETF	7.74	7.86	7.74	7.81	180196.0

> showing 50 of 672 rows — these rows as CSV

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