PREVIEW / etf_daily / 2010-11-12

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-12.parquet
  size:    34 KB
  rows:    805

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-12	SPY	ETF	120.82	121.35	119.65	120.2	239068800.0
2010-11-12	QQQ	ETF	53.1	53.3672	52.11	52.51	99164258.0
2010-11-12	IWM	ETF	72.53	73.1	71.9	72.03	48799200.0
2010-11-12	DIA	ETF	112.46	112.99	111.65	112.16	8695800.0
2010-11-12	GLD	ETF	135.89	136.31	132.82	133.69	35885900.0
2010-11-12	TLT	ETF	96.21	96.74	95.81	95.81	11739500.0
2010-11-12	AADR	ETF	29.01	29.01	27.02	28.69	5500.0
2010-11-12	AAXJ	ETF	63.76	63.91	62.82	63.28	505400.0
2010-11-12	ACWI	ETF	45.69	45.83	45.14	45.38	253300.0
2010-11-12	ACWX	ETF	43.61	43.719	43.07	43.28	56471.0
2010-11-12	ADRE	ETF	46.86	47.214	46.24	46.53	76642.0
2010-11-12	AFK	ETF	34.43	34.54	33.76	34.054	37341.0
2010-11-12	AGG	ETF	107.8	107.94	107.51	107.51	759500.0
2010-11-12	AGQ	ETF	252.1	254.8	227.12	232.64	1059900.0
2010-11-12	AGZ	ETF	111.11	111.46	110.7901	111.46	43234.0
2010-11-12	AIA	ETF	45.66	45.71	45.05	45.24	60125.0
2010-11-12	AIQ	ETF	20.7	20.8	20.45	20.55	28504.0
2010-11-12	AIS	ETF	1.55	1.55	1.47	1.49	378073.0
2010-11-12	AIVI	ETF	45.02	45.14	44.43	44.65	84700.0
2010-11-12	AMJ	ETF	36.72	36.78	36.32	36.425	579684.0
2010-11-12	AMLP	ETF	80.25	80.25	79.6	79.8	76600.0
2010-11-12	AOA	ETF	33.25	33.31	32.93	32.99	12800.0
2010-11-12	AOK	ETF	28.76	28.84	28.68	28.686	10314.0
2010-11-12	AOM	ETF	29.79	29.79	29.62	29.6999	5371.0
2010-11-12	AOR	ETF	31.0	31.04	30.84	30.84	12952.0
2010-11-12	ARB	ETF	25.67	26.28	25.67	25.92	156287.0
2010-11-12	BAB	ETF	25.7	25.71	25.56	25.59	338037.0
2010-11-12	BAL	ETF	68.09	68.81	66.0	68.7	164729.0
2010-11-12	BALT	ETF	12.42	12.42	12.04	12.23	230495.0
2010-11-12	BBH	ETF	33.1733	33.1867	32.8933	32.95	37500.0
2010-11-12	BIB	ETF	6.495	6.5263	6.495	6.5263	11152.0
2010-11-12	BICK	ETF	33.3	33.3	32.7	32.8	42366.0
2010-11-12	BIL	ETF	91.7	91.72	91.7	91.72	1457000.0
2010-11-12	BITS	ETF	28.6	28.6	27.24	28.6	1495.0
2010-11-12	BIV	ETF	86.63	86.7	86.05	86.14	153900.0
2010-11-12	BJK	ETF	31.61	31.61	30.94	31.09	12300.0
2010-11-12	BKF	ETF	50.03	50.3	49.3001	49.69	223527.0
2010-11-12	BLV	ETF	81.48	81.54	80.86	80.86	36700.0
2010-11-12	BMVP	ETF	14.18	14.19	14.01	14.07	9957.0
2010-11-12	BND	ETF	82.09	82.19	81.81	81.84	779900.0
2010-11-12	BNE	ETF	11.41	11.44	11.4	11.41	178008.0
2010-11-12	BNO	ETF	29.405	29.405	28.75	28.755	26000.0
2010-11-12	BRF	ETF	59.52	60.0	58.69	58.93	517613.0
2010-11-12	BSCE	ETF	21.01	21.01	20.96	20.99	15855.0
2010-11-12	BSV	ETF	81.65	81.65	81.49	81.51	669400.0
2010-11-12	BTF	ETF	79.74999999999999	80.15	78.994	79.05	5497.200000000001
2010-11-12	BWX	ETF	30.14	30.25	29.975	30.02	230052.0
2010-11-12	BWZ	ETF	37.4	37.49	37.2901	37.44	25967.0
2010-11-12	BZQ	ETF	2667.2	2734.4	2612.8	2683.2	710.0
2010-11-12	CEF	ETF	18.87	18.93	18.25	18.43	1864900.0

> showing 50 of 805 rows — these rows as CSV

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