PREVIEW / etf_daily / 2009-04-24

all etf daily files

  file:    by_date/etf_daily/2009/2009-04-24.parquet
  size:    28 KB
  rows:    648

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-04-24	SPY	ETF	86.03	87.31	85.69	86.66	287703000.0
2009-04-24	QQQ	ETF	33.35	33.93	33.07	33.69	141169941.0
2009-04-24	IWM	ETF	47.12	48.28	46.67	47.62	60773000.0
2009-04-24	DIA	ETF	80.1	81.27	79.93	80.73	17662200.0
2009-04-24	GLD	ETF	89.1	89.84	88.83	89.72	11425800.0
2009-04-24	TLT	ETF	100.79	100.98	100.1	100.57	2830000.0
2009-04-24	AAXJ	ETF	37.64	37.85	37.25	37.61	310500.0
2009-04-24	ACWI	ETF	31.41	31.72	31.26	31.62	346200.0
2009-04-24	ACWX	ETF	29.68	29.95	29.55	29.73	62578.0
2009-04-24	ADRE	ETF	30.07	30.59	30.07	30.44	289970.0
2009-04-24	AFK	ETF	20.8	21.79	20.8	21.79	2605.0
2009-04-24	AGG	ETF	101.37	101.44	101.0	101.44	533400.0
2009-04-24	AGQ	ETF	76.12	76.82	74.72	76.08	90450.0
2009-04-24	AGZ	ETF	107.96	107.99	107.702	107.92	5309.0
2009-04-24	AIA	ETF	28.25	28.67	28.23	28.63	7980.0
2009-04-24	AIQ	ETF	39.55	40.35	39.05	40.0	31206.0
2009-04-24	AIS	ETF	0.41	0.43	0.41	0.41	8000.0
2009-04-24	AIVI	ETF	31.76	31.96	31.53	31.63	8800.0
2009-04-24	AMJ	ETF	20.399	20.65	20.399	20.58	19685.0
2009-04-24	AOA	ETF	23.49	23.8	23.49	23.63	4200.0
2009-04-24	AOK	ETF	25.84	25.84	25.2	25.38	2850.0
2009-04-24	AOM	ETF	24.85	24.97	24.8	24.97	6178.0
2009-04-24	AOR	ETF	24.2499	24.42	24.2461	24.34	1498.0
2009-04-24	ARB	ETF	20.02	21.31	19.99	21.03	469164.0
2009-04-24	BAL	ETF	29.48	29.61	29.48	29.52	835.0
2009-04-24	BBH	ETF	28.8333	29.5767	28.8333	29.44	471000.0
2009-04-24	BIL	ETF	91.74	91.78	91.72	91.78	98800.0
2009-04-24	BITS	ETF	17.24	17.76	17.24	17.76	6069.0
2009-04-24	BIV	ETF	76.48	76.67	76.24	76.54	72900.0
2009-04-24	BJK	ETF	19.2	20.09	19.08	19.16	4800.0
2009-04-24	BKF	ETF	28.71	30.15	28.71	29.36	101850.0
2009-04-24	BLV	ETF	72.85	73.13	72.71	73.03	9200.0
2009-04-24	BMVP	ETF	10.37	10.52	10.36	10.43	37171.0
2009-04-24	BND	ETF	77.13	77.27	76.99	77.23	273100.0
2009-04-24	BNE	ETF	5.14	5.26	4.67	4.99	265410.0
2009-04-24	BOSS	ETF	14.7	15.0	14.7	15.0	1400.0
2009-04-24	BSV	ETF	78.84	79.1	78.65	78.81	171100.0
2009-04-24	BTF	ETF	45.0	45.75	45.0	45.75	11284.0
2009-04-24	BWX	ETF	25.895	25.945	25.79	25.945	246430.0
2009-04-24	BWZ	ETF	33.12	33.35	33.12	33.3	1611.0
2009-04-24	CBON	ETF	2.3	2.37	2.23	2.23	2617.0
2009-04-24	CEF	ETF	11.46	11.57	11.39	11.44	1401500.0
2009-04-24	CGO	ETF	9.72	9.78	9.6	9.68	41922.0
2009-04-24	CGW	ETF	13.35	13.64	13.33	13.42	44913.0
2009-04-24	CHB	ETF	0.51	0.68	0.5	0.62	1569962.0
2009-04-24	CHI	ETF	9.23	9.39	9.19	9.3	209529.0
2009-04-24	CHIC	ETF	11.96	12.68	11.8523	12.46	489595.0
2009-04-24	CHW	ETF	6.39	6.39	6.22	6.3	158975.0
2009-04-24	CHY	ETF	9.13	9.15	8.9372	9.02	287981.0
2009-04-24	CMF	ETF	52.54	52.795	52.53	52.53	9788.0

> showing 50 of 648 rows — these rows as CSV

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