PREVIEW / etf_daily / 2009-08-13

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-13.parquet
  size:    29 KB
  rows:    665

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-13	SPY	ETF	101.26	101.61	100.26	101.57	176449500.0
2009-08-13	QQQ	ETF	40.1	40.16	39.64	40.09	110106995.0
2009-08-13	IWM	ETF	57.59	57.78	56.73	57.59	43539700.0
2009-08-13	DIA	ETF	94.14	94.26	93.17	94.19	10209100.0
2009-08-13	GLD	ETF	93.85	94.05	93.45	93.72	6756000.0
2009-08-13	TLT	ETF	91.8	93.15	91.5	92.99	3922300.0
2009-08-13	AAXJ	ETF	50.22	50.25	49.41	50.11	227100.0
2009-08-13	ACWI	ETF	38.67	38.77	38.28	38.72	215300.0
2009-08-13	ACWX	ETF	37.5	37.7	37.26	37.59	43534.0
2009-08-13	ADRE	ETF	38.81	39.0	38.43	39.0	90693.0
2009-08-13	AFK	ETF	27.59	28.25	27.5301	28.09	14715.0
2009-08-13	AGG	ETF	102.76	103.17	102.62	102.95	523700.0
2009-08-13	AGQ	ETF	94.58	96.94	93.48	96.54	111600.0
2009-08-13	AGZ	ETF	106.96	107.57	106.96	107.52	8465.0
2009-08-13	AIA	ETF	36.35	36.35	35.92	36.29	65147.0
2009-08-13	AIQ	ETF	26.0	26.6	25.65	26.4	138685.0
2009-08-13	AIS	ETF	0.98	1.01	0.93	0.93	293705.0
2009-08-13	AIVI	ETF	39.5	39.61	39.29	39.52	15000.0
2009-08-13	AMJ	ETF	24.62	24.73	24.3895	24.44	76250.0
2009-08-13	AOA	ETF	27.86	27.86	27.44	27.72	11700.0
2009-08-13	AOK	ETF	26.5	26.51	26.5	26.5028	4704.0
2009-08-13	AOM	ETF	27.28	27.49	26.9385	26.97	2802.0
2009-08-13	AOR	ETF	27.3346	27.35	27.2761	27.35	6423.0
2009-08-13	ARB	ETF	16.33	16.51	16.1	16.46	282561.0
2009-08-13	BAL	ETF	33.43	33.8148	33.43	33.47	3244.0
2009-08-13	BBH	ETF	33.49	33.7033	33.0933	33.1167	281100.0
2009-08-13	BIL	ETF	91.72	91.74	91.7	91.7	149000.0
2009-08-13	BITS	ETF	22.0	22.0	21.04	21.8	3117.0
2009-08-13	BIV	ETF	78.18	78.59	77.99	78.54	136700.0
2009-08-13	BJK	ETF	23.72	24.15	23.1	23.43	85500.0
2009-08-13	BKF	ETF	39.53	39.53	38.75	39.37	744990.0
2009-08-13	BLV	ETF	75.69	76.43	75.38	76.25	17600.0
2009-08-13	BMVP	ETF	11.69	11.69	11.6	11.68	27825.0
2009-08-13	BND	ETF	77.94	78.28	77.79	78.12	562200.0
2009-08-13	BNE	ETF	6.33	6.36	6.0	6.09	334397.0
2009-08-13	BOSS	ETF	19.7	20.28	19.7	20.28	100.0
2009-08-13	BRF	ETF	37.36	37.36	35.6	35.89	182699.0
2009-08-13	BSV	ETF	79.36	79.55	79.25	79.47	391600.0
2009-08-13	BTF	ETF	57.55	59.15	57.5	59.1	34546.0
2009-08-13	BWX	ETF	27.92	28.065	27.88	27.94	232706.0
2009-08-13	BWZ	ETF	35.84	35.97	35.7365	35.97	27489.0
2009-08-13	BZQ	ETF	6792.0	6792.0	6756.8	6756.8	2.0
2009-08-13	CBON	ETF	1.15	1.15	1.01	1.05	36997.0
2009-08-13	CEF	ETF	11.97	12.03	11.91	11.99	1359000.0
2009-08-13	CEW	ETF	21.26	21.4	21.2501	21.4	16836.0
2009-08-13	CGO	ETF	13.13	13.57	13.0	13.45	16458.0
2009-08-13	CGW	ETF	16.59	16.59	16.37	16.504	31848.0
2009-08-13	CHB	ETF	0.48	0.579	0.48	0.57	3714356.0
2009-08-13	CHI	ETF	11.47	11.48	11.32	11.33	159739.0
2009-08-13	CHIC	ETF	14.81	14.89	14.03	14.14	339511.0

> showing 50 of 665 rows — these rows as CSV

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