PREVIEW / etf_daily / 2009-09-08

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-08.parquet
  size:    29 KB
  rows:    668

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-08	SPY	ETF	103.0	103.05	102.39	102.94	132909100.0
2009-09-08	QQQ	ETF	40.65	40.78	40.46	40.74	71024341.0
2009-09-08	IWM	ETF	57.66	57.72	57.0	57.68	41062500.0
2009-09-08	DIA	ETF	95.2	95.22	94.62	95.06	10862500.0
2009-09-08	GLD	ETF	98.57	98.64	97.39	97.43	22938800.0
2009-09-08	TLT	ETF	94.48	95.37	94.36	94.54	2468900.0
2009-09-08	AAXJ	ETF	51.41	53.02	50.69	51.25	125800.0
2009-09-08	ACWI	ETF	39.77	39.83	39.44	39.54	696800.0
2009-09-08	ACWX	ETF	38.9	38.9	38.61	38.784	39215.0
2009-09-08	ADRE	ETF	39.67	39.68	39.406	39.5801	108318.0
2009-09-08	AFK	ETF	28.5	28.5315	27.71	28.434	9555.0
2009-09-08	AGG	ETF	103.55	103.79	103.52	103.52	473500.0
2009-09-08	AGQ	ETF	117.42	118.02	112.38	113.16	439000.0
2009-09-08	AGZ	ETF	107.695	108.29	107.695	108.05	11408.0
2009-09-08	AIA	ETF	37.5	37.5	37.16	37.41	42551.0
2009-09-08	AIQ	ETF	26.5	26.7	25.8	25.95	44214.0
2009-09-08	AIS	ETF	1.14	1.15	1.08	1.13	2746118.0
2009-09-08	AIVI	ETF	42.57	42.57	41.39	41.62	18600.0
2009-09-08	AMJ	ETF	23.83	24.07	23.8299	24.04	195020.0
2009-09-08	AOA	ETF	28.44	28.44	28.1	28.17	6000.0
2009-09-08	AOK	ETF	26.91	26.91	26.7161	26.74	2812.0
2009-09-08	AOM	ETF	27.3394	27.5	27.33	27.34	14887.0
2009-09-08	AOR	ETF	28.05	28.05	27.73	27.79	5324.0
2009-09-08	ARB	ETF	17.64	17.69	17.16	17.68	149019.0
2009-09-08	BAL	ETF	31.35	31.7099	31.35	31.4514	4935.0
2009-09-08	BBH	ETF	33.59	34.1267	33.5333	33.7167	262800.0
2009-09-08	BIL	ETF	91.72	91.76	91.72	91.76	159000.0
2009-09-08	BITS	ETF	21.68	21.68	20.8	21.2	866.0
2009-09-08	BIV	ETF	79.29	79.6	79.21	79.24	73200.0
2009-09-08	BJK	ETF	24.81	24.91	24.7	24.9	9100.0
2009-09-08	BKF	ETF	39.49	39.91	39.38	39.7	210299.0
2009-09-08	BLV	ETF	77.2	77.62	77.0	77.2	41900.0
2009-09-08	BMVP	ETF	11.71	11.71	11.63	11.65	10912.0
2009-09-08	BND	ETF	78.79	78.84	78.64	78.71	494800.0
2009-09-08	BNE	ETF	6.81	6.94	6.61	6.84	212850.0
2009-09-08	BOSS	ETF	19.98	20.21	19.73	19.98	1100.0
2009-09-08	BRF	ETF	37.64	37.9	37.335	37.89	454797.0
2009-09-08	BSV	ETF	79.89	79.89	79.55	79.55	457200.0
2009-09-08	BTF	ETF	57.8	57.9	57.05	57.35	2836.0
2009-09-08	BWX	ETF	28.715	28.795	28.605	28.77	199218.0
2009-09-08	BWZ	ETF	36.6	36.7	36.5378	36.7	22824.0
2009-09-08	BZQ	ETF	6539.2	6606.4	6491.2	6504.0	66.0
2009-09-08	CEF	ETF	13.23	13.24	13.0	13.07	1227000.0
2009-09-08	CEW	ETF	21.48	21.571	21.48	21.5	24257.0
2009-09-08	CGO	ETF	13.35	13.45	13.25	13.318	22243.0
2009-09-08	CGW	ETF	17.09	17.28	17.09	17.22	138279.0
2009-09-08	CHB	ETF	0.54	0.55	0.47	0.48	1970651.0
2009-09-08	CHI	ETF	11.33	11.5	11.32	11.39	195194.0
2009-09-08	CHIC	ETF	17.45	17.45	17.42	17.44	385788.0
2009-09-08	CHW	ETF	7.5	7.54	7.36	7.54	130667.0

> showing 50 of 668 rows — these rows as CSV

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