PREVIEW / etf_daily / 2010-07-07

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-07.parquet
  size:    32 KB
  rows:    755

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-07-07	SPY	ETF	103.13	106.24	103.02	106.11	253769400.0
2010-07-07	QQQ	ETF	42.74	44.01	42.7	43.96	72448354.0
2010-07-07	IWM	ETF	59.22	61.15	58.99	61.1	79640200.0
2010-07-07	DIA	ETF	97.54	100.37	97.5	100.29	12255100.0
2010-07-07	GLD	ETF	116.57	117.78	116.5	117.73	10930100.0
2010-07-07	TLT	ETF	101.46	101.51	100.34	100.43	5727800.0
2010-07-07	AAXJ	ETF	53.06	53.91	52.85	53.88	301000.0
2010-07-07	ACWI	ETF	38.1	39.3	38.1	39.23	173000.0
2010-07-07	ACWX	ETF	36.2	37.12	36.2	37.12	75375.0
2010-07-07	ADRE	ETF	39.57	40.72	39.57	40.64	117814.0
2010-07-07	AFK	ETF	27.84	28.57	27.84	28.56	7246.0
2010-07-07	AGG	ETF	107.13	107.15	106.9	106.92	1011200.0
2010-07-07	AGQ	ETF	113.92	117.9	113.56	117.2	269950.0
2010-07-07	AGZ	ETF	110.08	110.11	109.91	109.91	106752.0
2010-07-07	AIA	ETF	37.1	37.95	37.1	37.95	20696.0
2010-07-07	AIQ	ETF	18.3	18.3	16.6	17.1	220103.0
2010-07-07	AIS	ETF	1.58	1.66	1.54	1.66	881061.0
2010-07-07	AIVI	ETF	37.47	38.42	37.47	38.42	12000.0
2010-07-07	AMJ	ETF	30.76	31.51	30.76	31.51	329176.0
2010-07-07	AOA	ETF	28.25	28.37	28.15	28.33	11600.0
2010-07-07	AOK	ETF	27.31	27.39	27.29	27.3745	2500.0
2010-07-07	AOM	ETF	27.64	27.83	27.63	27.83	4623.0
2010-07-07	AOR	ETF	27.72	28.2164	27.72	28.2164	13095.0
2010-07-07	ARB	ETF	25.18	25.66	25.02	25.59	212370.0
2010-07-07	BAB	ETF	26.03	26.06	25.79	25.81	207022.0
2010-07-07	BAL	ETF	36.06	36.36	35.93	36.36	1276.0
2010-07-07	BALT	ETF	10.11	10.3	9.92	10.17	307402.0
2010-07-07	BBH	ETF	28.8967	29.2467	28.65	29.2233	338100.0
2010-07-07	BIB	ETF	4.9313	5.1212	4.93	5.1212	2400.0
2010-07-07	BICK	ETF	27.44	27.4403	27.405	27.4403	550.0
2010-07-07	BIL	ETF	91.72	91.72	91.7	91.7	873500.0
2010-07-07	BIS	ETF	13588.8	13588.8	13099.2	13099.2	20.05
2010-07-07	BITS	ETF	26.96	26.96	26.4	26.6	1400.0
2010-07-07	BIV	ETF	83.73	83.73	83.36	83.41	163300.0
2010-07-07	BJK	ETF	23.16	23.61	23.14	23.61	34100.0
2010-07-07	BKF	ETF	41.39	42.44	41.39	42.43	138014.0
2010-07-07	BLV	ETF	81.91	82.23	81.6	81.77	45300.0
2010-07-07	BMVP	ETF	11.55	11.9	11.55	11.9	15704.0
2010-07-07	BND	ETF	81.37	81.38	81.21	81.24	588100.0
2010-07-07	BNE	ETF	11.24	11.26	11.23	11.26	893411.0
2010-07-07	BNO	ETF	24.715	24.975	24.715	24.975	7600.0
2010-07-07	BRF	ETF	44.74	46.0	44.74	45.91	564932.0
2010-07-07	BSCE	ETF	20.43	20.43	20.43	20.43	835.0
2010-07-07	BSV	ETF	80.94	80.97	80.87	80.89	718700.0
2010-07-07	BTF	ETF	65.89999999999999	67.24999999999999	65.6505	67.14999999999999	4472.400000000001
2010-07-07	BWX	ETF	27.37	27.495	27.265	27.47	250624.0
2010-07-07	BWZ	ETF	34.31	34.4499	34.23	34.35	1535.0
2010-07-07	BZQ	ETF	4129.6	4129.6	3876.8	3891.2	792.5
2010-07-07	CEF	ETF	14.41	14.72	14.41	14.66	876900.0
2010-07-07	CEW	ETF	21.47	21.53	21.41	21.478	51674.0

> showing 50 of 755 rows — these rows as CSV

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