PREVIEW / etf_daily / 2009-09-30

all etf daily files

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

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-30	SPY	ETF	106.36	106.46	104.62	105.59	254383000.0
2009-09-30	QQQ	ETF	42.39	42.6024	41.6	42.25	173102625.0
2009-09-30	IWM	ETF	61.12	61.24	59.56	60.24	79344900.0
2009-09-30	DIA	ETF	97.62	97.79	96.07	97.09	15351500.0
2009-09-30	GLD	ETF	98.31	99.06	97.56	98.85	18664200.0
2009-09-30	TLT	ETF	98.56	99.13	98.36	98.66	2744800.0
2009-09-30	AAXJ	ETF	52.25	53.21	51.89	53.02	420700.0
2009-09-30	ACWI	ETF	40.98	41.0	40.31	40.75	48200.0
2009-09-30	ACWX	ETF	40.04	40.04	39.37	39.87	46502.0
2009-09-30	ADRE	ETF	40.92	41.416	40.43	41.16	118215.0
2009-09-30	AFK	ETF	28.76	28.96	28.35	28.96	4762.0
2009-09-30	AGG	ETF	104.65	104.92	104.64	104.92	818800.0
2009-09-30	AGQ	ETF	111.44	115.12	108.96	114.5	299800.0
2009-09-30	AGZ	ETF	109.01	109.01	108.48	108.83	17111.0
2009-09-30	AIA	ETF	38.42	38.64	37.96	38.52	60712.0
2009-09-30	AIQ	ETF	27.75	28.6	26.85	28.3	71531.0
2009-09-30	AIS	ETF	1.12	1.1299	1.08	1.11	530852.0
2009-09-30	AIVI	ETF	42.54	42.55	41.67	42.1	28900.0
2009-09-30	AMJ	ETF	25.07	25.09	24.77	25.03	146568.0
2009-09-30	AOA	ETF	29.1	29.11	28.69	29.0	13100.0
2009-09-30	AOK	ETF	27.29	27.29	27.09	27.18	25162.0
2009-09-30	AOM	ETF	27.9	27.9	27.66	27.74	11035.0
2009-09-30	AOR	ETF	28.34	28.46	28.164	28.31	67387.0
2009-09-30	ARB	ETF	20.76	21.0	20.25	20.76	286412.0
2009-09-30	BAL	ETF	31.68	32.68	31.5	32.68	15754.0
2009-09-30	BBH	ETF	33.9933	34.0033	33.58	33.86	232500.0
2009-09-30	BIL	ETF	91.72	91.78	91.72	91.76	142500.0
2009-09-30	BITS	ETF	21.6	21.64	21.04	21.48	3860.0
2009-09-30	BIV	ETF	80.44	80.64	80.35	80.56	108100.0
2009-09-30	BJK	ETF	25.84	26.25	25.47	25.88	4200.0
2009-09-30	BKF	ETF	41.72	42.2	41.1	41.93	705442.0
2009-09-30	BLV	ETF	79.93	80.43	79.75	79.92	99700.0
2009-09-30	BMVP	ETF	12.06	12.06	11.87	11.98	19042.0
2009-09-30	BND	ETF	79.44	79.55	79.4	79.5	575600.0
2009-09-30	BNE	ETF	7.65	7.95	7.4	7.7	287444.0
2009-09-30	BOSS	ETF	21.4	22.94	21.4	22.94	100.0
2009-09-30	BRF	ETF	40.0	40.28	39.43	40.16	305826.0
2009-09-30	BSV	ETF	79.98	80.14	79.77	80.05	389300.0
2009-09-30	BTF	ETF	60.05	60.49999999999999	59.85	60.05	7002.400000000001
2009-09-30	BWX	ETF	29.23	29.26	29.08	29.215	536350.0
2009-09-30	BWZ	ETF	37.15	37.28	37.15	37.26	17153.0
2009-09-30	BZQ	ETF	5521.6	5521.6	5243.2	5300.8	20.0
2009-09-30	CEF	ETF	13.14	13.25	13.0	13.25	798500.0
2009-09-30	CEW	ETF	21.75	21.8	21.7	21.75	30357.0
2009-09-30	CGO	ETF	13.92	14.08	13.83	14.068	14677.0
2009-09-30	CGW	ETF	17.93	18.04	17.67	17.86	138775.0
2009-09-30	CHB	ETF	0.48	0.49	0.45	0.46	3816472.0
2009-09-30	CHI	ETF	11.85	11.98	11.85	11.89	107161.0
2009-09-30	CHIC	ETF	17.5	17.52	17.49	17.5	257258.0
2009-09-30	CHW	ETF	7.84	7.84	7.64	7.778	172121.0

> showing 50 of 677 rows — these rows as CSV

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