PREVIEW / stock_daily / 2013-02-07

all stock daily files

  file:    by_date/stock_daily/2013/2013-02-07.parquet
  size:    205 KB
  rows:    6,211
  symbols: 3,478

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-02-07	AAPL	Stock	16.5446	16.7857	16.2186	16.7221	704580800.0
2013-02-07	MSFT	Stock	27.35	27.39	27.1	27.28	38028300.0
2013-02-07	NVDA	Stock	0.3075	0.31	0.3042	0.3073	440000000.0
2013-02-07	AMZN	Stock	13.205	13.205	12.7555	13.0115	79514000.0
2013-02-07	META	Stock	29.11	29.15	28.27	28.65	34540100.0
2013-02-07	TSLA	Stock	2.6127	2.6453	2.5967	2.632	17949000.0
2013-02-07	TLT	Stock	116.77	117.59	116.62	116.67	5951708.0
2013-02-07	ES	Stock	41.14	41.4	40.89	41.09	1418600.0
2013-02-07	CL	Stock	54.91	55.105	54.665	55.095	3165600.0
2013-02-07	A	Stock	32.1173	32.2318	31.7811	32.196	4393075.0
2013-02-07	AABA-DELISTED	Stock	20.1	20.43	19.93	20.32	24305491.0
2013-02-07	AACC-DELISTED	Stock	5.35	5.36	5.35	5.36	2613.0
2013-02-07	AACG	Stock	4.93	5.37	4.93	5.37	600.0
2013-02-07	AAIC-DELISTED	Stock	24.05	24.66	24.0	24.4	459551.0
2013-02-07	AAMC-DELISTED	Stock	37.2059	37.2059	36.7647	36.7647	7402.0
2013-02-07	AAME	Stock	3.4	3.42	3.4	3.41	3600.0
2013-02-07	AAMRQ-DELISTED	Stock	1.275	1.36	1.21	1.25	16433089.0
2013-02-07	AAON	Stock	7.0222	7.1022	6.9215	6.9956	200138.0
2013-02-07	AAP	Stock	79.85	81.0	73.67	77.14	5130000.0
2013-02-07	AAT	Stock	29.15	29.47	28.84	29.3	406000.0
2013-02-07	AAU-DELISTED	Stock	2.56	2.6352	2.5	2.6	229226.0
2013-02-07	AAUAF-DELISTED	Stock	2.55	2.625	2.5	2.61	230244.0
2013-02-07	AAV-DELISTED	Stock	3.05	3.08	3.02	3.08	357631.0
2013-02-07	AAWW-DELISTED	Stock	44.3	44.67	44.06	44.35	125153.0
2013-02-07	AAXJ	Stock	59.92	59.92	59.31	59.43	1441534.0
2013-02-07	AAXN-DELISTED	Stock	8.23	8.25	7.94	8.085	757226.0
2013-02-07	AB	Stock	20.39	20.8	20.31	20.5	287800.0
2013-02-07	ABAC-DELISTED	Stock	0.9	0.9	0.85	0.85	3900.0
2013-02-07	ABAX-DELISTED	Stock	43.82	43.93	42.75	43.74	117292.0
2013-02-07	ABB-DELISTED	Stock	21.17	21.2	20.84	20.94	1475566.0
2013-02-07	ABBNY-DELISTED	Stock	21.17	21.2	20.84	20.93	1490801.0
2013-02-07	ABBV	Stock	37.57	37.57	35.8	36.42	9872500.0
2013-02-07	ABC-DELISTED	Stock	46.48	46.62	45.99	46.39	2231386.0
2013-02-07	ABCB	Stock	13.49	13.63	13.38	13.51	17900.0
2013-02-07	ABCD-DELISTED	Stock	1.26	1.26	1.26	1.26	100.0
2013-02-07	ABCO-DELISTED	Stock	51.32	52.98	48.76	49.75	1181063.0
2013-02-07	ABCW-DELISTED	Stock	0.65	0.65	0.62	0.63	1975.0
2013-02-07	ABE-DELISTED	Stock	21.9	21.9	21.48	21.51	5737.0
2013-02-07	ABEO	Stock	612.5	637.5	525.0	637.5	10.0
2013-02-07	ABFS-DELISTED	Stock	10.92	11.18	10.75	10.93	332269.0
2013-02-07	ABG	Stock	36.56	36.83	35.81	35.96	159100.0
2013-02-07	ABM	Stock	22.0	22.31	21.93	22.0	594000.0
2013-02-07	ABMD-DELISTED	Stock	13.66	14.15	13.66	13.795	693712.0
2013-02-07	ABR	Stock	7.25	7.25	7.07	7.14	129900.0
2013-02-07	ABR.A-DELISTED	Stock	25.32	25.32	25.15	25.24	16800.0
2013-02-07	ABT	Stock	34.24	34.39	34.03	34.39	11918500.0
2013-02-07	ABTL-DELISTED	Stock	4.33	4.5	4.13	4.23	24685.0
2013-02-07	ABUS	Stock	4.7	4.73	4.67	4.72	28000.0
2013-02-07	ABV-DELISTED	Stock	47.0799	47.1	46.18	46.53	1412291.0
2013-02-07	ABX-DELISTED	Stock	32.58	33.05	32.42	32.73	5832157.0

> showing 50 of 6,211 rows — these rows as CSV

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