PREVIEW / etf_daily / 2011-10-10

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-10.parquet
  size:    36 KB
  rows:    871

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-10-10	SPY	ETF	117.68	119.63	117.67	119.58	230666300.0
2011-10-10	QQQ	ETF	54.98	55.94	54.89	55.94	48229045.0
2011-10-10	IWM	ETF	66.97	68.38	65.54	68.37	76366700.0
2011-10-10	DIA	ETF	112.6	114.24	112.59	114.21	7176500.0
2011-10-10	GLD	ETF	162.05	163.32	161.14	163.27	8984500.0
2011-10-10	TLT	ETF	116.82	116.91	115.8	116.57	3567600.0
2011-10-10	AAXJ	ETF	48.88	50.09	48.88	50.09	230400.0
2011-10-10	ACTV	ETF	14.65	14.65	14.22	14.49	75145.0
2011-10-10	ACWI	ETF	41.03	41.64	40.87	41.62	259500.0
2011-10-10	ACWX	ETF	36.92	37.389	36.85	37.36	129288.0
2011-10-10	ADRE	ETF	37.35	38.0	37.35	37.94	25764.0
2011-10-10	AFK	ETF	26.67	27.11	26.57	27.11	39917.0
2011-10-10	AGEM	ETF	20.91	20.97	20.875	20.97	4100.0
2011-10-10	AGG	ETF	109.16	109.23	108.7	109.01	711500.0
2011-10-10	AGQ	ETF	238.84	243.04	234.52	239.12	575550.0
2011-10-10	AGZ	ETF	112.2	112.2	110.86	111.75	16278.0
2011-10-10	AIA	ETF	38.05	39.0	38.05	39.0	25292.0
2011-10-10	AIQ	ETF	5.65	6.1	5.575	6.1	17200.0
2011-10-10	AIS	ETF	2.18	2.23	2.14	2.23	651281.0
2011-10-10	AIVI	ETF	40.69	41.12	40.54	41.05	55600.0
2011-10-10	AMJ	ETF	34.29	34.61	34.27	34.54	774370.0
2011-10-10	AMLP	ETF	76.5	77.25	75.75	76.8	205000.0
2011-10-10	AOA	ETF	31.31	31.72	31.31	31.72	5400.0
2011-10-10	AOK	ETF	28.71	28.8092	28.71	28.8	26400.0
2011-10-10	AOM	ETF	29.16	29.37	29.16	29.37	5834.0
2011-10-10	AOR	ETF	29.99	30.25	29.99	30.1945	9233.0
2011-10-10	ARB	ETF	36.85	37.32	36.41	36.96	303398.0
2011-10-10	ASEA	ETF	14.4	14.51	14.4	14.43	5700.0
2011-10-10	AWAY	ETF	35.72	35.9	34.33	35.69	64315.0
2011-10-10	BAB	ETF	28.39	28.58	28.0	28.49	148606.0
2011-10-10	BAL	ETF	63.79	64.3	63.71	64.1	22151.0
2011-10-10	BALT	ETF	4.73	5.09	4.725	5.09	95571.0
2011-10-10	BBH	ETF	33.81	33.94	33.6933	33.9167	35100.0
2011-10-10	BCM	ETF	43.09	43.09	43.0	43.0	690.0
2011-10-10	BIB	ETF	7.4287	7.5263	7.4287	7.4813	20800.0
2011-10-10	BICK	ETF	23.15	23.759	23.15	23.64	10524.0
2011-10-10	BIL	ETF	91.68	91.7	91.66	91.68	1657350.0
2011-10-10	BIS	ETF	6635.2	6635.2	6456.0	6504.0	18.2
2011-10-10	BITS	ETF	21.04	21.96	20.44	21.68	569.0
2011-10-10	BIV	ETF	86.61	86.79	85.97	86.09	184600.0
2011-10-10	BJK	ETF	29.8	30.38	29.8	30.35	39800.0
2011-10-10	BKF	ETF	35.7	36.35	35.57	36.32	225250.0
2011-10-10	BKLN	ETF	22.94	23.25	22.92	23.15	67300.0
2011-10-10	BLNG	ETF	50.675	50.675	50.675	50.675	100.0
2011-10-10	BLV	ETF	90.22	90.62	88.94	89.59	61900.0
2011-10-10	BMVP	ETF	12.77	12.99	12.77	12.99	8977.0
2011-10-10	BND	ETF	83.05	83.13	82.72	82.96	1072500.0
2011-10-10	BNO	ETF	36.06	36.725	36.06	36.725	106000.0
2011-10-10	BOIL	ETF	3920000.0	3920000.0	3727000.0	3767000.0	0.04
2011-10-10	BRF	ETF	41.88	42.75	41.88	42.43	153376.0

> showing 50 of 871 rows — these rows as CSV

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