PREVIEW / etf_daily / 2011-01-14

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-14.parquet
  size:    35 KB
  rows:    817

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-01-14	SPY	ETF	128.19	129.33	128.1	129.3	117677900.0
2011-01-14	QQQ	ETF	56.59	57.02	56.46	57.0	43867399.0
2011-01-14	IWM	ETF	79.86	80.68	79.69	80.54	38036700.0
2011-01-14	DIA	ETF	116.88	117.77	116.81	117.69	5885800.0
2011-01-14	GLD	ETF	133.17	133.6	132.22	132.69	21224900.0
2011-01-14	TLT	ETF	92.78	92.9	91.76	91.84	8960700.0
2011-01-14	AADR	ETF	29.93	29.95	29.88	29.95	1900.0
2011-01-14	AAXJ	ETF	63.94	64.2	63.73	64.11	1636400.0
2011-01-14	ACWI	ETF	47.28	47.77	47.28	47.77	1684600.0
2011-01-14	ACWX	ETF	44.44	44.789	44.41	44.76	41962.0
2011-01-14	ADRE	ETF	47.92	48.218	47.92	48.2	37087.0
2011-01-14	AFK	ETF	36.01	36.45	35.876	36.29	57120.0
2011-01-14	AGG	ETF	105.99	106.0	105.73	105.73	751900.0
2011-01-14	AGQ	ETF	270.72	272.62	260.82	266.44	637350.0
2011-01-14	AGZ	ETF	109.61	109.94	109.55	109.685	15186.0
2011-01-14	AIA	ETF	48.3883	48.51	48.21	48.49	44214.0
2011-01-14	AIQ	ETF	20.7	21.85	20.6	21.75	20367.0
2011-01-14	AIS	ETF	1.71	1.72	1.66	1.7	557866.0
2011-01-14	AIVI	ETF	44.31	44.78	44.31	44.78	306000.0
2011-01-14	AMJ	ETF	37.26	37.28	37.1101	37.27	471894.0
2011-01-14	AMLP	ETF	81.3	81.4	81.2	81.35	111960.0
2011-01-14	AOA	ETF	34.88	35.1	34.86	35.09	25300.0
2011-01-14	AOK	ETF	28.94	29.0	28.94	28.984	19878.0
2011-01-14	AOM	ETF	30.11	30.24	30.11	30.2399	14932.0
2011-01-14	AOR	ETF	31.84	31.99	31.84	31.99	18265.0
2011-01-14	ARB	ETF	42.22	42.31	41.68	42.31	146933.0
2011-01-14	BAB	ETF	25.21	25.28	25.0	25.02	432586.0
2011-01-14	BAL	ETF	72.9	72.9	71.68	72.1	30837.0
2011-01-14	BALT	ETF	10.35	10.35	10.21	10.24	104267.0
2011-01-14	BBH	ETF	34.18	34.4433	34.1667	34.19	35400.0
2011-01-14	BIB	ETF	8.075	8.075	7.9287	7.9475	12032.0
2011-01-14	BICK	ETF	32.86	33.03	32.86	32.9866	23143.0
2011-01-14	BIL	ETF	91.7	91.72	91.7	91.7	199450.0
2011-01-14	BIS	ETF	7707.2	7707.2	7670.4	7670.4	3.25
2011-01-14	BITS	ETF	29.08	29.12	28.2	29.0	2088.0
2011-01-14	BIV	ETF	83.13	83.23	82.86	82.92	123200.0
2011-01-14	BJK	ETF	33.18	33.22	33.09	33.16	51400.0
2011-01-14	BKF	ETF	49.52	49.83	49.49	49.49	238392.0
2011-01-14	BLV	ETF	78.82	78.95	78.27	78.27	28400.0
2011-01-14	BMVP	ETF	14.79	14.91	14.79	14.91	12723.0
2011-01-14	BND	ETF	80.48	80.54	80.3	80.32	1107000.0
2011-01-14	BNO	ETF	32.485	32.795	32.485	32.795	39400.0
2011-01-14	BOSS	ETF	49.1	49.1	48.0	48.0	200.0
2011-01-14	BRF	ETF	57.83	58.08	57.55	57.8	177535.0
2011-01-14	BSCE	ETF	20.78	20.84	20.78	20.82	2891.0
2011-01-14	BSV	ETF	80.56	80.64	80.51	80.62	423700.0
2011-01-14	BTF	ETF	78.75	79.0	78.6	78.89999999999999	1995.8000000000002
2011-01-14	BWX	ETF	28.895	29.015	28.87	28.97	485614.0
2011-01-14	BWZ	ETF	36.97	37.03	36.85	36.86	14930.0
2011-01-14	BZQ	ETF	2420.8	2420.8	2387.2	2387.2	148.0

> showing 50 of 817 rows — these rows as CSV

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