PREVIEW / etf_daily / 2013-12-24

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-24.parquet
  size:    42 KB
  rows:    1,039

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
2013-12-24	SPY	ETF	182.54	183.01	182.53	182.93	45368800.0
2013-12-24	QQQ	ETF	87.43	87.51	87.27	87.45	13852475.0
2013-12-24	IWM	ETF	114.91	115.44	114.87	115.22	17371200.0
2013-12-24	DIA	ETF	162.72	163.26	162.59	163.16	2462000.0
2013-12-24	GLD	ETF	115.79	116.29	115.71	116.1	3353900.0
2013-12-24	TLT	ETF	103.23	103.35	102.8	102.83	4897000.0
2013-12-24	AADR	ETF	37.19	37.21	37.19	37.21	1600.0
2013-12-24	AAXJ	ETF	58.99	59.36	58.99	59.34	280600.0
2013-12-24	ACWI	ETF	56.74	56.87	56.68	56.86	404400.0
2013-12-24	ACWV	ETF	62.9	62.99	62.77	62.98	28800.0
2013-12-24	ACWX	ETF	45.72	45.87	45.704	45.86	117302.0
2013-12-24	ADRE	ETF	36.62	36.718	36.57	36.7	14990.0
2013-12-24	AFK	ETF	29.95	30.42	29.95	30.42	25622.0
2013-12-24	AGG	ETF	106.72	106.76	106.63	106.66	688500.0
2013-12-24	AGQ	ETF	62.96	63.88	62.88	63.36	103725.0
2013-12-24	AGZ	ETF	110.6995	110.73	110.59	110.633	7394.0
2013-12-24	AGZD	ETF	25.05	25.05	25.05	25.05	2800.0
2013-12-24	AIA	ETF	47.1	47.42	47.1	47.339	12746.0
2013-12-24	AIQ	ETF	25.34	25.85	25.29	25.64	7338.0
2013-12-24	AIVI	ETF	46.53	46.94	46.28	46.62	8600.0
2013-12-24	ALTL	ETF	32.71	32.71	32.67	32.67	991.0
2013-12-24	AMJ	ETF	45.36	45.65	45.1201	45.45	489741.0
2013-12-24	AMLP	ETF	87.4	87.9	87.25	87.55	406960.0
2013-12-24	ANGL	ETF	26.86	27.18	26.86	27.18	1300.0
2013-12-24	AOA	ETF	44.37	44.43	44.3	44.43	29900.0
2013-12-24	AOK	ETF	31.99	31.99	31.96	31.96	29391.0
2013-12-24	AOM	ETF	34.32	34.34	34.251	34.34	24577.0
2013-12-24	AOR	ETF	38.45	38.47	38.4134	38.46	28008.0
2013-12-24	ARGT	ETF	20.3	20.3	20.02	20.02	5400.0
2013-12-24	ASEA	ETF	15.78	15.92	15.76	15.84	6000.0
2013-12-24	ASHR	ETF	24.14	24.24	24.05	24.18	162000.0
2013-12-24	ATMP	ETF	26.75	26.86	26.71	26.73	21600.0
2013-12-24	AVIV	ETF	23.95	24.19	23.91	24.02	27236.0
2013-12-24	AWAY	ETF	40.85	41.52	40.42	40.51	647268.0
2013-12-24	BAB	ETF	27.49	27.52	27.4	27.42	82017.0
2013-12-24	BAL	ETF	51.62	52.26	51.51	51.54	4208.0
2013-12-24	BALT	ETF	6.36	6.49	6.26	6.28	717663.0
2013-12-24	BBH	ETF	88.76	88.76	87.69	88.17	37600.0
2013-12-24	BCM	ETF	39.58	39.79	39.58	39.7	85341.0
2013-12-24	BFOR	ETF	7.4375	7.47	7.425	7.4425	162800.0
2013-12-24	BIB	ETF	37.6475	37.6875	36.7875	37.3125	97424.0
2013-12-24	BICK	ETF	24.45	24.57	24.431	24.57	3787.0
2013-12-24	BIL	ETF	91.54	91.56	91.54	91.56	111300.0
2013-12-24	BIS	ETF	828.0	845.196	828.0	842.4	120.5
2013-12-24	BIV	ETF	81.99	82.0	81.85	81.9	141400.0
2013-12-24	BIZD	ETF	21.35	21.45	21.35	21.41	7300.0
2013-12-24	BJK	ETF	52.29	52.59	51.89	52.55	12500.0
2013-12-24	BKF	ETF	37.22	37.44	37.22	37.4	39547.0
2013-12-24	BKLN	ETF	24.8	24.83	24.8	24.82	1080300.0
2013-12-24	BLV	ETF	82.25	82.5	82.23	82.24	32700.0

> showing 50 of 1,039 rows — these rows as CSV

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