PREVIEW / etf_daily / 2010-11-30

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-30.parquet
  size:    34 KB
  rows:    807

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
2010-11-30	SPY	ETF	117.98	119.17	117.81	118.49	233930700.0
2010-11-30	QQQ	ETF	52.18	52.7355	51.88	52.085	118861507.0
2010-11-30	IWM	ETF	72.48	73.25	72.18	72.75	68631800.0
2010-11-30	DIA	ETF	109.67	110.76	109.56	110.17	8055600.0
2010-11-30	GLD	ETF	135.21	135.75	134.78	135.42	17473100.0
2010-11-30	TLT	ETF	99.21	99.27	98.11	98.41	11947600.0
2010-11-30	AADR	ETF	28.38	28.38	28.3	28.3	1800.0
2010-11-30	AAXJ	ETF	60.52	61.16	60.52	60.88	243800.0
2010-11-30	ACWI	ETF	43.72	44.51	43.52	43.85	459100.0
2010-11-30	ACWX	ETF	41.02	41.4899	40.91	41.28	54957.0
2010-11-30	ADRE	ETF	44.84	45.4	44.79	45.01	49573.0
2010-11-30	AFK	ETF	32.55	32.6199	32.39	32.46	10585.0
2010-11-30	AGG	ETF	107.74	107.74	107.33	107.37	767900.0
2010-11-30	AGQ	ETF	257.28	271.54	255.34	266.62	729150.0
2010-11-30	AGZ	ETF	111.03	111.03	110.86	110.98	11466.0
2010-11-30	AIA	ETF	43.83	44.15	43.7105	44.0	29994.0
2010-11-30	AIQ	ETF	18.9	18.9	18.6	18.75	30553.0
2010-11-30	AIS	ETF	1.4	1.44	1.39	1.43	219313.0
2010-11-30	AIVI	ETF	41.11	41.61	41.03	41.44	36300.0
2010-11-30	AMJ	ETF	35.64	35.75	35.5	35.75	456768.0
2010-11-30	AMLP	ETF	79.0	79.35	78.95	79.3	182800.0
2010-11-30	AOA	ETF	32.29	32.6	32.26	32.49	7800.0
2010-11-30	AOK	ETF	28.55	28.56	28.51	28.51	3493.0
2010-11-30	AOM	ETF	29.32	29.3764	29.29	29.317	9775.0
2010-11-30	AOR	ETF	30.36	30.54	30.36	30.46	14962.0
2010-11-30	ARB	ETF	29.02	29.65	28.84	29.22	271998.0
2010-11-30	BAB	ETF	25.54	25.57	25.452	25.4736	146086.0
2010-11-30	BAL	ETF	59.02	59.83	58.71	59.36	54507.0
2010-11-30	BALT	ETF	12.08	12.19	11.695	11.73	627577.0
2010-11-30	BBH	ETF	32.3367	32.41	32.1733	32.2967	64200.0
2010-11-30	BIB	ETF	6.5775	6.5775	6.5775	6.5775	800.0
2010-11-30	BICK	ETF	31.5	31.72	31.339	31.525	15813.0
2010-11-30	BIL	ETF	91.7	91.72	91.7	91.72	81300.0
2010-11-30	BITS	ETF	28.4	28.4	28.4	28.4	200.0
2010-11-30	BIV	ETF	85.87	85.89	85.56	85.62	177000.0
2010-11-30	BJK	ETF	30.67	30.92	30.62	30.67	9000.0
2010-11-30	BKF	ETF	47.25	47.9	47.11	47.49	108734.0
2010-11-30	BLV	ETF	82.38	82.47	81.82	81.82	88600.0
2010-11-30	BMVP	ETF	14.02	14.15	14.0	14.1	12809.0
2010-11-30	BND	ETF	82.12	82.14	81.87	81.91	517500.0
2010-11-30	BRF	ETF	57.89	58.99	57.89	58.44	468181.0
2010-11-30	BSCE	ETF	20.88	20.9	20.869	20.88	71709.0
2010-11-30	BSV	ETF	81.44	81.54	81.44	81.51	261400.0
2010-11-30	BTF	ETF	77.64999999999999	77.64999999999999	76.8	77.5865	6331.0
2010-11-30	BWX	ETF	28.365	28.5545	28.29	28.525	343804.0
2010-11-30	BWZ	ETF	35.85	37.2	35.85	37.2	70004.0
2010-11-30	BZQ	ETF	2835.2	2846.4	2740.8	2792.0	261.0
2010-11-30	CEF	ETF	19.13	19.4	19.11	19.26	987500.0
2010-11-30	CEW	ETF	22.55	22.69	22.55	22.61	200704.0
2010-11-30	CGO	ETF	14.66	14.73	14.53	14.59	47239.0

> showing 50 of 807 rows — these rows as CSV

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