PREVIEW / etf_daily / 2010-08-06

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-06.parquet
  size:    33 KB
  rows:    768

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-06	SPY	ETF	111.74	112.57	110.92	112.39	239728300.0
2010-08-06	QQQ	ETF	46.32	46.85	46.05	46.76	71339442.0
2010-08-06	IWM	ETF	64.45	65.41	63.86	65.14	62483200.0
2010-08-06	DIA	ETF	105.92	106.73	105.31	106.69	7524700.0
2010-08-06	GLD	ETF	117.99	118.42	117.49	117.84	10001700.0
2010-08-06	TLT	ETF	99.79	100.21	99.49	100.1	6042400.0
2010-08-06	AADR	ETF	25.31	25.71	25.31	25.71	700.0
2010-08-06	AAXJ	ETF	56.61	57.02	56.42	56.97	1236600.0
2010-08-06	ACWI	ETF	41.85	42.08	41.6	42.08	148800.0
2010-08-06	ACWX	ETF	39.8	40.0745	39.65	40.02	19850.0
2010-08-06	ADRE	ETF	43.25	43.5599	43.0	43.36	92128.0
2010-08-06	AFK	ETF	31.35	31.41	31.15	31.41	8264.0
2010-08-06	AGG	ETF	107.67	107.74	107.48	107.63	809200.0
2010-08-06	AGQ	ETF	122.06	123.28	121.16	121.7	60650.0
2010-08-06	AGZ	ETF	110.81	110.81	110.58	110.74	25605.0
2010-08-06	AIA	ETF	40.57	40.69	40.2201	40.69	3300.0
2010-08-06	AIQ	ETF	22.35	23.5	21.85	23.5	44209.0
2010-08-06	AIS	ETF	1.68	1.73	1.65	1.69	858830.0
2010-08-06	AIVI	ETF	41.47	41.92	41.43	41.9	15600.0
2010-08-06	AMJ	ETF	33.75	33.76	33.48	33.72	1658498.0
2010-08-06	AOA	ETF	30.59	30.68	30.34	30.66	21300.0
2010-08-06	AOK	ETF	28.0299	28.05	27.948	28.026	14906.0
2010-08-06	AOM	ETF	28.69	28.72	28.55	28.71	9437.0
2010-08-06	AOR	ETF	29.35	29.43	29.2564	29.43	3694.0
2010-08-06	ARB	ETF	28.06	28.38	27.35	27.54	249330.0
2010-08-06	BAB	ETF	26.19	26.29	26.126	26.27	308497.0
2010-08-06	BAL	ETF	39.37	39.37	39.09	39.23	21709.0
2010-08-06	BALT	ETF	11.18	11.77	11.07	11.46	126802.0
2010-08-06	BBH	ETF	31.6533	32.1867	31.5467	32.15	93000.0
2010-08-06	BIB	ETF	6.0	6.0	5.8812	5.89	4800.0
2010-08-06	BICK	ETF	29.42	29.555	29.2	29.5	20833.0
2010-08-06	BIL	ETF	91.68	91.7	91.68	91.68	131100.0
2010-08-06	BIS	ETF	11030.384	11048.0	10604.8	10604.8	28.75
2010-08-06	BITS	ETF	27.6	27.6	27.6	27.6	150.0
2010-08-06	BIV	ETF	84.85	84.99	84.74	84.99	169000.0
2010-08-06	BJK	ETF	25.84	26.01	25.68	26.0	22000.0
2010-08-06	BKF	ETF	45.49	45.71	45.17	45.63	72948.0
2010-08-06	BLV	ETF	82.86	83.08	82.68	83.02	70300.0
2010-08-06	BMVP	ETF	12.63	12.728	12.574	12.697	10405.0
2010-08-06	BND	ETF	81.92	82.03	81.83	82.03	2527100.0
2010-08-06	BNE	ETF	11.17	11.2	11.17	11.19	478308.0
2010-08-06	BNO	ETF	27.365	27.64	27.045	27.26	108600.0
2010-08-06	BRF	ETF	50.35	50.5399	50.0201	50.28	523295.0
2010-08-06	BSCE	ETF	20.77	20.78	20.72	20.72	19155.0
2010-08-06	BSV	ETF	81.47	81.47	81.32	81.45	420700.0
2010-08-06	BTF	ETF	70.8	70.89999999999999	70.35	70.75	3803.6000000000004
2010-08-06	BWX	ETF	29.075	29.27	29.075	29.25	156012.0
2010-08-06	BWZ	ETF	35.75	36.09	35.75	35.99	5238.0
2010-08-06	BZQ	ETF	3275.2	3326.4	3216.0	3283.2	616.0
2010-08-06	CEF	ETF	14.74	14.86	14.73	14.82	852700.0

> showing 50 of 768 rows — these rows as CSV

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