PREVIEW / etf_daily / 2011-09-07

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-07.parquet
  size:    36 KB
  rows:    867

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
2011-09-07	SPY	ETF	118.76	120.34	118.36	120.29	209803200.0
2011-09-07	QQQ	ETF	54.03	54.65	53.9	54.64	48952119.0
2011-09-07	IWM	ETF	69.4	70.95	69.07	70.85	68952400.0
2011-09-07	DIA	ETF	112.74	114.02	112.4	113.94	7271500.0
2011-09-07	GLD	ETF	176.19	178.09	174.45	177.08	30760000.0
2011-09-07	TLT	ETF	112.28	112.37	111.31	111.51	11524300.0
2011-09-07	AADR	ETF	28.67	29.11	28.67	29.07	1000.0
2011-09-07	AAXJ	ETF	55.69	56.18	55.39	56.14	300600.0
2011-09-07	ACTV	ETF	15.37	15.75	15.14	15.55	106865.0
2011-09-07	ACWI	ETF	42.09	42.79	42.03	42.79	561600.0
2011-09-07	ACWX	ETF	38.32	38.9	38.191	38.9	63581.0
2011-09-07	ADRE	ETF	41.37	41.83	41.22	41.83	76141.0
2011-09-07	AFK	ETF	29.21	29.64	29.09	29.64	24573.0
2011-09-07	AGEM	ETF	23.12	23.5	23.12	23.5	1327.0
2011-09-07	AGG	ETF	110.06	110.12	109.85	109.98	919500.0
2011-09-07	AGQ	ETF	430.0	455.22	423.96	450.78	572450.0
2011-09-07	AGZ	ETF	112.59	112.6	112.4	112.4	16357.0
2011-09-07	AIA	ETF	41.76	42.33	41.73	42.3	24637.0
2011-09-07	AIQ	ETF	6.6	7.15	6.6	6.75	102670.0
2011-09-07	AIS	ETF	2.34	2.36	2.31	2.34	811504.0
2011-09-07	AIVI	ETF	40.7	41.19	40.4	41.19	201200.0
2011-09-07	AMJ	ETF	34.97	35.19	34.81	35.16	766359.0
2011-09-07	AMLP	ETF	76.95	77.4	75.95	77.1	105340.0
2011-09-07	AOA	ETF	32.04	32.47	31.98	32.47	15400.0
2011-09-07	AOK	ETF	29.04	29.1	29.0033	29.09	27621.0
2011-09-07	AOM	ETF	29.66	29.78	29.66	29.73	5654.0
2011-09-07	AOR	ETF	30.54	30.79	30.5	30.79	20882.0
2011-09-07	ARB	ETF	34.93	35.47	34.45	35.41	201239.0
2011-09-07	ARGT	ETF	24.3	24.54	24.3	24.54	250.0
2011-09-07	ASEA	ETF	16.18	16.25	16.12	16.21	3500.0
2011-09-07	AWAY	ETF	40.75	45.75	40.75	41.75	230797.0
2011-09-07	BAB	ETF	28.03	28.15	27.94	28.14	182498.0
2011-09-07	BAL	ETF	68.18	69.48	68.18	69.41	188592.0
2011-09-07	BALT	ETF	5.12	5.12	4.96	4.98	108565.0
2011-09-07	BBH	ETF	32.52	32.9033	32.5133	32.8867	18000.0
2011-09-07	BCM	ETF	48.22	48.22	48.22	48.22	985.0
2011-09-07	BIB	ETF	7.3675	7.6125	7.3637	7.605	51616.0
2011-09-07	BICK	ETF	26.78	27.07	26.7101	27.01	9045.0
2011-09-07	BIL	ETF	91.7	91.7	91.68	91.68	367950.0
2011-09-07	BIS	ETF	6793.6	6811.2	6586.88	6586.88	98.0
2011-09-07	BITS	ETF	22.12	22.24	21.72	21.928	4325.0
2011-09-07	BIV	ETF	88.25	88.3	87.82	88.15	104400.0
2011-09-07	BJK	ETF	33.09	33.44	33.09	33.44	24100.0
2011-09-07	BKF	ETF	41.17	41.79	40.96	41.68	231874.0
2011-09-07	BKLN	ETF	23.28	23.41	23.24	23.34	83700.0
2011-09-07	BLV	ETF	89.37	89.46	88.88	89.12	39600.0
2011-09-07	BMVP	ETF	13.26	13.53	13.26	13.51	24152.0
2011-09-07	BND	ETF	83.78	83.8	83.62	83.7	1235500.0
2011-09-07	BNO	ETF	38.025	38.745	37.97	38.72	58400.0
2011-09-07	BRF	ETF	50.59	52.04	50.17	52.04	609766.0

> showing 50 of 867 rows — these rows as CSV

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