PREVIEW / stock_daily / 2016-03-24

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-24.parquet
  size:    217 KB
  rows:    6,533
  symbols: 3,299

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
2016-03-24	AAPL	Stock	26.3675	26.5625	26.2225	26.4175	104532000.0
2016-03-24	MSFT	Stock	53.84	54.33	53.73	54.21	19950000.0
2016-03-24	NVDA	Stock	0.853	0.8635	0.8502	0.862	244956000.0
2016-03-24	AMZN	Stock	28.3555	29.1775	28.354	29.1475	103710000.0
2016-03-24	GOOGL	Stock	37.56	37.8778	37.525	37.742	31116880.0
2016-03-24	META	Stock	112.13	113.09	111.68	113.05	17839100.0
2016-03-24	TSLA	Stock	14.3853	15.2593	14.3333	15.1833	74413500.0
2016-03-24	TLT	Stock	130.58	130.6425	129.0	129.54	6343287.0
2016-03-24	ES	Stock	57.74	58.29	57.65	57.83	1284300.0
2016-03-24	CL	Stock	69.54	69.96	69.38	69.91	3806000.0
2016-03-24	A	Stock	39.16	39.45	38.89	39.43	993500.0
2016-03-24	AA.B-DELISTED	Stock	31.24	32.28	30.85	32.27	22493.0
2016-03-24	AAAP-DELISTED	Stock	35.86	35.9	32.01	35.0	32489.0
2016-03-24	AABA-DELISTED	Stock	34.45	34.865	33.93	34.86	13552129.0
2016-03-24	AAC-DELISTED	Stock	18.18	18.48	17.99	18.395	108590.0
2016-03-24	AACG	Stock	5.11	5.44	5.04	5.09	49200.0
2016-03-24	AAIC-DELISTED	Stock	13.15	13.5	13.0399	13.49	294071.0
2016-03-24	AAL	Stock	41.88	41.95	40.19	40.5	12515100.0
2016-03-24	AAMC-DELISTED	Stock	3.8971	3.9353	3.75	3.7941	50789.0
2016-03-24	AAME	Stock	4.01	4.1	3.93	4.08	2600.0
2016-03-24	AAMI	Stock	12.12	12.46	11.98	12.45	212600.0
2016-03-24	AAOI	Stock	15.89	16.13	15.4	15.79	375300.0
2016-03-24	AAON	Stock	17.7333	18.0133	17.7333	17.9533	129900.0
2016-03-24	AAP	Stock	160.99	162.04	159.95	161.82	846000.0
2016-03-24	AAT	Stock	37.65	38.33	37.54	38.26	130500.0
2016-03-24	AAU-DELISTED	Stock	0.6745	0.6999	0.664	0.6655	73176.0
2016-03-24	AAUAF-DELISTED	Stock	0.6745	0.6999	0.66	0.66	73717.0
2016-03-24	AAV-DELISTED	Stock	5.05	5.19	5.05	5.14	46253.0
2016-03-24	AAVL-DELISTED	Stock	4.89	5.255	4.77	5.09	203868.0
2016-03-24	AAWW-DELISTED	Stock	40.39	40.9	39.66	40.72	158239.0
2016-03-24	AAXJ	Stock	53.13	53.46	53.01	53.46	667459.0
2016-03-24	AAXN-DELISTED	Stock	18.28	18.41	18.1	18.27	587205.0
2016-03-24	AB	Stock	22.09	22.28	21.97	22.27	212100.0
2016-03-24	ABAC-DELISTED	Stock	0.7085	0.71	0.7085	0.71	450.0
2016-03-24	ABAX-DELISTED	Stock	41.77	42.22	41.585	42.19	78908.0
2016-03-24	ABB-DELISTED	Stock	18.8	18.94	18.78	18.93	1247262.0
2016-03-24	ABBNY-DELISTED	Stock	18.8	18.94	18.78	18.93	1313099.0
2016-03-24	ABBV	Stock	56.14	56.25	55.67	56.12	5278900.0
2016-03-24	ABC-DELISTED	Stock	86.86	87.23	85.9499	86.205	2237853.0
2016-03-24	ABCB	Stock	28.51	29.3	28.06	28.79	110500.0
2016-03-24	ABCD-DELISTED	Stock	4.28	4.35	4.23	4.31	11555.0
2016-03-24	ABCO-DELISTED	Stock	30.38	30.74	29.8	30.63	283571.0
2016-03-24	ABCW-DELISTED	Stock	43.11	44.26	43.11	44.26	209976.0
2016-03-24	ABDC-DELISTED	Stock	10.98	11.53	10.98	11.49	20537.0
2016-03-24	ABE-DELISTED	Stock	11.05	11.34	11.05	11.23	3988.0
2016-03-24	ABEO	Stock	65.25	72.0	62.75	66.75	7312.0
2016-03-24	ABEV	Stock	5.08	5.16	5.07	5.12	29371700.0
2016-03-24	ABG	Stock	59.08	59.9	58.23	59.81	291400.0
2016-03-24	ABGB-DELISTED	Stock	1.49	1.49	1.4	1.4	6450.0
2016-03-24	ABIL-DELISTED	Stock	6.57	6.58	6.38	6.56	7982.0

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

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