PREVIEW / stock_daily / 2013-03-27

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-27.parquet
  size:    207 KB
  rows:    6,276
  symbols: 3,487

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-27	AAPL	Stock	16.3021	16.3143	16.0975	16.1457	331237200.0
2013-03-27	MSFT	Stock	28.14	28.45	28.08	28.37	36047400.0
2013-03-27	NVDA	Stock	0.3113	0.318	0.3105	0.3163	254944000.0
2013-03-27	AMZN	Stock	12.9375	13.2965	12.895	13.265	57498000.0
2013-03-27	META	Stock	25.0	26.28	24.72	26.09	52297400.0
2013-03-27	TSLA	Stock	2.5293	2.5587	2.4873	2.544	19444500.0
2013-03-27	TLT	Stock	118.3	118.77	118.18	118.36	7742886.0
2013-03-27	ES	Stock	42.68	42.89	42.52	42.89	1186700.0
2013-03-27	CL	Stock	58.25	58.48	58.035	58.36	2134800.0
2013-03-27	A	Stock	29.6137	30.1788	29.4778	30.1073	4711120.0
2013-03-27	AABA-DELISTED	Stock	23.54	23.83	23.41	23.59	13436583.0
2013-03-27	AACC-DELISTED	Stock	6.54	6.6	6.52	6.55	42148.0
2013-03-27	AACG	Stock	4.05	4.25	4.0	4.0	3800.0
2013-03-27	AAIC-DELISTED	Stock	25.17	25.5	25.13	25.5	276642.0
2013-03-27	AAMC-DELISTED	Stock	39.8529	39.8529	39.3382	39.7059	16429.0
2013-03-27	AAME	Stock	3.25	3.3	3.25	3.3	4400.0
2013-03-27	AAMRQ-DELISTED	Stock	3.95	4.04	3.81	4.02	4586042.0
2013-03-27	AAON	Stock	8.0385	8.1985	7.9881	8.1333	197775.0
2013-03-27	AAP	Stock	81.02	81.7	80.96	81.64	551000.0
2013-03-27	AAT	Stock	32.36	32.45	31.94	32.31	210800.0
2013-03-27	AAU-DELISTED	Stock	2.2	2.21	2.13	2.13	134735.0
2013-03-27	AAUAF-DELISTED	Stock	2.2	2.21	2.12	2.12	134910.0
2013-03-27	AAV-DELISTED	Stock	3.49	3.57	3.48	3.55	383851.0
2013-03-27	AAWW-DELISTED	Stock	41.45	41.64	41.03	41.17	249452.0
2013-03-27	AAXJ	Stock	58.85	59.1	58.64	59.08	569597.0
2013-03-27	AAXN-DELISTED	Stock	7.95	7.9899	7.8	7.955	387168.0
2013-03-27	AB	Stock	21.66	21.76	21.47	21.65	169700.0
2013-03-27	ABAC-DELISTED	Stock	0.6893	0.71	0.67	0.67	9400.0
2013-03-27	ABAX-DELISTED	Stock	47.08	47.48	46.5801	47.06	82363.0
2013-03-27	ABB-DELISTED	Stock	22.49	22.63	22.42	22.63	1944736.0
2013-03-27	ABBNY-DELISTED	Stock	22.49	22.63	22.42	22.63	2129022.0
2013-03-27	ABBV	Stock	40.22	40.29	39.66	40.15	4274800.0
2013-03-27	ABC-DELISTED	Stock	50.58	50.9	50.33	50.72	1966862.0
2013-03-27	ABCB	Stock	14.33	14.46	14.16	14.42	13600.0
2013-03-27	ABCD-DELISTED	Stock	1.03	1.0301	1.02	1.02	1200.0
2013-03-27	ABCO-DELISTED	Stock	51.43	52.35	50.89	52.35	140498.0
2013-03-27	ABCW-DELISTED	Stock	0.67	0.7	0.67	0.69	43387.0
2013-03-27	ABE-DELISTED	Stock	20.85	20.994	20.4817	20.9244	10473.0
2013-03-27	ABEO	Stock	537.5	562.5	525.0	550.0	10.0
2013-03-27	ABFS-DELISTED	Stock	11.52	11.84	11.48	11.805	185074.0
2013-03-27	ABG	Stock	36.72	36.88	36.35	36.85	172800.0
2013-03-27	ABM	Stock	21.99	22.03	21.82	21.98	98600.0
2013-03-27	ABMD-DELISTED	Stock	18.31	18.84	18.18	18.79	882095.0
2013-03-27	ABR	Stock	7.8	7.84	7.75	7.81	231300.0
2013-03-27	ABR.A-DELISTED	Stock	25.79	25.81	25.79	25.81	775.0
2013-03-27	ABT	Stock	34.13	34.64	34.06	34.61	8637100.0
2013-03-27	ABTL-DELISTED	Stock	4.27	4.604	4.07	4.24	164151.0
2013-03-27	ABUS	Stock	4.7	4.73	4.63	4.66	146000.0
2013-03-27	ABV-DELISTED	Stock	41.57	41.925	41.02	41.84	2212777.0
2013-03-27	ABX-DELISTED	Stock	28.75	29.48	28.65	29.38	9640519.0

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

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