PREVIEW / etf_daily / 2010-09-15

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-15.parquet
  size:    33 KB
  rows:    781

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-09-15	SPY	ETF	112.32	113.21	111.98	113.08	168608400.0
2010-09-15	QQQ	ETF	47.35	47.8	47.19	47.75	67108126.0
2010-09-15	IWM	ETF	64.81	65.57	64.33	65.36	63008500.0
2010-09-15	DIA	ETF	105.2	106.06	104.98	105.94	4374300.0
2010-09-15	GLD	ETF	123.97	124.29	123.43	123.94	11689100.0
2010-09-15	TLT	ETF	102.75	103.26	102.14	102.27	7919100.0
2010-09-15	AADR	ETF	27.24	27.27	27.23	27.27	1500.0
2010-09-15	AAXJ	ETF	58.27	58.5	58.02	58.42	446600.0
2010-09-15	ACWI	ETF	42.21	42.52	42.01	42.49	81900.0
2010-09-15	ACWX	ETF	40.35	40.62	40.23	40.58	59240.0
2010-09-15	ADRE	ETF	43.35	43.53	43.22	43.52	105041.0
2010-09-15	AFK	ETF	31.31	31.47	31.31	31.39	5604.0
2010-09-15	AGG	ETF	108.0	108.17	107.88	107.93	813500.0
2010-09-15	AGQ	ETF	147.56	150.1	147.14	149.8	223100.0
2010-09-15	AGZ	ETF	110.95	111.02	110.83	110.904	11153.0
2010-09-15	AIA	ETF	41.04	41.25	40.97	41.25	10450.0
2010-09-15	AIQ	ETF	22.0	22.05	21.405	21.85	19911.0
2010-09-15	AIS	ETF	1.51	1.525	1.47	1.49	703163.0
2010-09-15	AIVI	ETF	42.11	42.4	42.11	42.33	7000.0
2010-09-15	AMJ	ETF	32.99	33.0	32.876	32.94	330517.0
2010-09-15	AMLP	ETF	76.3	76.3	75.75	75.95	129900.0
2010-09-15	AOA	ETF	30.83	31.02	30.83	31.02	12600.0
2010-09-15	AOK	ETF	28.17	28.2	28.1401	28.18	5200.0
2010-09-15	AOM	ETF	28.82	28.92	28.81	28.92	6181.0
2010-09-15	AOR	ETF	29.57	29.69	29.54	29.69	27745.0
2010-09-15	ARB	ETF	26.92	27.46	26.74	27.2	117510.0
2010-09-15	BAB	ETF	26.41	26.46	26.301	26.339	225689.0
2010-09-15	BAL	ETF	46.12	46.306	45.66	45.71	6359.0
2010-09-15	BALT	ETF	11.06	11.53	11.03	11.23	154211.0
2010-09-15	BBH	ETF	31.6633	32.11	31.6633	32.0967	40800.0
2010-09-15	BIB	ETF	6.2775	6.2775	6.2775	6.2775	2880.0
2010-09-15	BICK	ETF	30.48	30.48	30.39	30.48	23311.0
2010-09-15	BIL	ETF	91.7	91.72	91.7	91.72	120300.0
2010-09-15	BIS	ETF	10160.0	10160.0	10054.72	10054.72	3.75
2010-09-15	BITS	ETF	25.8	25.8	25.2	25.76	3724.0
2010-09-15	BIV	ETF	85.47	85.77	85.38	85.4	296200.0
2010-09-15	BJK	ETF	27.17	27.43	27.17	27.4	5900.0
2010-09-15	BKF	ETF	46.08	46.31	45.73	46.3	175238.0
2010-09-15	BLV	ETF	84.41	84.65	84.0	84.08	34200.0
2010-09-15	BMVP	ETF	12.74	12.88	12.72	12.86	15665.0
2010-09-15	BND	ETF	82.08	82.18	82.01	82.05	469300.0
2010-09-15	BNE	ETF	11.07	11.1	11.07	11.09	216872.0
2010-09-15	BNO	ETF	26.525	26.675	26.525	26.67	42200.0
2010-09-15	BRF	ETF	55.2	55.309	54.76	55.0	266494.0
2010-09-15	BSCE	ETF	20.85	20.85	20.85	20.85	200.0
2010-09-15	BSV	ETF	81.47	81.5	81.39	81.39	727500.0
2010-09-15	BTF	ETF	73.94999999999999	74.25	73.49999999999999	74.16999999999999	2811.6000000000004
2010-09-15	BWX	ETF	29.1527	29.1527	28.825	28.825	113654.0
2010-09-15	BWZ	ETF	35.87	35.895	35.73	35.83	23094.0
2010-09-15	BZQ	ETF	3115.2	3158.4	3094.4	3097.6	308.0

> showing 50 of 781 rows — these rows as CSV

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