phpmyadmin SQL platform (SQL Coding)

I am attaching a file that contains table structure and test data of about 5 rows. CREATE TABLE `temp2` ( `Date` date NOT NULL, `ShortName` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `Number` int(6) NOT NULL, `LongName` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `Open` double NOT NULL, `High` double NOT NULL, `Low` double NOT NULL, `Close` double NOT NULL, `Volume` bigint(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; Although only 4 columns (Date, ShortName, Close, Volume) are relevant, yet I have sent complete structure of the table. This table will contain about 600 rows per day and will have data of about 15 years. Requiredment: I want to find out that which 'ShortName' has continuously increased 'Close' price and also increased the volume for variable number of days that will be selected at the time of running query. For example 4 days. from todays date backward meaning thereby most recent days. if price has increased and volume has not increased or vice-versa within those days, that 'ShortName' should not be selected. Please note that dates have breaks of holidays in between. I would prefer single statement query to be run from phpmyadmin SQL platform.