PREVIEW / etf_daily / 2013-03-14

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-14.parquet
  size:    40 KB
  rows:    981

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-03-14	SPY	ETF	156.31	156.8	155.91	156.73	126329900.0
2013-03-14	QQQ	ETF	68.87	69.01	68.711	68.86	31537685.0
2013-03-14	IWM	ETF	94.03	94.81	93.87	94.8	24747300.0
2013-03-14	DIA	ETF	144.81	145.35	144.76	145.33	5361200.0
2013-03-14	GLD	ETF	153.02	154.17	153.01	153.68	11410400.0
2013-03-14	TLT	ETF	115.09	115.64	114.98	115.22	9352100.0
2013-03-14	AADR	ETF	33.08	33.08	33.08	33.08	100.0
2013-03-14	AAXJ	ETF	59.31	59.63	59.31	59.56	303100.0
2013-03-14	ACTV	ETF	4.68	4.78	4.64	4.69	335765.0
2013-03-14	ACWI	ETF	50.92	51.09	50.84	51.03	992300.0
2013-03-14	ACWV	ETF	60.37	60.61	60.33	60.59	41100.0
2013-03-14	ACWX	ETF	43.12	43.43	43.12	43.42	105505.0
2013-03-14	ADRE	ETF	39.23	39.37	39.18	39.23	16105.0
2013-03-14	AFK	ETF	30.53	30.62	30.43	30.61	12962.0
2013-03-14	AGEM	ETF	22.85	22.96	22.85	22.93	1038.0
2013-03-14	AGG	ETF	109.9	110.15	109.9	110.11	1090700.0
2013-03-14	AGQ	ETF	154.4	157.0	154.36	155.4	268350.0
2013-03-14	AGZ	ETF	112.78	112.94	112.78	112.94	15739.0
2013-03-14	AIA	ETF	46.49	46.68	46.48	46.6545	41693.0
2013-03-14	AIQ	ETF	7.25	7.25	6.99	7.11	42947.0
2013-03-14	AIVI	ETF	42.65	42.98	42.65	42.93	25600.0
2013-03-14	ALTL	ETF	29.09	29.09	29.0845	29.0845	365.0
2013-03-14	AMJ	ETF	43.4	43.5897	43.23	43.44	1053902.0
2013-03-14	AMLP	ETF	85.75	85.95	85.4	85.75	499400.0
2013-03-14	ANGL	ETF	27.17	27.17	27.1	27.17	3900.0
2013-03-14	AOA	ETF	39.66	39.79	39.66	39.77	8700.0
2013-03-14	AOK	ETF	31.11	31.15	31.1	31.15	40617.0
2013-03-14	AOM	ETF	32.7199	32.78	32.68	32.78	14006.0
2013-03-14	AOR	ETF	35.58	35.67	35.57	35.67	22939.0
2013-03-14	ARB	ETF	46.78	46.95	46.78	46.87	710971.0
2013-03-14	ARGT	ETF	17.9	17.94	17.84	17.9	8050.0
2013-03-14	ASEA	ETF	17.31	17.36	17.31	17.35	7100.0
2013-03-14	ATMP	ETF	24.85	24.92	24.79	24.79	876400.0
2013-03-14	AWAY	ETF	30.3	30.45	29.87	30.44	896263.0
2013-03-14	BAB	ETF	29.99	30.13	29.99	30.07	396401.0
2013-03-14	BAL	ETF	58.0	58.9499	58.0	58.85	50134.0
2013-03-14	BALT	ETF	3.94	3.98	3.9	3.94	64776.0
2013-03-14	BBH	ETF	63.05	63.2	62.83	63.2	19700.0
2013-03-14	BCM	ETF	43.032	43.0585	43.032	43.0585	349.0
2013-03-14	BIB	ETF	18.75	18.9075	18.6638	18.87	43476.0
2013-03-14	BICK	ETF	24.84	24.84	24.8101	24.8101	3000.0
2013-03-14	BIL	ETF	91.62	91.62	91.6	91.62	105100.0
2013-03-14	BIS	ETF	1990.04	2004.12	1990.0	1992.0	34.5
2013-03-14	BIV	ETF	86.96	87.18	86.96	87.09	206000.0
2013-03-14	BIZD	ETF	21.01	21.01	20.89	20.97	26500.0
2013-03-14	BJK	ETF	38.54	38.84	38.54	38.78	14700.0
2013-03-14	BKF	ETF	40.01	40.0875	39.864	39.921	76845.0
2013-03-14	BKLN	ETF	25.16	25.16	25.14	25.16	2201800.0
2013-03-14	BLV	ETF	90.49	90.59	90.11	90.25	44600.0
2013-03-14	BMVP	ETF	18.33	18.37	18.33	18.37	6861.0

> showing 50 of 981 rows — these rows as CSV

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