PREVIEW / etf_daily / 2009-09-29

all etf daily files

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

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-29	SPY	ETF	106.51	107.02	105.78	106.0	133733900.0
2009-09-29	QQQ	ETF	42.41	42.6201	42.03	42.22	106686401.0
2009-09-29	IWM	ETF	61.3	61.78	60.92	60.99	37453200.0
2009-09-29	DIA	ETF	97.95	98.36	97.39	97.44	8171200.0
2009-09-29	GLD	ETF	97.19	97.73	96.95	97.43	9262100.0
2009-09-29	TLT	ETF	98.32	99.17	98.15	98.75	3123200.0
2009-09-29	AAXJ	ETF	52.33	52.47	51.92	52.28	82600.0
2009-09-29	ACWI	ETF	40.72	40.95	40.55	40.8	134600.0
2009-09-29	ACWX	ETF	39.84	39.84	39.42	39.68	13883.0
2009-09-29	ADRE	ETF	41.0	41.0	40.4	40.74	426115.0
2009-09-29	AFK	ETF	28.77	29.0	28.65	28.7701	10725.0
2009-09-29	AGG	ETF	104.67	104.85	104.53	104.73	937700.0
2009-09-29	AGQ	ETF	108.08	108.98	106.94	108.0	104700.0
2009-09-29	AGZ	ETF	108.6	108.63	108.35	108.59	9960.0
2009-09-29	AIA	ETF	38.25	38.44	38.09	38.3	28018.0
2009-09-29	AIQ	ETF	27.85	27.95	27.45	27.65	24357.0
2009-09-29	AIS	ETF	1.13	1.14	1.08	1.11	222715.0
2009-09-29	AIVI	ETF	42.47	42.47	41.95	42.25	17400.0
2009-09-29	AMJ	ETF	24.95	25.05	24.83	24.994	268112.0
2009-09-29	AOA	ETF	28.97	29.1	28.88	29.03	60400.0
2009-09-29	AOK	ETF	27.22	27.22	27.022	27.17	3792.0
2009-09-29	AOM	ETF	27.7701	27.792	27.66	27.76	6417.0
2009-09-29	AOR	ETF	28.54	28.54	28.33	28.36	5335.0
2009-09-29	ARB	ETF	20.8	21.07	20.49	20.69	341332.0
2009-09-29	BAL	ETF	32.42	32.8	31.85	31.93	8965.0
2009-09-29	BBH	ETF	33.9533	34.3333	33.9533	34.0533	125100.0
2009-09-29	BIL	ETF	91.72	91.76	91.72	91.76	95550.0
2009-09-29	BITS	ETF	21.72	21.72	21.6	21.6	275.0
2009-09-29	BIV	ETF	80.3	80.51	80.23	80.48	188100.0
2009-09-29	BJK	ETF	25.88	26.04	25.75	25.75	10600.0
2009-09-29	BKF	ETF	41.75	41.88	41.4	41.65	143644.0
2009-09-29	BLV	ETF	79.91	80.2	79.81	80.18	94200.0
2009-09-29	BMVP	ETF	12.08	12.09	12.0067	12.0671	20043.0
2009-09-29	BND	ETF	79.36	79.52	79.31	79.5	752400.0
2009-09-29	BNE	ETF	7.59	7.73	7.41	7.62	136628.0
2009-09-29	BOSS	ETF	21.48	21.76	20.51	21.48	800.0
2009-09-29	BRF	ETF	39.85	39.9499	39.34	39.64	175285.0
2009-09-29	BSV	ETF	79.98	80.02	79.88	80.0	390300.0
2009-09-29	BTF	ETF	60.49999999999999	60.7275	60.25	60.3	10313.0
2009-09-29	BWX	ETF	29.04	29.125	28.925	29.125	281188.0
2009-09-29	BWZ	ETF	37.15	37.15	37.13	37.15	16836.0
2009-09-29	BZQ	ETF	5440.0	5440.0	5440.0	5440.0	2.0
2009-09-29	CEF	ETF	13.0	13.06	12.91	12.96	589800.0
2009-09-29	CEW	ETF	21.73	21.8	21.65	21.7	23420.0
2009-09-29	CGO	ETF	14.0	14.053	13.78	13.9045	17175.0
2009-09-29	CGW	ETF	17.87	17.98	17.75	17.91	62449.0
2009-09-29	CHB	ETF	0.501	0.51	0.48	0.48	2202792.0
2009-09-29	CHI	ETF	11.85	11.94	11.79	11.86	207403.0
2009-09-29	CHIC	ETF	17.48	17.5	17.47	17.47	696073.0
2009-09-29	CHW	ETF	7.69	7.78	7.64	7.76	145611.0

> showing 50 of 675 rows — these rows as CSV

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