PREVIEW / etf_daily / 2009-06-12

all etf daily files

  file:    by_date/etf_daily/2009/2009-06-12.parquet
  size:    29 KB
  rows:    656

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-06-12	SPY	ETF	94.4	95.14	94.0	95.08	184361800.0
2009-06-12	QQQ	ETF	36.67	36.719	36.2	36.65	109452462.0
2009-06-12	IWM	ETF	52.28	52.82	51.89	52.78	44094300.0
2009-06-12	DIA	ETF	87.6	88.33	87.37	88.31	12743500.0
2009-06-12	GLD	ETF	92.41	92.76	92.0	92.17	13809400.0
2009-06-12	TLT	ETF	89.42	90.65	89.42	89.97	6606800.0
2009-06-12	AAXJ	ETF	45.77	45.89	45.44	45.89	261500.0
2009-06-12	ACWI	ETF	36.04	36.22	35.8	36.22	146400.0
2009-06-12	ACWX	ETF	35.12	35.25	34.94	35.2	68183.0
2009-06-12	ADRE	ETF	36.65	36.77	36.4777	36.69	114167.0
2009-06-12	AFK	ETF	28.15	28.37	27.75	27.85	18407.0
2009-06-12	AGG	ETF	100.33	100.91	100.33	100.81	358000.0
2009-06-12	AGQ	ETF	98.36	100.6	96.9	97.66	146950.0
2009-06-12	AGZ	ETF	106.45	106.68	106.09	106.61	38220.0
2009-06-12	AIA	ETF	33.02	33.36	32.89	33.17	35401.0
2009-06-12	AIQ	ETF	36.15	36.8	35.15	36.4	63349.0
2009-06-12	AIS	ETF	0.76	0.79	0.73	0.74	58965.0
2009-06-12	AIVI	ETF	36.67	36.67	36.38	36.64	14700.0
2009-06-12	AMJ	ETF	22.91	22.99	22.74	22.96	72689.0
2009-06-12	AOA	ETF	25.78	25.97	25.71	25.97	7300.0
2009-06-12	AOK	ETF	25.85	27.06	25.85	26.5	7700.0
2009-06-12	AOM	ETF	25.94	25.9861	25.94	25.9746	791.0
2009-06-12	AOR	ETF	25.91	26.06	25.91	26.06	12503.0
2009-06-12	ARB	ETF	18.75	19.46	18.75	19.36	261536.0
2009-06-12	BAL	ETF	31.59	31.99	31.59	31.9799	6841.0
2009-06-12	BBH	ETF	30.3033	30.7567	30.23	30.56	163200.0
2009-06-12	BIL	ETF	91.7	91.74	91.68	91.74	216350.0
2009-06-12	BITS	ETF	20.04	20.04	18.84	19.68	2025.0
2009-06-12	BIV	ETF	75.52	76.1	75.52	75.8	85100.0
2009-06-12	BJK	ETF	21.45	22.41	21.38	21.79	8700.0
2009-06-12	BKF	ETF	37.64	38.03	37.3765	37.71	167953.0
2009-06-12	BLV	ETF	71.73	72.67	71.73	72.0	22000.0
2009-06-12	BMVP	ETF	11.1	11.15	11.04	11.14	20264.0
2009-06-12	BND	ETF	76.6	76.76	76.35	76.67	289200.0
2009-06-12	BNE	ETF	6.71	6.98	6.56	6.91	87570.0
2009-06-12	BOSS	ETF	16.15	16.15	16.14	16.14	100.0
2009-06-12	BRF	ETF	28.45	28.8548	28.08	28.8378	196341.0
2009-06-12	BSV	ETF	78.25	78.68	78.25	78.66	154000.0
2009-06-12	BTF	ETF	47.64999999999999	49.1	47.64999999999999	49.05	6084.0
2009-06-12	BWX	ETF	26.785	26.925	26.7	26.91	247110.0
2009-06-12	BWZ	ETF	34.88	34.935	34.88	34.92	1058.0
2009-06-12	CBON	ETF	1.5	1.5	1.31	1.5	36501.0
2009-06-12	CEF	ETF	12.13	12.48	12.1	12.11	971900.0
2009-06-12	CEW	ETF	20.78	20.8	20.72	20.8	46258.0
2009-06-12	CGO	ETF	11.96	11.96	11.83	11.84	16655.0
2009-06-12	CGW	ETF	16.15	16.15	15.63	15.85	76812.0
2009-06-12	CHB	ETF	0.47	0.49	0.44	0.47	331399.0
2009-06-12	CHI	ETF	10.73	10.8	10.63	10.765	141868.0
2009-06-12	CHIC	ETF	11.8	12.1	11.6125	12.07	193317.0
2009-06-12	CHW	ETF	6.98	7.27	6.98	7.1272	180808.0

> showing 50 of 656 rows — these rows as CSV

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