PREVIEW / etf_daily / 2010-08-13

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-13.parquet
  size:    33 KB
  rows:    766

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-08-13	SPY	ETF	108.29	108.96	108.18	108.31	158698500.0
2010-08-13	QQQ	ETF	44.87	45.06	44.71	44.72	46387264.0
2010-08-13	IWM	ETF	61.5	61.68	60.97	61.07	68238000.0
2010-08-13	DIA	ETF	103.21	103.8	103.1	103.35	6481600.0
2010-08-13	GLD	ETF	118.82	118.89	118.36	118.74	10213200.0
2010-08-13	TLT	ETF	101.62	102.45	101.48	102.29	7843600.0
2010-08-13	AADR	ETF	25.17	25.17	25.17	25.17	100.0
2010-08-13	AAXJ	ETF	54.92	55.29	54.92	55.11	157800.0
2010-08-13	ACWI	ETF	40.35	40.51	40.24	40.28	113800.0
2010-08-13	ACWX	ETF	38.04	38.3	38.04	38.1	21829.0
2010-08-13	ADRE	ETF	41.74	42.05	41.7101	41.83	101528.0
2010-08-13	AFK	ETF	30.13	30.2	30.0	30.1	2553.0
2010-08-13	AGG	ETF	107.77	108.0	107.67	107.99	580300.0
2010-08-13	AGQ	ETF	116.32	117.3	115.06	117.02	61550.0
2010-08-13	AGZ	ETF	110.91	110.97	110.74	110.74	11789.0
2010-08-13	AIA	ETF	39.38	39.38	39.215	39.25	11173.0
2010-08-13	AIQ	ETF	22.8	23.3	22.15	22.75	58898.0
2010-08-13	AIS	ETF	1.65	1.66	1.58	1.62	547732.0
2010-08-13	AIVI	ETF	39.83	40.04	39.63	39.63	7700.0
2010-08-13	AMJ	ETF	32.08	32.78	32.08	32.7	482134.0
2010-08-13	AOA	ETF	29.48	29.53	29.44	29.44	2000.0
2010-08-13	AOK	ETF	27.76	27.78	27.738	27.738	17504.0
2010-08-13	AOM	ETF	28.18	28.2755	28.18	28.256	6571.0
2010-08-13	AOR	ETF	28.71	28.785	28.668	28.676	9581.0
2010-08-13	ARB	ETF	26.03	26.34	25.7	25.83	145502.0
2010-08-13	BAB	ETF	26.3	26.4	26.25	26.37	284905.0
2010-08-13	BAL	ETF	41.33	41.69	41.25	41.34	5993.0
2010-08-13	BALT	ETF	10.38	10.78	10.2	10.3	442224.0
2010-08-13	BBH	ETF	31.0933	31.4133	31.0933	31.2733	30000.0
2010-08-13	BICK	ETF	28.49	28.65	28.49	28.65	3522.0
2010-08-13	BIL	ETF	91.7	91.72	91.7	91.72	580550.0
2010-08-13	BIS	ETF	11299.2	11299.2	11150.4	11164.8	5.9
2010-08-13	BITS	ETF	27.6	28.0	26.68	28.0	388.0
2010-08-13	BIV	ETF	85.45	85.74	85.44	85.71	219100.0
2010-08-13	BJK	ETF	24.97	25.23	24.97	25.21	8000.0
2010-08-13	BKF	ETF	43.94	43.95	43.63	43.71	63149.0
2010-08-13	BLV	ETF	83.53	84.47	83.53	84.43	55500.0
2010-08-13	BMVP	ETF	12.22	12.27	12.2	12.22	10192.0
2010-08-13	BND	ETF	82.11	82.25	82.01	82.24	670400.0
2010-08-13	BNE	ETF	11.15	11.18	11.12	11.12	296431.0
2010-08-13	BNO	ETF	25.5	25.55	25.365	25.55	34600.0
2010-08-13	BRF	ETF	48.38	49.062	48.38	48.81	144556.0
2010-08-13	BSCE	ETF	20.807	20.81	20.804	20.804	16790.0
2010-08-13	BSV	ETF	81.38	81.49	81.38	81.48	325000.0
2010-08-13	BTF	ETF	68.94999999999999	69.1	68.64999999999999	68.8	4733.2
2010-08-13	BWX	ETF	28.41	28.565	28.16	28.16	160542.0
2010-08-13	BWZ	ETF	34.97	35.25	34.97	34.98	6677.0
2010-08-13	BZQ	ETF	3504.0	3520.0	3430.4	3520.0	661.0
2010-08-13	CEF	ETF	14.87	14.88	14.77	14.78	465700.0
2010-08-13	CEW	ETF	21.98	21.98	21.88	21.91	38907.0

> showing 50 of 766 rows — these rows as CSV

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