PREVIEW / etf_daily / 2011-07-14

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-14.parquet
  size:    36 KB
  rows:    862

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-07-14	SPY	ETF	132.17	132.78	130.68	130.93	226111800.0
2011-07-14	QQQ	ETF	57.93	58.18	56.87	57.09	98773895.0
2011-07-14	IWM	ETF	83.75	84.17	82.05	82.26	91726600.0
2011-07-14	DIA	ETF	124.89	125.67	123.97	124.21	6517000.0
2011-07-14	GLD	ETF	154.81	155.24	153.95	154.54	17613600.0
2011-07-14	TLT	ETF	96.62	97.9	96.01	96.01	11471500.0
2011-07-14	AADR	ETF	31.28	31.28	30.68	30.83	2400.0
2011-07-14	AAXJ	ETF	61.61	61.87	61.07	61.21	402600.0
2011-07-14	ACTV	ETF	18.75	18.75	18.4	18.42	74406.0
2011-07-14	ACWI	ETF	47.68	47.91	47.15	47.28	723500.0
2011-07-14	ACWX	ETF	44.11	44.13	43.43	43.56	80585.0
2011-07-14	ADRE	ETF	45.71	45.81	45.04	45.14	86371.0
2011-07-14	AFK	ETF	31.49	31.85	31.27	31.39	14955.0
2011-07-14	AGEM	ETF	25.87	25.87	25.7531	25.7531	563.0
2011-07-14	AGG	ETF	107.57	107.71	107.42	107.44	1724900.0
2011-07-14	AGQ	ETF	412.66	419.0	395.56	398.2	1500600.0
2011-07-14	AGZ	ETF	111.01	111.0199	110.8203	110.8203	6406.0
2011-07-14	AIA	ETF	46.2	46.29	45.78	45.84	31006.0
2011-07-14	AIQ	ETF	18.25	18.45	18.05	18.05	40104.0
2011-07-14	AIS	ETF	2.46	2.46	2.39	2.39	823898.0
2011-07-14	AIVI	ETF	45.35	45.49	44.7	44.74	10400.0
2011-07-14	AMJ	ETF	37.22	37.43	36.92	36.995	1195441.0
2011-07-14	AMLP	ETF	80.3	80.5	79.85	80.0	119840.0
2011-07-14	AOA	ETF	35.92	35.92	35.47	35.47	7500.0
2011-07-14	AOK	ETF	29.47	29.48	29.36	29.36	11486.0
2011-07-14	AOM	ETF	30.75	30.75	30.511	30.514	26716.0
2011-07-14	AOR	ETF	32.6112	32.74	32.38	32.38	8022.0
2011-07-14	ARB	ETF	40.6	41.1	39.691	39.94	95181.0
2011-07-14	ASEA	ETF	16.77	16.9	16.69	16.69	4600.0
2011-07-14	AWAY	ETF	41.66	42.15	40.6	41.39	188427.0
2011-07-14	BAB	ETF	26.63	26.68	26.54	26.54	129314.0
2011-07-14	BAL	ETF	64.64	64.98	63.32	64.38	212570.0
2011-07-14	BALT	ETF	5.07	5.0744	4.94	4.96	174211.0
2011-07-14	BBH	ETF	35.38	35.4367	34.7933	34.8567	46800.0
2011-07-14	BCM	ETF	48.45	48.45	48.4499	48.4499	250.0
2011-07-14	BIB	ETF	10.0213	10.0962	9.75	9.7888	165024.0
2011-07-14	BICK	ETF	31.88	31.88	31.4	31.5	23419.0
2011-07-14	BIL	ETF	91.72	91.72	91.7	91.72	216650.0
2011-07-14	BIS	ETF	5782.4	5864.0	5723.2	5864.0	12.65
2011-07-14	BITS	ETF	22.76	22.76	21.6	21.6	524.0
2011-07-14	BIV	ETF	85.03	85.25	84.9	84.9	106400.0
2011-07-14	BJK	ETF	35.3	35.3	34.92	34.99	13400.0
2011-07-14	BKF	ETF	47.0	47.08	46.2518	46.3	176671.0
2011-07-14	BKLN	ETF	24.81	24.91	24.81	24.89	102600.0
2011-07-14	BLV	ETF	81.78	81.98	81.22	81.28	72100.0
2011-07-14	BMVP	ETF	15.7233	15.8167	15.5034	15.5267	63619.0
2011-07-14	BND	ETF	81.82	81.93	81.67	81.67	998500.0
2011-07-14	BNO	ETF	39.335	39.525	38.64	38.87	164600.0
2011-07-14	BRF	ETF	54.23	54.23	52.85	52.95	265171.0
2011-07-14	BSCE	ETF	21.19	21.24	21.1831	21.2028	5685.0

> showing 50 of 862 rows — these rows as CSV

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