PREVIEW / etf_daily / 2011-05-03

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-03.parquet
  size:    36 KB
  rows:    851

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
2011-05-03	SPY	ETF	135.96	136.19	135.04	135.73	138375000.0
2011-05-03	QQQ	ETF	58.95	59.0	58.33	58.69	38143408.0
2011-05-03	IWM	ETF	85.29	85.49	83.72	84.3	56070000.0
2011-05-03	DIA	ETF	127.76	128.18	127.27	127.82	7708200.0
2011-05-03	GLD	ETF	150.43	150.97	148.85	149.88	24215600.0
2011-05-03	TLT	ETF	93.96	94.17	93.58	94.17	6486600.0
2011-05-03	AADR	ETF	32.25	32.25	31.61	31.61	700.0
2011-05-03	AAXJ	ETF	64.2	64.29	63.64	63.94	479900.0
2011-05-03	ACWI	ETF	50.42	50.52	49.98	50.21	213200.0
2011-05-03	ACWX	ETF	47.27	47.42	46.9	47.02	31905.0
2011-05-03	ADRE	ETF	47.91	47.93	47.2564	47.47	57851.0
2011-05-03	AFK	ETF	33.98	33.98	33.61	33.65	8677.0
2011-05-03	AGG	ETF	106.26	106.34	106.15	106.23	485900.0
2011-05-03	AGQ	ETF	588.78	602.54	503.12	529.94	2937000.0
2011-05-03	AGZ	ETF	109.94	109.94	109.7801	109.892	26000.0
2011-05-03	AIA	ETF	49.18	49.19	48.6644	48.895	36064.0
2011-05-03	AIQ	ETF	21.35	21.45	20.9	21.0	27499.0
2011-05-03	AIS	ETF	1.83	1.84	1.74	1.74	441326.0
2011-05-03	AIVI	ETF	49.9	50.22	49.75	49.87	4500.0
2011-05-03	AMJ	ETF	38.68	38.77	37.89	37.99	1775440.0
2011-05-03	AMLP	ETF	82.85	82.9	81.75	81.9	178640.0
2011-05-03	AOA	ETF	36.99	36.99	36.65	36.8	18000.0
2011-05-03	AOK	ETF	29.56	29.56	29.48	29.53	20805.0
2011-05-03	AOM	ETF	31.08	31.13	31.01	31.02	26401.0
2011-05-03	AOR	ETF	33.28	33.3001	33.1464	33.25	17315.0
2011-05-03	ARB	ETF	39.76	40.04	38.89	39.04	174391.0
2011-05-03	ARGT	ETF	30.0	30.06	30.0	30.0	650.0
2011-05-03	ASEA	ETF	16.5	16.56	16.4	16.46	3500.0
2011-05-03	BAB	ETF	25.96	25.97	25.9	25.96	91685.0
2011-05-03	BAL	ETF	86.64	88.0	85.45	86.67	181706.0
2011-05-03	BALT	ETF	8.02	8.089	7.9	7.95	250755.0
2011-05-03	BBH	ETF	34.8067	35.0533	34.66	35.0533	61800.0
2011-05-03	BCM	ETF	50.16	50.26	49.77	49.84	5100.0
2011-05-03	BIB	ETF	9.9775	9.9775	9.6438	9.6813	75480.0
2011-05-03	BICK	ETF	34.32	34.32	33.7	33.79	13211.0
2011-05-03	BIL	ETF	91.72	91.72	91.7	91.7	127100.0
2011-05-03	BIS	ETF	5948.8	6049.6	5948.8	6014.4	39.2
2011-05-03	BITS	ETF	23.34	23.88	22.76	23.4	1950.0
2011-05-03	BIV	ETF	83.24	83.34	83.12	83.32	79000.0
2011-05-03	BJK	ETF	35.14	35.16	34.69	34.86	9600.0
2011-05-03	BKF	ETF	49.43	49.46	48.58	48.78	97930.0
2011-05-03	BKLN	ETF	25.3	25.3	25.24	25.27	130000.0
2011-05-03	BLNG	ETF	50.59	50.59	49.8	49.8	3100.0
2011-05-03	BLV	ETF	79.89	80.04	79.75	79.99	39000.0
2011-05-03	BMVP	ETF	15.97	15.97	15.84	15.8536	2026.0
2011-05-03	BND	ETF	80.84	80.88	80.75	80.85	693400.0
2011-05-03	BNO	ETF	41.095	41.225	40.5	40.65	76000.0
2011-05-03	BRF	ETF	57.77	57.9	56.4101	56.73	288120.0
2011-05-03	BSCE	ETF	21.07	21.1	21.04	21.08	16936.0
2011-05-03	BSV	ETF	80.66	80.68	80.61	80.65	538300.0

> showing 50 of 851 rows — these rows as CSV

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