PREVIEW / etf_daily / 2009-09-09

all etf daily files

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

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-09	SPY	ETF	103.12	104.08	102.8	103.73	154612500.0
2009-09-09	QQQ	ETF	40.76	41.29	40.59	41.09	99290029.0
2009-09-09	IWM	ETF	57.68	59.03	57.52	58.67	37219700.0
2009-09-09	DIA	ETF	95.09	95.91	94.87	95.53	13560500.0
2009-09-09	GLD	ETF	97.98	98.36	96.85	97.08	20439900.0
2009-09-09	TLT	ETF	93.89	94.43	93.52	94.43	3182400.0
2009-09-09	AAXJ	ETF	51.45	51.58	50.96	51.47	124100.0
2009-09-09	ACWI	ETF	39.81	40.09	39.67	39.93	94400.0
2009-09-09	ACWX	ETF	39.04	39.35	38.88	39.11	48884.0
2009-09-09	ADRE	ETF	39.8	39.9	39.425	39.66	104160.0
2009-09-09	AFK	ETF	28.2101	28.55	28.0801	28.12	11866.0
2009-09-09	AGG	ETF	103.48	103.79	103.41	103.72	605800.0
2009-09-09	AGQ	ETF	114.64	116.92	110.74	111.64	368400.0
2009-09-09	AGZ	ETF	107.96	108.17	107.643	107.729	8383.0
2009-09-09	AIA	ETF	37.36	37.63	37.26	37.48	89707.0
2009-09-09	AIQ	ETF	25.95	27.05	25.95	26.75	45596.0
2009-09-09	AIS	ETF	1.13	1.25	1.13	1.21	2257400.0
2009-09-09	AIVI	ETF	41.93	42.36	41.71	42.13	23000.0
2009-09-09	AMJ	ETF	24.1	24.27	23.87	23.99	255679.0
2009-09-09	AOA	ETF	28.37	28.49	28.34	28.44	7100.0
2009-09-09	AOK	ETF	27.3	27.3	26.78	26.82	1811.0
2009-09-09	AOM	ETF	27.4099	27.4494	27.38	27.4364	700.0
2009-09-09	AOR	ETF	27.53	28.05	27.53	27.99	5323.0
2009-09-09	ARB	ETF	17.74	17.87	17.46	17.64	286712.0
2009-09-09	BAL	ETF	31.6101	31.7064	31.41	31.46	4484.0
2009-09-09	BBH	ETF	33.6333	33.94	33.6333	33.8367	93600.0
2009-09-09	BIL	ETF	91.74	91.76	91.7	91.7	119100.0
2009-09-09	BITS	ETF	20.96	21.32	20.96	21.28	386.0
2009-09-09	BIV	ETF	78.88	79.28	78.73	79.09	482500.0
2009-09-09	BJK	ETF	24.88	25.62	24.83	25.18	24200.0
2009-09-09	BKF	ETF	39.91	40.19	39.67	40.01	193003.0
2009-09-09	BLV	ETF	76.94	77.31	76.66	77.3	28200.0
2009-09-09	BMVP	ETF	11.66	11.8271	11.66	11.7967	14378.0
2009-09-09	BND	ETF	78.72	78.84	78.51	78.84	523900.0
2009-09-09	BNE	ETF	6.81	7.03	6.74	6.92	225844.0
2009-09-09	BOSS	ETF	19.91	20.0	19.91	20.0	100.0
2009-09-09	BRF	ETF	38.34	38.43	37.77	38.02	625994.0
2009-09-09	BSV	ETF	79.68	79.86	79.61	79.75	740100.0
2009-09-09	BTF	ETF	57.24999999999999	57.8	56.95	57.699999999999996	1994.0
2009-09-09	BWX	ETF	28.805	28.875	28.685	28.77	203020.0
2009-09-09	BWZ	ETF	36.7525	36.91	36.7525	36.8211	35840.0
2009-09-09	BZQ	ETF	6419.2	6510.4	6395.2	6489.6	23.25
2009-09-09	CEF	ETF	13.06	13.15	12.85	13.04	1017400.0
2009-09-09	CEW	ETF	21.57	21.57	21.34	21.47	25629.0
2009-09-09	CGO	ETF	13.45	13.56	13.255	13.56	19281.0
2009-09-09	CGW	ETF	17.33	17.59	17.3	17.5	70260.0
2009-09-09	CHB	ETF	0.49	0.51	0.44	0.47	3429607.0
2009-09-09	CHI	ETF	11.41	11.45	11.31	11.41	150889.0
2009-09-09	CHIC	ETF	17.43	17.45	17.42	17.43	715281.0
2009-09-09	CHW	ETF	7.52	7.52	7.41	7.49	136504.0

> showing 50 of 673 rows — these rows as CSV

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